I am using CMP EJB3 on Jboss 4.2, my tables are getting locked while CMP process is getting executed. If I use BMP then there is no such locking.
My database server is SQL Server 2005 and I have the following settings in the persistance.xml file
<persistence> <persistence-unit name="foo"> <jta-data-source>java:/fooDS</jta-data-source><properties> <property name="hibernate.hbm2ddl.auto" value="none" /> <property name="hibernate.ejb.cfgfile" value="/hibernate.cfg.xml" /> <property name="hibernate.connection.isolation" value="2" /> </properties> </persistence-unit> </persistence>