[jboss-user] [JCA/JBoss] - Setting isolation level for certain Connection

[kkrivopustov]

Hello,
I use Hibernate with JBoss EJB3 session beans, and I need to decrease isolation level for some method to eliminate a concurrency issue. 

Is it possible to get the Connection from current Hibernate session, set appropriate isolation level, make call to database through this connection, and close it?

As I understand, when I close Connection, it is returned into connection pool. When next EJB method gets this connection from the pool, will it be set to my last isolation level or to default (set in *-ds.xml)?
So is it correct to set isolation level for pooled connection?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4027645#4027645

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4027645