Weblogic Data Source Statement Timeout Not Working
Last updated on JANUARY 03, 2014
Applies to:Oracle WebLogic Server - Version 10.3 and later
Information in this document applies to any platform.
We have an OLTP application running on WebLogic Server. We have set up various timeouts to prevent long-running transactions from hogging resources. Most work fine, but setting the "Statement Timeout" in WebLogic Console (under "Services" -> "JDBC Data Sources" -> "Connection Pool" -> "Advanced") does not appear to kill the running SQL, even though the front-end transaction appears to be killed.
Is there any functionality to achieve what we want (i.e. terminate and rollback a DB query which exceeds a certain timeout)?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms