DB Connections from EBC do not timeout or disconnect - Use Database Connection Pooling for EBCs

(Doc ID 523952.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 7.5.2 [16008] to 8.1 [21039] [Release V7 to V8]
Siebel Tools - Version 7.5.2 [16008] and later
IBM AIX on POWER Systems (64-bit)
Database: IBM DB2 8.2
Application Server OS: IBM AIX 5L 5.2
Database Server OS: IBM AIX 5L 5.2

This document was previously published as Siebel SR 38-3073557691.

Checked for relevance on 19th July 2010. The CR still applies.

Checked for relevance on 4th Sep 2013.

Checked for Relevance on 03-Nov-2015

Symptoms

We have an External Business Component to an external DB2 Database. This works fine, i.e. we can display the data in the Siebel UI. However, we are finding that once a connection is made to the external database, it persists until the user logs off. This is causing us a problem in the external database, as we have over 250 idle connections.

Is there any way to ensure that after each request through the EBC, that the connection is disconnected? Is there any way to timeout the connection?

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