0 Replies Latest reply on Feb 10, 2004 7:37 AM by George Sun

    jboss 3.2.1 with mysql 4.1 problem

    George Sun Newbie

      Hi all:

      previously I am using jboss 3.2.1 and mysql 3.23, it works fine.

      When I upgraded mysql from 3.23 to mysql 4.1, I got the following error:

      ** 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)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:147)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnection(InternalManagedConnectionPool.java:352)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:151)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.getConnection(JBossManagedConnectionPool.java:643)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:413)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:331)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:488)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:798)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)

      ...

      This error prevents my EJB from deployed correctly.

      My database already started properly, I can access it from console.
      I am using mysql-connector-java-3.0.10-stable-bin.jar and put is under C:\jboss-3.2.1\server\default\lib.

      My C:\jboss-3.2.1\server\default\deploy\mysql-ds.xml look like:



      <local-tx-datasource>
      <jndi-name>lmsDS</jndi-name>
      <connection-url>jdbc:mysql://localhost/LMS</connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>admin</user-name>
      < password>admin< /password>
      </local-tx-datasource>



      Any help is highly appreciated! Thx!
      guoqiao