Hibernate version: 2.1

I am using spring + hibernate + c3p0 and I am having issue when inserting a record with duplicate key (on purpose).

I traced the sequence of events down to this:

1. insert dup key record

2. db throws PSQLException: ERROR: duplicate key violates unique constraint

3. c3p0 "see" the exception and abandon the connection:

[c3p0] A PooledConnection died due to the following error!
org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint

4. transaction manager "see" the exception and rollback

5. roll back failed because the connection was abandoned in 3 above.


Is this a configuration issue ? I think c3p0 should not abandon connection under certain conditions (like constraint violation).

Thanks in advance for helping.

-cs

the lastest version of c3p0 resolved this issue.

-cs