SQLConnectionPools
DatabaseLink`
DatabaseLink`
SQLConnectionPools
returns a list of the open connection pools.
SQLConnectionPools[conn]
returns the connection pool used for a connection.
更多信息和选项
- To use SQLConnectionPools, you first need to load DatabaseLink using Needs["DatabaseLink`"].
范例
基本范例 (1)
Needs["DatabaseLink`"]Open connections from two pools to two data sources:
conn1 = OpenSQLConnection["publisher", "UseConnectionPool" -> True]conn2 = OpenSQLConnection["demo", "UseConnectionPool" -> True]SQLConnectionPools[]The connection pool used to connect to the publisher data source:
pool1 = SQLConnectionPools[conn1]The connection pool used to connect to the demo data source:
pool2 = SQLConnectionPools[conn2]Close connection pools and associated connections:
SQLConnectionPoolClose /@ {pool1, pool2};