Setquerytimeout() Has No Effect When Executing a Batch - ORA-01013 Exception Not Returned
(Doc ID 466664.1)
Last updated on FEBRUARY 19, 2019
Applies to:JDBC - Version 18.104.22.168 to 10.2.0.3 [Release 9.2 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.
Using the 10.2.0.3 Thin JDBC driver, the setQueryTimeout() method has no effect when executing a batch consisting of update statements.
The sequence of code is the following :
If locking some rows that are updated by the batch, the JDBC application is hanging on the following call :
The expected behavior is that the JDBC application receives the following exception :
java.sql.SQLException: ORA-01013: user requested cancel of current operation
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document