0 Replies Latest reply on Sep 23, 2004 5:56 PM by Ye Tang

    jboss error on persistencemanager after switching from hyper

    Ye Tang Newbie

      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)
      .
      .
      .