-
1. Re: Oracle JDBC query hangs for 60 seconds
lordlust Nov 25, 2002 4:52 AM (in response to lordlust)By the way, here's the thread dump:
"Signal Dispatcher" daemon prio=10 tid=0x009E8118 nid=0xdc4 waiting on condition
[0..0]
"Finalizer" daemon prio=9 tid=0x0003E6F0 nid=0xdd4 in Object.wait() [ab1f000..ab
1fd88]
at java.lang.Object.wait(Native Method)
- waiting on <02F81698> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:111)
- locked <02F81698> (a java.lang.ref.ReferenceQueue$Lock)
at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:127)
at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)
"Reference Handler" daemon prio=10 tid=0x0003D2C0 nid=0xdd8 in Object.wait() [aa
df000..aadfd88]
at java.lang.Object.wait(Native Method)
- waiting on <02F81700> (a java.lang.ref.Reference$Lock)
at java.lang.Object.wait(Object.java:426)
at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:113)
- locked <02F81700> (a java.lang.ref.Reference$Lock)
"main" prio=5 tid=0x00034AB8 nid=0xdc8 runnable [7f000..7fc3c]
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.Oopen.receive(Oopen.java:105)
at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586)
- locked <02FCA940> (a oracle.jdbc.ttc7.TTC7Protocol)
at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:385)
at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConn
ection.java:772)
at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.
java:712)
- locked <02FCA890> (a oracle.jdbc.driver.OracleConnection)
at JdbcTest.main(JdbcTest.java:11)
"VM Thread" prio=5 tid=0x009E5030 nid=0xde0 runnable
"VM Periodic Task Thread" prio=10 tid=0x009E6E00 nid=0xdd0 waiting on condition
"Suspend Checker Thread" prio=10 tid=0x009E7750 nid=0xdcc runnable