JDBC driver hangs?

From: Anastasios Kotsikonas <tasos_at_csa.bu.edu>
Date: 22 Jun 1999 17:23:11 GMT
Message-ID: <7kogpv$q7r$1@news1.bu.edu>

Hi all,

we are executing an update on a Linux RedHat 5.2 Oracle 8.0.5 and thed driver (thin) seems to hang:

"Slave Thread 1" (TID:0x412679a8, sys_thread_t:0x445cfe0c, state:CW) prio=6

        java.net.SocketInputStream.read(SocketInputStream.java:84)
        oracle.sqlnet.SQLnetInputStream.readPacket(SQLnetInputStream.java:51)
        oracle.sqlnet.SQLnetInputStream.readDataPacket(SQLnetInputStream.java:95)
        oracle.sqlnet.SQLnetInputStream.read(SQLnetInputStream.java:163)
        oracle.sqlnet.SQLnetBufferedInputStream.fill(SQLnetBufferedInputStream.java:45)
        oracle.sqlnet.SQLnetBufferedInputStream.read(SQLnetBufferedInputStream.java:81)
        oracle.sqlnet.SQLnetBufferedInputStream.read(SQLnetBufferedInputStream.java:66)
        oracle.sqlnet.SQLnetBufferedInputStream.read(SQLnetBufferedInputStream.java:57)
        oracle.jdbc.ttc7.TTCInBuffer.getByte(TTCInBuffer.java:86)
        oracle.jdbc.ttc7.TTIMsg.unmarshalSB1(TTIMsg.java:1085)
        oracle.jdbc.ttc7.Oall7.receive(Oall7.java:465)
        oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1221)
        oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:657)
        oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:770)
        oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:812)
        oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1154)
        oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1187)
        oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1203)
        lwdb.LWTxn.ExecuteUpdate(LWTxn.java:140)
        lwdb.LWList.DBUpdate(LWList.java:5395)

The UPDATE statement is 1795 chars long. Could this be the problem? Any other pointers? BTW, the same statement executes fine via PL/SQL.

thanks

tasos Received on Tue Jun 22 1999 - 12:23:11 CDT