I've got an identical webapp running under Netbeans' integrated Tomcat server and my production server (using Hibernate3 and MySQL).

For some unknown reason, when I try inserting data on the production machine no records seem to get commited (almost looks like an unflushed session) whereas under the Netbeans server it works fine.

I tried FLUSH TABLES under MySQL, or killing the connections but nothing seems to help. Any idea what could be causing this?

Thanks,
Gili

I tracked this down to jta-1.0.1.jar in /common/lib in my production machine. If I remove it, commits go through just fine.

Unfortunately I cannot remove that file because JIRA depends upon it being in /common/lib. Does anyone have any ideas why the presence of this file would cause problems? My Hibernate application is using JDBC, not JTA, so in theory it shouldn't be affected by this JAR.

Fixed!

Was aparently caused by two seperate issues:

1) My web-inf/lib still contained Hibernate2 dependencies -- I had to update them

2) Tomcat was running out of memory during the operation of my application. I've increased the maximum memory limit.

Thanks anyway ;)
Gili