Hi,

I am using Spring 1.2.8 Hibernate 3.1 and MySQL.

The transactions are managed using Spring. I am facing a problem where transactions are not comitted to the database.

I have seen the logs and the queries generated by Hibernate. The Logs show that a Transaction is created comitted and closed. The Hibernate SQL queries show INSERTS in the database.

I have been trying to find out the cause and have posted detailed questions here...

http://forum.springframework.org/showthread.php?t=28818

http://forum.springframework.org/showthread.php?t=28796

After, I added auto_commit="true" in the ibernate.cfg.xml file, it has started working fine i.e. I could see the INSERTED records in the tables, but I am not sure how appropriate would it be to use auto_commit. I am handling a system which carries out financial transactions.

Any help would be highly appreciated.

Best Regards,
Shardul Bhatt.