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

[solar_sea]

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#4138865

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