DatabaseLink`
DatabaseLink`
SQLConnectionPool
is an object that represents a connection pool to a data source.
Details and Options
- To use SQLConnectionPool, you first need to load DatabaseLink using Needs["DatabaseLink`"].
- SQLConnectionPools returns an SQLConnectionPool object.
- The following options can be modified in an SQLConnectionPool object:
-
"Catalog" Automatic location of the database catalog "ReadOnly" Automatic set the connection to be read only "TransactionIsolationLevel" Automatic set transaction isolation for the connection "MaximumActiveConnections" Automatic maximum number of connections to keep in the pool "MaximumIdleConnections" Automatic maximum number of idle connections to keep in the pool "MinimumIdleConnections" Automatic minimum number of idle connections to keep in the pool
Examples
Basic Examples (1)
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the "DatabaseLink`DatabaseExamples`" package, as described in Using the Example Databases.
The connection pool used to connect to the data source: