Hi, friends:
i am useing jboss3.2.1, mysql4.0.
after i set up mysql datasource, connection is ok. but jboss gives me the following error messages. i also did a little search. some people has the same problem and solved it by modifying some config/setting files. but i don't know which ones.
does this problem in FAQ or any links?
thanx in advance.
12:26:39,828 INFO [PersistenceManager] Starting
12:26:39,843 ERROR [STDERR] Query "SET autocommit=0" execution time: 0
12:26:39,890 WARN [WrappedConnection] Closing a statement you left open, please do your own housekeeping
12:26:39,890 WARN [WrappedConnection] Closing a statement you left open, please do your own housekeeping
12:26:39,890 ERROR [STDERR] Query "rollback" execution time: 0
12:26:39,890 ERROR [STDERR] Query "SET autocommit=1" execution time: 0
12:26:39,890 ERROR [STDERR] Query "SHOW VARIABLES LIKE 'tx_isolation'" execution time: 0 result set fetch time: 0
12:26:39,890 ERROR [PersistenceManager] Starting failed
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 org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:276)
at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1299)
.
.
.