jQuery in Action, 2nd edition*
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

Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
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
Consider Paul's rocket mass heater.
subject: SocketnputStream hangs the running thread