Caused by: java.sql.SQLException: Syntax error or access violation, message from
server: "You have an error in your SQL syntax near 'SELECT TXID FROM JMS_TRANSACTIONS)
AND TXOP='A'' at line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2090)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1680)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1527)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:324)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:309)
... 68 more
2004-04-06 11:25:56,859 WARN [org.jboss.system.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: (java.sql.SQLException: Syntax error
or access violation, message from server: "You have an error in your SQL syntax near
'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1")
please advice to sole this issue
regards
manoj
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3829367#3829367
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3829367
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
