Hi,

I have a requirement of fetching the Table names from Oracle. Hence executing the below query via JDBC. My client application continues this operation for ever and the fetching is not terminated. There is no Exception thrown.


sqlStr = "SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_TYPE ='TABLE' AND OBJECT_NAME NOT IN (SELECT TABLE_NAME FROM USER_NESTED_TABLES) ORDER BY OBJECT_ID;"

ResultSet rs = statement.executeQuery(sqlStr)

My oracle version is 9.2.
Driver: oracle.jdbc.driver.OracleDriver and classes12.zip present in Oracle Home/jdbc/lib/

Please guide me on this issue.

Please note that the above case works well for all other Oracle Databases. During fetching I had taken the thread dump.

"Thread-4" prio=7 tid=0x0B94E568 nid=0x240 runnable [bf9f000..bf9fd84]
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.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.ttc7.MAREngine.unmarshalUB1(MAREngine. java:931)
at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine. java:893)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:369)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.j ava:1198)
- locked <05D40AB8> (a oracle.jdbc.ttc7.TTC7Protocol)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery( OracleStatement.jav
a:2400)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStateme
nt.java:2672)
at oracle.jdbc.driver.OracleStatement.executeQuery(Or acleStatement.java:
572)
- locked <05D40C10> (a oracle.jdbc.driver.OracleStatement)
- locked <05D40CE0> (a oracle.jdbc.driver.OracleConnection)