[jboss-jira] [JBoss JIRA] Commented: (JBAS-2844) JMS PersistenceManager: Could not resolve uncommited transactions using MS SQL Server

[Aladdin El-Nattar (JIRA)]

    [ 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