Thread: com.mysql.jdbc.exceptions.MySQLIntegrityConstraint ViolationException:

Hi all,
This is the exception i m getting when trying to insert a record into a table of MySQL through Java JDBC :
com.mysql.jdbc.exceptions.MySQLIntegrityConstraint ViolationException: Duplicate entry '539763' for key 'PRIMARY'

I checked with the table but i don't find any entry with this value

The column on which the exception was raised is an auto_incremented and primary key at the database level.

Not knowing what could be the issue.

Can somebody help me in resolving this issues

Thanks n Regards
Raaj

Originally Posted by copeg

Based upon the error message you are trying to insert a duplicate value into a column which constrains the entries to be unique - its not JDBC which is raising the exception by MySQL. Are you defining the primary key column, or letting the database auto increment the value? Perhaps you might get a faster response on a dedicated MySQL forum

Hi ,
Thanks for ur quick reply.

The construction of the table is as follows:

CREATE TABLE `customer_claim_history` (
`customer_claim_history_id`INT(11) NOT NULL AUTO_INCREMENT,
`customer_claim_id` INT(11) NULL ,
`account_id` INT(11) NULL ,
`provider_datatype_id` INT(11) NULL,
`claim_number` VARCHAR(255) NULL,
`invoice_number` VARCHAR(255) NULL,
`normalized_data` MEDIUMTEXT NULL,
`job_id` INT(11) NULL,
PRIMARY KEY (`customer_claim_history_id`)
)

I found everything fine with MySQL. When i fired the following query in MYSQL "select MAX(customer_claim_history_id) from customer_claim_history" i got the result as

'539762'

but the exception says that com.mysql.jdbc.exceptions.MySQLIntegrityConstraint ViolationException: Duplicate entry '539763' for key 'PRIMARY'

I don't find any entry with the value '539763' in the above constructed table.


Please help me in knowing what could be issue.

Thanks n Regards
Raaj

Ever tried to change the primary key of int to integer?

Originally Posted by Luciano_Lopes

Ever tried to change the primary key of int to integer?

Hey somebody please help me...i got stucked with this issue.

Thanks n Regards

Raaj