I have a hibernate session that executes a stored procedure, call a few named queries some of which are selects and updates and I use the criteria API aswell. The same handful of tables are either been selected or updated in the session. I have the code all in between a session.beginTransaction() and a commit. But the code hangs due to database locking tables. I need to execute code do selects on the dirty data which may need a further update. And then commit the lot. The only way I can get a stuff to work is commit at different points. I do not want to do this. Any advice?
Its the criteria API that hangs. I have set autocommit to be be off and set transaction isolation to read uncommiitted