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

[Adrian Brock (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBAS-4225?page=all ]

Adrian Brock resolved JBAS-4225.
--------------------------------

    Fix Version/s: JBossAS-5.0.0.Beta2
                   JBossAS-4.0.5.SP1 
       Resolution: Done

This has been done.
The NULL and NOT NULL issue is resolved on the subtask.

> 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

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