Select Statement Hangs From Java Program on Solaris
(Doc ID 412351.1)
Last updated on AUGUST 30, 2023
Applies to:
JDBC - Version 10.2.0 and laterOracle Solaris on SPARC (64-bit)
Symptoms
A JDBC thin or JDBC OCI program hangs on selects when connecting to a 10.2.0.2 Server running on the Solaris 64-bit operating system. Thread dumps similar to the below are seen from the JDBC process:
Thin Driver
----------
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at oracle.net.ns.Packet.receive(Unknown Source)
at oracle.net.ns.DataPacket.receive(Unknown Source)
at oracle.net.ns.NetInputStream.getNextPacket(Unknown Source)
at oracle.net.ns.NetInputStream.read(Unknown Source)
at oracle.net.ns.NetInputStream.read(Unknown Source)
at oracle.net.ns.NetInputStream.read(Unknown Source)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1099)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1070)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:478)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1027)
at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:291)
- locked <0xf1f26a20> (a oracle.jdbc.driver.T4CConnection)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:213)
- locked <0xf181b258> (a oracle.jdbc.driver.OracleResultSetImpl)
OCI Driver
--------
oracle.jdbc.driver.T2CStatement.t2cDefineFetch(Native Method)
at oracle.jdbc.driver.T2CStatement.doDefineFetch(T2CStatement.java:1045)
at oracle.jdbc.driver.T2CStatement.executeForRows(T2CStatement.java:975)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1060)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
at oracle.jdbc.driver.T2CStatement.t2cFetch(Native Method)
at oracle.jdbc.driver.T2CPreparedStatement.fetch(T2CPreparedStatement.java:977)
at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:291)
- locked <0xf1f23100> (a oracle.jdbc.driver.T2CConnection)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:213)
- locked <0xf1868a30> (a oracle.jdbc.driver.OracleResultSetImpl)
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |