[
http://jira.jboss.com/jira/browse/JBAS-4225?page=comments#action_12356940 ]
Rajesh Rajasekaran commented on JBAS-4225:
------------------------------------------
I didnt get a proper usage from the reference manual but from the error "The derived
table expression is missing a correlation name", the following sql, when i tried
worked.
SELECT MAX(TX.TXID) FROM (SELECT MAX(TXID) AS TXID FROM dbo.JMS_TRANSACTIONS UNION SELECT
MAX(TXID) AS TXID FROM dbo.JMS_MESSAGES) TX
Should i commit this?
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-4.2.0.GA
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