Connection Manager

The Connection Manager coordinates & manages the connections to the underlying database or databases. This includes handling the definitions of the connections, setting the behaviour of the connection pool and creating & releasing the actual connections.

Typically a single, global, Connection Manager exists which is then used application wide.

The Data Service acquires a connection from the Connection Manager's connection pool and then when communications are finished, the Data Service then releases that connection back to the global pool.

With the .NET version of Data Abstract, when the PoolingEnabled property is set to True, connections are served from Data Abstract's own connection pool; when it is set to False, a new connection is created for each request. ADO.NET's own connection pooling is controlled independently by the separate EnableAdoConnectionPooling property.

There are a number of configuration options available for the data pool using the properties PoolingBehavior, PoolTimeoutSeconds, WaitIntervalSeconds and MaxPoolSize. Those are available on both .NET and Delphi versions.

See Also