wood burning stoves 2.0*
The moose likes JBoss/WildFly and the fly likes Configuring the Datasource forJBOSS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Configuring the Datasource forJBOSS" Watch "Configuring the Datasource forJBOSS" New topic
Author

Configuring the Datasource forJBOSS

sonyia nandan
Greenhorn

Joined: Feb 11, 2004
Posts: 14
This is the error i got when i hangd my defaultDS to MySQl.I am unable to understand where i have gone wrong

Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1825)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1020)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1109)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2030)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1750)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1596)
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-02-19 16:28:01,011 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. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT TXID FROM JMS_TRANSACTIONS) AND TXOP='A'' at line 1")
at
sonyia nandan
Greenhorn

Joined: Feb 11, 2004
Posts: 14
problem got solved
Leiser Acosta
Greenhorn

Joined: May 10, 2004
Posts: 1
how did you solve this problem???
B Wiley Snyder
Ranch Hand

Joined: Nov 26, 2003
Posts: 50
Please tell us how you solved it!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Configuring the Datasource forJBOSS