1 Reply Latest reply on Jun 9, 2003 5:11 PM by Bill F.Gong

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

    Bill F.Gong Newbie

      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

        • 1. Re: PersistenceManager Error with MySql4.1.0+JBoss3.2.1 on R
          Bill F.Gong Newbie

          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