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

[Aladdin El-Nattar (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBAS-3919?page=comments#action_12348121 ] 
            
Aladdin El-Nattar commented on JBAS-3919:
-----------------------------------------

I'm getting this error on JBoss 4.0.5.GA using the bundled mssql-jdbc2-service.xml.

I'm using SQL Server 2000 on Windows 2003 Server.

> CLONE -JMS PersistenceManager: Could not resolve uncommited transactions using MS SQL Server
> --------------------------------------------------------------------------------------------
>
>                 Key: JBAS-3919
>                 URL: http://jira.jboss.com/jira/browse/JBAS-3919
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: JMS service
>            Reporter: Aladdin El-Nattar
>         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