Hibernate Version : 3.2.4.sp1
Database : Oracle 9i
OS : ES3
Java VM 1.5 (Jrocket)


Hi all,
I have a very strange issue with Hibernate and C3PO.
From time to time C3PO seem to leak or loose connections, it seems when the end user commits/saves some work the transaction is never committed to the DB when I have a look at the Oracle system I can see some sessions that always remain active the current sql being an update statement.

There are no blocking locks in the DB or dead locks in the JVM.

Funny thing is this seem to work when using hibernates own built in connection pool.

So any help would be good :)

Edit:

I am using the session per thread pattern,