Environment: Tomcat 5.5.12 (no JTA)
JVM: Sun JDK 1.5.0_6
Database: Oracle 10g 1


I've got a problem with Hibernate 3.2rc2 + Hibernate Annotaions 3.2 rc1 (when I'd used Hibernate 3.0.5 in my previouse project there was not such a problem):

In both projects (my current project and previous project) I called session.connection() to get the current connection, and then used it to create a CallableStatement to call my stored procedures.

My stored procedures update the database state, so there must be a commit instruction after their execution.

In my previous project with hibernate 3.0.5 when I commited the Hibernate transaction the modifications of the stored procedure were committed to database too, but in Hibernate 3.2rc2 they are not!

Has anybody have the same problem, how to solve it?

I've logged org.hibernate.transaction category using log4j, it is logged that jdbc transactions are commited, but unfortunately they don't update database state!

well I've found the problem

when I disable c3p0 connection pool the problem woulld be solved, so is it a bug of connection pool?