Weblogic Data Source Statement Timeout Not Working

(Doc ID 1606541.1)

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