JDBC Connection Hang
(Doc ID 1140473.1)
Last updated on JANUARY 04, 2023
Applies to:
JDBC - Version 11.1.0.6 and laterOracle WebLogic Server - Version 10.3 and later
Oracle Net Services - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
Goal
You see JDBC client is waiting for Database return result, but you can't see any session from Database in the V$Session view.
Thread-43 "[STUCK] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'" <alive, in native, suspended, priority=1, DAEMON> {
jrockit.net.SocketNativeIO.readBytesPinned(SocketNativeIO.java:???)
jrockit.net.SocketNativeIO.socketRead(SocketNativeIO.java:31)
java.net.SocketInputStream.socketRead0(SocketInputStream.java:???)
java.net.SocketInputStream.read(SocketInputStream.java:107)
oracle.net.ns.Packet.receive(Packet.java:220)
oracle.net.ns.DataPacket.receive(DataPacket.java:92)
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:164)
oracle.net.ns.NetInputStream.read(NetInputStream.java:109)
oracle.net.ns.NetInputStream.read(NetInputStream.java:92)
oracle.net.ns.NetInputStream.read(NetInputStream.java:77)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1017)
oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:999)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:555)
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:56)
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:932)
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:815)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1147)
How to avoid that thread wait forever?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |