6 Replies Latest reply on Nov 6, 2003 7:28 AM by Stephane Nicoll

    mysql 3.23.52 and mysql-jdbc2-service.xml

    patrick Novice

      Hi all,

      I'm using jboss3.2.2 and i'm trying to configure the mq with the file mysql-jdbc2-service.xml which is in
      the distribution.

      It's not going well.
      Has anyone configured this jboss distribution with mysql 3.

      The exception i get after changing the following line

      DELETE_MARKED_MESSAGES_WITH_TX = DELETE JMS_MESSAGES FROM JMS_MESSAGES, JMS_TRANSACTIONS WHERE JMS_MESSAGES.TXID = JMS_TRANSACTIONS.TXID AND JMS_MESSAGES.TXOP='?'

      Not the ' around the question mark. Otherwise i get an SQL exception.

      After changing that line i get :

      10:50:39,046 ERROR [PersistenceManager] Starting failed
      java.lang.ArrayIndexOutOfBoundsException: 0
      at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:1
      955)
      at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:112
      0)

      Help!!