File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SocketnputStream hangs the running thread" Watch "SocketnputStream hangs the running thread" New topic
Author

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SocketnputStream hangs the running thread