Communications link failure in JBOSS with MYSQL

skumar · August 8th, 2008, 06:32 AM

Hi,

I have a web application running on the JBOSS 4.0 server and Database is MySQL5.0.
We are using MySQL Connection/J as driver template while configuring HIBERNATE3.1

It is running success but we left the application for idle (without doing any operations) it is giving following Exception. Both server and MySQL are running on the same machine.

[org.hibernate.util.JDBCExceptionReporter] could not execute query

com.mysql.jdbc.Communication****ception: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(SocketInputStream. java:129)
    at com.mysql.jdbc.util.ReadAheadInputStream.fill(Read AheadInputStream.java:113)
    at com.mysql.jdbc.util.ReadAheadInputStream.readFromU nderlyingStreamIfNecessary(ReadAheadInputStream.ja va:160)

** END NESTED EXCEPTION **

Last packet sent to the server was 454 ms ago.
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2586)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2874)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:16 23)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1715)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 3249)
2008-08-08 08:01:07,368 ERROR [org.hibernate.util.JDBCExceptionReporter] Communications link failure due to underlying exception:

Also I modified

Please help to advise what's wrong.

skumar

iamrakesh22 · August 13th, 2008, 03:54 AM

As per the trace, you'll get this kind of exception when the connection you are holding is timed out and released, but you try to use the same reference OR when your request for a connection to the database fails [Unable to connect to db].

But as you said you get this exception when the application is idle for some time; its probable will be the first case. Check by modifying the connection timeout value to narrow your case, and find our root cause.
Mostly it'll be connection time out.

- Rakesh

skumar · August 27th, 2008, 11:36 PM

Quote:

quote:Originally posted by rakesh_mscit
As per the trace, you'll get this kind of exception when the connection you are holding is timed out and released, but you try to use the same reference OR when your request for a connection to the database fails [Unable to connect to db].

But as you said you get this exception when the application is idle for some time; its probable will be the first case. Check by modifying the connection timeout value to narrow your case, and find our root cause.
Mostly it'll be connection time out.

- Rakesh

skumar

skumar · August 27th, 2008, 11:43 PM

Quote:

quote:Originally posted by skumar

Quote:

quote:Originally posted by rakesh_mscit

Quote:

As per the trace, you'll get this kind of exception when the connection you are holding is timed out and released, but you try to use the same reference OR when your request for a connection to the database fails [Unable to connect to db].

But as you said you get this exception when the application is idle for some time; its probable will be the first case. Check by modifying the connection timeout value to narrow your case, and find our root cause.
Mostly it'll be connection time out.

- Rakesh

Thanks for u u solution i did the same still am facing same.But i resolved it.
we implemetned the scheduler class to resolvue this issue.
Schedular class will execute the for every specific time period.which cals a class which has a DB interaction.

skumar

skumar