My Oracle Support Banner

What Happens to the Active Oracle Database Session in the Event of Read Timeout Breached on WebLogic Datasource (Doc ID 2717104.1)

Last updated on OCTOBER 23, 2023

Applies to:

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

Goal

What happens to the active Oracle Database Session initiated from WebLogic Data Source in the event of configured Read timeout is breached on the WebLogic Data Source.

Scenario:
1. WebLogic Data Source configured with Read Timeout of 10secs (oracle.jdbc.ReadTimeout)
2. Oracle Database takes longer than 10secs to execute the SQL Procedure invoked by the WebLogic Data Source.
3. On the 11th second, after waiting 10secs for response from the Database, the WebLogic Data Source sends a Read Timed out message to the client.

When this happens, what happens to the Active Database Session which was executing the call?

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


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