MySql error, MESSAGE: Unexpected end of input stream

[abhijitabhijit]

Hi,

I am using Jboss3.2 with MySql3.23.
While I am trying to connect to database using JSP through EJB I am getting following error.

I am using mysql-connector-java-3.0.9-stable jdbc driver.

Please help me.

Error In JBoss Server log
___________________________

2003-11-25 20:54:38,532 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection:
org.jboss.resource.JBossResourceException: 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:1267)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:510)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1734)
at com.mysql.jdbc.Connection.(Connection.java:562)


In terminal where I have started MySql I get following error:
______________________________________________________________


[root@localhost bin]# /usr/bin/safe_mysqld: line 1: 2292 Segmentation fault nice --5 nohup /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking -u root
/var/log/mysqld.log 2>&1


Number of processes running now: 1
mysqld process hanging, pid 2295 - killed
031125 21:23:41 mysqld restarted

[jonlee]

The problem looks like it is the MySQL side of the connection. You are getting an OS segmentation fault. Most likely this is then causing the the connection to terminate as the MySQL connector/listener dies. This results in the Java side error you see.

Check that MySQL works with the JDBC driver (test that you can connect) and that it executes whatever the SQL was that you were sending to it. Do this from a plain old Java program. However, judging by the exception, it is failing in establishing the connection.