Re: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationExc eption

[Graeme J Sweeney <ib...@gjsweeney.com>]

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 -