[
http://jira.jboss.com/jira/browse/JBAS-2844?page=comments#action_12348079 ]
Aladdin El-Nattar commented on JBAS-2844:
-----------------------------------------
I'm seeing the same SpyJMSException using jboss-4.0.5.GA and the bundled
mssql-jdbc2-service.xml.
I'm overriding DefaultDS with a SQL Server 2000 DS, so I had to change the DS name to
DefaultDS in mssql-jdbc2-service.xml, but that's the only modification I made to that
file.
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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira