On Fri, 15 Feb 2008, erosik wrote:
i am using ibatis in my jsp application, i have created db with a
unique field (e.g. id) so when i insert a record with same id again i m
getting error like this, can any one help to sort out this exception
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
Duplicate
entry '123' for key 1
Sort out how?
If you have more than one 'id' with value '123' then you cannot use the
unique constraint. You need to alter the schema of the database to remove
it.
--
Graeme -
