JDBC.STATEMENTTIMEOUT Doesn't Work During Running Sleep Procudure in ORDS
(Doc ID 2691438.1)
Last updated on NOVEMBER 11, 2022
Applies to:
Oracle REST Data Services - Version 19.2 and laterInformation in this document applies to any platform.
Symptoms
Jdbc.statementTimeout specifies the time limit in seconds within SQL execution time, but it does not work when running a sleep procedure.
Steps to reproduce:
1. Create the following procedure:
4. Test the procedure:
http://localhost:<PORT>/ords/testsleep2
Result:
After 1200 sec, the "Sleep 1200sec" message shown, indicating the timeout did not occur.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |