Hi,

I'm using Hibernate with JTA without problem in several projects, but I'm facing problems using Hibernate with JDBC transactions :

When inserting/updating a row, I'm forced to use
session.beginTransaction().commit() in the end of my code.
If I don't, nothing is done. Even when calling session.connection().setAutoCommit(true) before the operation.

There must be some obvious reason but I just I can't see...
Please, can someone explain me this behaviour ? I have found no clue in the forum...
Thank you for your help.

I'm using Hibernate 3.0.5 / Tomcat 5.0.28 / PostgreSQL 8.1 / JDBC driver build 404


Best regards.
--
Xavier Bugaud

session.beginTransaction().commit() starts and commits the transaction in one line of code. try starting the transaction, actually doing work, and then committing .

maybe you can elaborate on how jta is being used here?

Hi Dennis,

Thank you for answering.


In my other projects, I use the JOTM transaction manager inside the Jonas container.


According to the API doc, session.beginTransaction().commit() start a new transaction only if necessary, so I guess there is already an existing transaction when I'm calling session.beginTransaction(), don't you think ?

The following code actually works :


But I just can't explain why session.connection().setAutoCommit(true) does not work...


Best regards.
--
Xavier Bugaud

can you show me where it says this?

the code that "actually works" is what I meant in the first response.

Here : http://www.hibernate.org/hib_docs/v3/ap ... ansaction()

(...) If a new underlying transaction is required, begin the transaction. Otherwise continue the new work in the context of the existing underlying transaction. (...)

Sorry, I just realize there is a typo in my previous message : I wanted to say session.beginTransaction() instead of session.beginTransaction().commit().

But do you know why session.connection().setAutoCommit(true) does not automatically commit the transaction ? Is this a bug ?

Best Regards.
--
Xavier Bugaud

The setAutoCommit is turned off in the JDBCTransaction code because there are certain cleanup tasks that need to be done after the commit. Setting autoCommit does not give Hibernate an oppurtunity to do those.
Check net.sf.hibernate.transaction.JDBCTransaction's beginTransaction method where this is turned off.