SQLConnectionPools

returns a list of the open connection pools.

returns the connection pool used for a connection.

Details and Options

To use SQLConnectionPools, you first need to load DatabaseLink using Needs["DatabaseLink`"].

Wolfram Language code: Needs["DatabaseLink`"]

Open connections from two pools to two data sources:

Wolfram Language code: conn1 = OpenSQLConnection["publisher", "UseConnectionPool" -> True]

Wolfram Language code: conn2 = OpenSQLConnection["demo", "UseConnectionPool" -> True]

All connection pools:

Wolfram Language code: SQLConnectionPools[]

The connection pool used to connect to the publisher data source:

Wolfram Language code: pool1 = SQLConnectionPools[conn1]

The connection pool used to connect to the demo data source:

Wolfram Language code: pool2 = SQLConnectionPools[conn2]

Close connection pools and associated connections:

Wolfram Language code: SQLConnectionPoolClose /@ {pool1, pool2};

Top