5 Replies Latest reply on Mar 26, 2008 4:26 AM by solar_sea

    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.