PersistenceManager Error with MySql4.1.0+JBoss3.2.1 on Redha

[billgong]

Hi there,

I'm trying to combine JBoss3.2.1 with MySql4.1.0alpha. The J/Connector i use is version 3.0.8-stable.

MySql has to be version 4.1.0, cauz previous versions don't support sub-query, while JBoss3.2.1 did make sub-queries.

In my first case, MySql is running on a Redhat9.0 box, and JBoss on a WinXp box. After doing modifications on files: mysql-ds.xml, jbossmq-service.xml, login-config.xml, standardjaws.xml, and standardjbosscmp-jdbc.xml, things run well.

But in the second case, when i tried to move the JBoss to the Linux box. I got the exception like below, and no tables ( should be JMS_MESSAGES, and JMS_TRANSACTIONS) are created. Anyone has such kind of experiences? Thanks.

16:52:40,248 ERROR [PersistenceManager] Starting failed
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (org.jboss.util.NestedSQLException: Could not
create connection; - nested throwable: (java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

** BEGIN NESTED EXCEPTION **

java.io.IOException
MESSAGE: Unexpected end of input stream

STACKTRACE:

java.io.IOException: Unexpected end of input stream
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1096)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:626)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)


regards,
bill

[billgong]

Some new clues about the problem:
In the mysql-ds.xml, i changed the connection-url to "jdbc:mysql://10.10.10.100:3306". Here, 10.10.10.100 is the ip address of the computer that hosts MySql database.
1. If i deploy JBoss on the same linux box as MySql, the exception i posted previously will be thrown. But if i change the connection-url to "jdbc:mysql://localhost:3306", no exception.

2. If i deploy JBoss on another linux box (also Redhat9.0), it succeeds.

Therefore, i guess the problem is related to local VS. remote, instead of Linux VS. WinXP that i said in the first post. I looked into the settings of MySQL, but cannot find any clue where the problem is. Anyone can help?

--bill