Database Adapter does not time out after setting the 'QueryTimeout' at the Adapter level or the 'Statement Timeout' at the Data Source level (Doc ID 2000188.1)

Last updated on APRIL 17, 2015

Applies to:

Oracle SOA Suite - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

A Database Adapter is not timing out when a transaction takes longer than expected, even after a timeout at both the Adapter and datasource level have been configured.  At the Adapter level, the 'QueryTimeout' parameter has been set.  At the Data Source level, the 'Statement Timeout' parameter has been set.

Cause

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