JMS PersistenceManager: Could not resolve uncommited transactions using MS SQL Server ------------------------------------------------------------------------------------- Key: JBAS-2844 URL: http://jira.jboss.com/jira/browse/JBAS-2844 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: JMS service Reporter: Luc Texier Assigned To: Luc Texier Fix For: JBossAS-4.0.4.CR2 Original Estimate: 1 hour Remaining Estimate: 1 hour using mssql-jdbc2-service.xml from /examples/jms this warn is logged during a restart 2006-02-23 16:14:40,528 WARN [org.jboss.system.ServiceController] Problem starting service jboss.mq:service=PersistenceManager org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near ')'.) at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:442)