Setquerytimeout() Has No Effect When Executing a Batch - ORA-01013 Exception Not Returned
(Doc ID 466664.1)
Last updated on FEBRUARY 03, 2019
Applies to:JDBC - Version: 22.214.171.124 to 10.2.0.3
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 :
PreparedStatement ps = conn.prepareStatement ("update ...")
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 received 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