Disable Connection Pooling when connecting to Oracle database

Document ID : KB000090078
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Disable Connection Pooling when connecting to Oracle database
Resolution:
Detailed Description and Symptoms

How to force UC4 Database Agent to use a connection to a remote database only once 

Investigation

The configuration of the connection pool in SQL Agents can be done with the retention_time parameter in the INI file. 

Solution

In V9 the connection pool can be turned off with the parameter retention_time=0. 

In V8 the value retention_time=0 will reuse a database connection if Jobs are running in the same second against the same database.