Am I using the wrong ...-state-service.xml ? I basically modified the hsqldb-jdbc-state-service.xml to use the MSSQL 2005. It seems like the error has nothing to do with the SQL statements in the xml rather something hardcoded...

Getting the exception below:

10:53:46,347 WARN [ServiceController] Problem starting service jboss.mq:service=StateManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested thro
wable: (com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.)
    at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs (PersistenceManager.java:495)
    at org.jboss.mq.pm.jdbc2.PersistenceManager.startService (PersistenceManager.java:1809)
    at org.jboss.mq.pm.jdbc2.MSSQLPersistenceManager.startService (MSSQLPersistenceManager.java:230)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalStart (ServiceMBeanSupport.java:289)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle (ServiceMBeanSupport.java:245)
    at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke (Method.java:597)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch (Invocation.java:94)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:659)
    at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
    at $Proxy0.start(Unknown Source)
    at org.jboss.system.ServiceController.start (ServiceController.java:417)
    at org.jboss.system.ServiceController.start (ServiceController.java:435)
    at org.jboss.system.ServiceController.start (ServiceController.java:435)
    at org.jboss.system.ServiceController.start (ServiceController.java:435)
    at org.jboss.system.ServiceController.start (ServiceController.java:435)
    at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke (Method.java:597)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch (Invocation.java:94)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke (MBeanProxyExt.java:210)
    at $Proxy4.start(Unknown Source)
    at org.jboss.deployment.SARDeployer.start (SARDeployer.java:302)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke (Method.java:597)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch (Invocation.java:94)
    at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:88)
    at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:88)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke (MBeanProxyExt.java:210)
    at $Proxy51.start(Unknown Source)
    at org.jboss.deployment.XSLSubDeployer.start (XSLSubDeployer.java:197)
    at org.jboss.deployment.MainDeployer.start (MainDeployer.java:1025)
    at org.jboss.deployment.MainDeployer.deploy (MainDeployer.java:819)
    at org.jboss.deployment.MainDeployer.deploy (MainDeployer.java:782)
    at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke (Method.java:597)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch (Invocation.java:94)
    at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:88)
    at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:88)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke (MBeanProxyExt.java:210)
    at $Proxy9.deploy(Unknown Source)
    at org.jboss.deployment.scanner.URLDeploymentScanner.deploy (URLDeploymentScanner.java:421)
    at org.jboss.deployment.scanner.URLDeploymentScanner.scan (URLDeploymentScanner.java:634)
    at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
    at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService (AbstractDeploymentScanner.java:336)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalStart (ServiceMBeanSupport.java:289)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle (ServiceMBeanSupport.java:245)
    at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke (Method.java:597)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch (Invocation.java:94)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:659)
    at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
    at $Proxy0.start(Unknown Source)
    at org.jboss.system.ServiceController.start (ServiceController.java:417)
    at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke (Method.java:597)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch (Invocation.java:94)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke (MBeanProxyExt.java:210)
    at $Proxy4.start(Unknown Source)
    at org.jboss.deployment.SARDeployer.start (SARDeployer.java:302)
    at org.jboss.deployment.MainDeployer.start (MainDeployer.java:1025)
    at org.jboss.deployment.MainDeployer.deploy (MainDeployer.java:819)
    at org.jboss.deployment.MainDeployer.deploy (MainDeployer.java:782)
    at org.jboss.deployment.MainDeployer.deploy (MainDeployer.java:766)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke (Method.java:597)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch (Invocation.java:94)
    at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:88)
    at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)
    at org.jboss.mx.server.Invocation.invoke (Invocation.java:88)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke (MBeanServerImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke (MBeanProxyExt.java:210)
    at $Proxy5.deploy(Unknown Source)
    at org.jboss.system.server.ServerImpl.doStart (ServerImpl.java:482)
    at org.jboss.system.server.ServerImpl.start (ServerImpl.java:362)
    at org.jboss.Main.boot (Main.java:200)
    at org.jboss.Main$1.run(Main.java:508)
    at java.lang.Thread.run (Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
    at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery (WrappedPreparedStatement.java:236)
    at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs (PersistenceManager.java:427)
    ... 112 more

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4065516#4065516

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4065516
_______________________________________________
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user