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

[Rajesh Rajasekaran (JIRA)]

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
             Fix For: JBossAS-4.2.0.GA


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

-- 
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