Just a general heads up: recently we added the following line to our datasource config files in an attempt to reduce deadlock errors from MS SQL Server 2000:
<transaction-isolation>TRANSACTION_READ_UNCOMMITTED</transaction-isolation> After putting this in place, we started seeing major problems with blocking queries. I noticed a bunch of un-balanced "BEGIN TRAN" messages in SQL Profile just after "set transaction isolation mode" messages. So I think perhaps this setting was causing Jboss to leave a bunch of transactions open. I don't know if this is a bug in Jboss or what. Has anyone else experienced similar problems? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3952768#3952768 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3952768 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
