I have tried both the Container Managed Txn and Bean managed txn with the Same setup(sqlserver 2000 and JBOSS3.0) for a session bean and out of around 50 calls and Prepared statements 3 are locking .But the entity beans are working properly with transaction. Is it mandatory to use Session Synchronisation interface ?????
I have tried with java.sql and for the same table it works fine form my code.
Where is that JDBC persistence manager coming from? Why are you not looking up JBoss datasources from the JNDI?