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

jaikiran do-not-reply at jboss.com
Thu Mar 20 07:04:39 EDT 2008

Since the data is not yet committed, the select statement is blocked to avoid reading stale data. In MSSQL server, there's a option to provide a nolock hint to the server through the select query. However AFAIK, MySQL doesn't have such a hint. Try doing this:

set transaction isolation level READ UNCOMMITTED; 
  | select * from MyEntity where id = 1;	

See if it works.

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

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

More information about the jboss-user mailing list