HI:
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=3849180#3849180
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849180
-------------------------------------------------------
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
