I am currently developing a product using Hibernate, DB2 and JBoss and I am experiancing deadlock The difficult part of the problem is that it locks on a various tables at different times. I am using TRANSACTION_REPEATABLE_READ as my transaction isolation level, and Spring Framework utilities to fit into our DAO pattern. Our datamodel is fairly complex and our transactions are fairly long (2-4 sec on current hardware/test env). Short of dumping all of our code on the forum, I just wanted to ask if anybody has had deadlock with db2/hibernate/jboss/spring, and if/how they fixed it.

Thanks,
Aaron

(I understand that this may not be enough information to provide a concrete resolution, I just wanted to get some suggestions for where to look.)

I do not use DB2 at this time, but it was a very common problem on "old"
DB2 versions and it was caused by uncommited transactions.

Happens all the time.

At the DB2 command prompt type "force application all".