Java MYSQL having trouble catching MySQLIntegrityConstraintViolationException

Question

I can't seem to catch this exception, Eclipse tells me that it "cannot be resolved to a type". I know this exception means that I'm trying to INSERT a duplicate key value, and I want to catch it and let the user know.

Is there an import or a jar that I'm missing?

Thanks :)

Leos Literak · Accepted Answer · 2014-03-03 09:00:37Z

1

You must include mysql JDBC jar into your class path first. Get it here http://dev.mysql.com/downloads/connector/j/5.0.html

answered Mar 3, 2014 at 9:00

Leos Literak

9,46022 gold badges98 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Doron z Over a year ago

Works, thanks :) For anyone who might encounter the same issue: I added both mysql-connector-java-5.0.8-bin.jar and mysql-connector-java-5.0.8-bin-g.jar (not sure which one did the trick), and was then able to import com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException

Leos Literak Over a year ago

Two notes: 1) catching vendor exceptions makes your code unportable to other vendors 2) this jar used to be released under GPL, which is viral. IANAL but be aware that your code might be GPL as well

Doron z Over a year ago

follow up: the jar allowed me to import com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException, and I've been going crazy since it still won't catch my exception. Then I noticed that the exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException --- what is the extra jdbc4? do I need yet another jar?

Leos Literak Over a year ago

try newer Connector jar, at least 5.1.1 version, or take latest

Collectives™ on Stack Overflow

Java MYSQL having trouble catching MySQLIntegrityConstraintViolationException

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related