[jboss-user] [JBoss Messaging] - Issues with JBM 1.4.0 SP3 and MSSQL 2005 express edition

I've installed jbm 1.4.0 sp3 on jboss 4.2.2 (manual installation) and it works with hsqldb-persistence-service.xml. Testing it with mssql-persistence-service.xml fails. I'm using mssql 2005 express edition. The exact warning is 09:29:00,718 WARN [JDBCSupport] SQLException caught, SQLState 25000 code:0- assuming deadlock detected, try:1 | java.sql.SQLException: commit() should not be called while in auto-commit mode. This repeats 25 times, then the transaction fails and several queues fail to start up. The exception is caused by "467: conn.commit();" in JDBCSupport.java What puzzles me is that few lines above "456: conn.setAutoCommit(false);" this line seems to work and doesn't throw any exceptions. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4138865#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...