Details
-
Bug
-
Resolution: Can't Do
-
Minor
-
None
-
JBossAS-4.0.3 SP1, JBossAS-4.0.4RC1
-
None
Description
Microsoft SQL Server 2005 JDBC Driver
http://www.microsoft.com/downloads/details.aspx?familyid=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en
the datasource is a copy of the example available in the following wiki
http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAMSSQLDatasource
The problem occurs only after the tables are already created in the database i.e on the second and subsequent startups.
2006-03-08 17:58:00,969 TRACE [org.jboss.resource.connectionmanager.TxConnectionManager] commit problem:
2006-03-08 17:58:00,969 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
2006-03-08 17:58:00,969 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2006-03-08 17:58:00,969 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:545)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:75)
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:872)
at org.jboss.tm.TransactionImpl$Resource.commit(TransactionImpl.java:2250)
at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1781)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:337)
at org.jboss.tm.TxManager.commit(TxManager.java:239)
at org.jboss.mq.sm.jdbc.JDBCStateManager$JDBCSession.close(JDBCStateManager.java:613)
at org.jboss.mq.sm.jdbc.JDBCStateManager.initDB(JDBCStateManager.java:465)
at org.jboss.mq.sm.jdbc.JDBCStateManager.startService(JDBCStateManager.java:378)
2006-03-08 17:58:01,119 TRACE [org.jboss.resource.connectionmanager.TxConnectionManager] commit problem:
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:545)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.commit(LocalManagedConnection.java:75)
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:872)
at org.jboss.tm.TransactionImpl$Resource.commit(TransactionImpl.java:2250)
at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1781)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:337)
at org.jboss.tm.TxManager.commit(TxManager.java:239)
at org.jboss.mq.pm.jdbc2.PersistenceManager$TransactionManagerStrategy.endTX(PersistenceManager.java:215)
at org.jboss.mq.pm.jdbc2.MSSQLPersistenceManager.createSchema(MSSQLPersistenceManager.java:99)
at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1563)
at org.jboss.mq.pm.jdbc2.MSSQLPersistenceManager.startService(MSSQLPersistenceManager.java:240)
I've tested against MS SQL Server 2000SP4....which might explain why it breaks
NB: this problem does not exist when I use SQL Server 2000 Driver for JDBC Service Pack 3