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
It is sorta covered in the JavaRanch Style Guide.
subject: SocketnputStream hangs the running thread