Select Statement Hangs From Java Program on Solaris (Doc ID 412351.1)

Last updated on AUGUST 30, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.