mysql 3.23.52 and mysql-jdbc2-service.xml

[pvamstel]

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!!

[stephanenicoll]

This configuration file has to be used with MySQL4

Regards,

Stephane

[pvamstel]

Ok thx,

Should i upgrade or does anyone has a file which works for mysql 3.

(Bit hasetating because my mysql 4 does not handle username password validation very well)

[stephanenicoll]

Check this forum. I saw old posts giving the config for MySQL 3

Regards,

Stephane

[stephanenicoll]

http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=

[pvamstel]

I finally got it

How do i configure mysql 4 with jboss3.2.2

thx for all the help and by the way the
mysql-jdbc2-service.xml works like a charme

grt Patrick

[stephanenicoll]

Great to see this. I am actually the guy that submit this file to the forum :D

Regards,

Stephane