JBoss / Hibernate / BMP (CMT) / DB2 / JDBC - DB locks are no

[balellu]

I am using

>>>JBoss-3.2.5
>>>Hibernate-2.0.3
>>>BMP with CMT EJB's - Using requires transaction attribute. EJB's use Hibernate
>>>DB2-8.1.7

I have a situation where Hibernate is used to create insert there records into DB and creating three entity beans for each record.

Once the above process is complete i am invoking a JDBC call to get some information from the same table where hibernate has inserted three new records. Once i try to execute the query through JDBC, app just hangs.

When i monitor the connections in the DB2 i can see lock waiting and when i kill the connection that is creating the lock then app resumes with exception.

Now i am trying to figure out where the problem could be? Can some one please help me with this.

Thanks.

[balellu]

There has been lot of discussion on this item under 'JBoss Transaction' forum. The discussion is still open.

Please check out the below url

http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964303#3964303

Thanks.

[balellu]

This problem is resolved please check the below URL.

http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964890#3964890

Thanks