Why are my queries getting stuck?

Using 8.05 under Linux thru Java... a simple update:

delete from lw_digests where listname='test2' and id=1

(and of course others) never return and a timeout exception is thrown:

java.sql.SQLException: ORA-01013: user requested cancel of current operation

        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:181)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:631)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1221)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:657)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:770)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleStatement.java:812)
        at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1154)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1177)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1203)
        at lwdb.LWTxn.ExecuteUpdate(LWTxn.java:166)
        at lwdb.LWTxn.ExecuteUpdate(LWTxn.java:147)
        at lwdb.LWDigest.DBUpdate(LWDigest.java:1131)
        at lwdb.LWDigest.DeleteById(LWDigest.java:967)
        at lwd.cos.email.listDigest.send(listDigest.java:217)
        at lwd.listDigester.Begin(listDigester.java:198)
        at lwd.dispatch.WorkerThread.run(WorkerThread.java:246)

I specify the timeout:

      stmt.setQueryTimeout(60*1000);	// 60 seconds
      int res = stmt.executeUpdate (sql);

but do I time out?

thanks

tasos Received on Thu Jul 29 1999 - 13:28:26 CDT