Bug #65904 Connector/J (JDBC): Special exception subclass for duplicate key constraint
Submitted: 16 Jul 2012 2:01 Modified: 5 Nov 2022 1:51
Reporter: Ondra Zizka Email Updates:
Status: Won't fix Impact on me:
None 
Category:Connector / J Severity:S4 (Feature request)
Version:5.1.21 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[16 Jul 2012 2:01] Ondra Zizka
Description:
Violating duplicate key constraint is quite common state. For example, when processing unreliable source of data, user can rely on this to detect attempts to process items which were already processed in the past.

How to repeat:
Currently, this is thrown: 

    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
    Duplicate entry '<93288773.13-7-2012-4-08-04.RTMail@foobar.com>' for key 'srcId'

Suggested fix:
.
I suggest to create a subclass,

MySQLDuplicateConstraintViolationException extends MySQLIntegrityConstraintViolationException

to allow users easily diferentiate this case.
[16 Jul 2012 4:04] Valeriy Kravchuk
Thank you for the feature request.
[5 Nov 2022 1:51] Filipe Silva
Not applicable since there's no JDBC Exception for this behavior.