Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate and Lonmg Sessions

 
Ally Cavs
Ranch Hand
Posts: 95
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Guys

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

Alan
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic