My Oracle Support Banner

WebLogic Data Source Statement Timeout Not Working (Doc ID 1606541.1)

Last updated on JANUARY 06, 2023

Applies to:

Oracle WebLogic Server - Version 10.3 and later
Information in this document applies to any platform.

Goal

An OLTP application is running on WebLogic Server. Various timeouts were set up 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)?

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.