[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: newbie: em.flush() is locking a select statement

mars1412 do-not-reply at jboss.com
Thu Mar 20 07:59:57 EDT 2008

ah, thanks
you pointed me in the right direction

after some investigations I found out, that the READ_COMMITED transaction isolation level behaves differently between oracle and MS Sql server.

SQL Server uses shared locks by default. Thus the select statement is blocked while the update is not commited yet.

If you set READ_COMMITTED_SNAPSHOT to ON for your database, then it uses row-versioning (like Oracle's default mode): and the select will not be blocked until the update is commited.
I think this behaviour can improve performance on my webapplication.

more information on this:

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

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

More information about the jboss-user mailing list