Hi,

I'm using JBoss, Hibernate and MySql and I have the following problem:

My project has a bean, in a SessionFactory, that needs to remove some POJOs and than needs to run a method in another bean, in another SessionFactory. This second bean removes one POJO, that is present in the POJOs removed by the first bean, because it apears in that POJOs as a many-to-one relatioship. In this case, when I try to remove the POJO from the second bean, the SQL command, ran by hibernate, is deadlocked and returns a timeout error. Than, nothing is removed, because the transactions are rollbacked. I need to know how can I remove these POJOs, without the deadlock problem.

thanks in advance,

Why do you have two session factories to the same datasource? You should have only one. You can have two sessions though.

If you have locking issues, it's because the first connection hasn't committed its transaction, thus releasing all locks. Ensure that you're doing that. If you're expecting to be able to concurrently delete from a table using one session then insert into that table in another session, then the problem is your expecetion. You'll have to change it.