This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException" Watch "com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException" New topic


raghu tammina
Ranch Hand

Joined: Jul 11, 2012
Posts: 60
Hi ,

I am using struts with myecllipse, i am getting the exception com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException

my source code is

I created a table in mysql as follows

CREATE TABLE `tab_ats_backlogymapper` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lable` varchar(100) NOT NULL,
`col_num` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`,`lable`),
UNIQUE KEY `Index_2` (`col_num`)
Help me how to handle it?

Stacktrace: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '2' for key 'Index_2'
Bill Gorder

Joined: Mar 07, 2010
Posts: 1682

Moving this to the JDBC forum for you.

[How To Ask Questions][Read before you PM me]
Emanuel Kadziela
Ranch Hand

Joined: Mar 24, 2005
Posts: 187
It appears you are trying to insert a row with col_num value of 2 into the table which already contains a row with col_num value of 2, and you have defined a unique constraint over that column which this query is violating. Either remove the constraint, or make sure you are not trying to enter the same value more than once into a column which is constrained.
I agree. Here's the link:
subject: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException
It's not a secret anymore!