Catch duplicate entry Exception

Question

How can i catch this Exception :

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:                                        Duplicate entry '22-85' for key 'ID_CONTACT' 

Answer 1

I use spring so we resolve it by org.springframework.dao.DataIntegrityViolationException

try {     ao_history_repository.save(new AoHistory(..)); } catch (DataIntegrityViolationException e) {     System.out.println("history already exist"); } 

But as @KevinGuancheDarias mention it:

Please note that while this works. I suggest to solve the problem by issuing a findBy before the save, as this is messy, and I think it's not warranted that it will work in future versions, may even break without notification.

Answer 2

catch SQLIntegrityConstraintViolationException, if you are using Java 1.6+

e.g.

try {     ps.executeUpdate("INSERT INTO ..."); } catch (SQLIntegrityConstraintViolationException e) {     // Duplicate entry } catch (SQLException e) {     // Other SQL Exception } 

or

try {     ps.executeUpdate("INSERT INTO ..."); } catch (SQLException e) {     if (e instanceof SQLIntegrityConstraintViolationException) {         // Duplicate entry     } else {         // Other SQL Exception     } }