2 Replies Latest reply on Jul 26, 2002 5:55 AM by Joel Vogt

    mySQL JDBC Persistance Error

    kenny Newbie

      Hi all,

      I've been trying for a long time to use the JDBC Persistance Manager to store messages to mySQL tables, but to no avail. I use Jboss 2.4.4.

      Having set up Jboss.jcml and the two required schemas ("jms_messages" and "jms_transactions"), messages DO get stored into the "jms_messages" table. However, upon restarting JBoss, the following was dumped to the console:

      [ERROR,PersistenceManager] Stopped
      org.jboss.mq.SpyJMSException: Could not rebuild the queue from the queue's tranaction log.
      at org.jboss.mq.pm.jdbc.MessageLog.throwJMSException(MessageLog.java:206
      at org.jboss.mq.pm.jdbc.MessageLog.restore(MessageLog.java:96)
      at org.jboss.mq.pm.jdbc.PersistenceManager.restore(PersistenceManager.ja
      at org.jboss.mq.pm.jdbc.PersistenceManager.startService(PersistenceManag
      at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103
      at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces....

      The affected queue becomes UNUSABLE when JBoss did start up. Whenever a new message is published to the queue, JBossMQ would complain of duplicate message key exceptions.

      Please would anyone who might have the slightest idea of how to go round this problem shed some light and put me out of my misery!

      Thanks a great deal in advance.