[jboss-jira] [JBoss JIRA] Resolved: (JBAS-4225) Error starting up jbossmq PersistenceManager with Sybase

Error starting up jbossmq PersistenceManager with Sybase -------------------------------------------------------- Key: JBAS-4225 URL: http://jira.jboss.com/jira/browse/JBAS-4225 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: JMS service Reporter: Rajesh Rajasekaran Assigned To: Adrian Brock Priority: Blocker Fix For: JBossAS-5.0.0.Beta2, JBossAS-4.2.0.GA, JBossAS-4.0.5.SP1 Attachments: JBoss_Sybase_settings.zip Looks like a SQL error when creating the JMS tables with sybase. I have attached the sybase specific files needed to reproduce this issue with the jboss default config 1. Copy sybase-ds.xml under deploy dir. (delete hsqldb.xml) 2. Copy sybase-jdbc2-service.xml under deploy/jms (delete hsqldb-jdbc2-service.xml) 3. Copy jconn2.jar under lib The configurations connect to the sybase instance in the QA lab. 16:25:23,328 WARN [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: (com.sybase.jdbc2.jdbc.SybSQLException : The derived table expression is missing a correlation name. Check derived table syntax in the Reference Manual. ) at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:492) at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1809) 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:585) 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:585) Caused by: com.sybase.jdbc2.jdbc.SybSQLException: The derived table expression is missing a correlation name. Check derived table syntax in the Reference Manual. at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:3178) at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2481) at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203) at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1611) at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1596) at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:96) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:424) ... 111 more