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) . . . View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3849356#3849356 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849356 ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user