wood burning stoves 2.0*
The moose likes JDBC and the fly likes SocketnputStream hangs the running thread Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SocketnputStream hangs the running thread" Watch "SocketnputStream hangs the running thread" New topic

SocketnputStream hangs the running thread

Narendra shah
Ranch Hand

Joined: Feb 28, 2007
Posts: 51
This is very common problem. It occur in random time. It is also occuring with Database and Pure socket connection. Can we handle the situation.
I have attached following thread dump impression. How to avoid it. Please reply as soon as possible if you know anything. Your help is appreciated.

The connection is made between mysql and java. and Connection Pooling concept is used. select query is fired with following dump.

"Thread-6" (TID:0xb4973f58, sys_thread_t:0x8bab7f8, state:CW) prio=5
at java.net.SocketInputStream.socketRead(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:86)
at java.net.SocketInputStream.read(SocketInputStream.java:102)
at org.gjt.mm.mysql.MysqlIO.readPacket(MysqlIO.java:881)
at org.gjt.mm.mysql.MysqlIO.clearAllReceive(MysqlIO.java:998)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:549)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:636)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:924)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:857)
at org.gjt.mm.mysql.Connection.setAutoCommit(Connection.java:474)

Narendra Shah -- SCJP 5
Don't get me started about those stupid light bulbs.
subject: SocketnputStream hangs the running thread
Similar Threads
SocketnputStream hangs the running thread
APPARENT DEADLOCK Hibernate and c3p0 error site goes down please help
APPARENT DEADLOCK site goes down please help
Hibernate/MySQL Timeout Issue
Communications link failure in JBOSS