com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException

[raghu tammina]

Hi ,

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

my source code is

static public boolean executeBooleanQry(String qry, HttpSession session) throws Exception {

		java.sql.Connection con = null;
		java.sql.Statement stat = null;
		boolean result = false;
		try {

			con = ConnectionString.getConnection((String) session
					.getAttribute("datasource"));
			stat = con.createStatement();
			 
			stat.executeUpdate(qry);
			result=true;

		} catch (SQLException e) {
			e.printStackTrace();
		} catch (NamingException e) {
			e.printStackTrace();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {

				if (stat != null) {
					stat.close();
					stat = null;
				}
				if (con != null) {
					con.close();
					con = null;
				}
			} catch (java.sql.SQLException e) {

			}
		}
		return result;
	}

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]

Moving this to the JDBC forum for you.

[Emanuel Kadziela]

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.