JDBC Driver for SQL/MP 3.0

the proper
PooledConnection
object. The lookup criteria and other methods are specific to the application
server.
The application server implements the ConnectionEventListener interface and registers the listener object with
the PooledConnection object. The JDBC/MP driver notifies the listener object with a connectionClosed event
when the application is finished using the PooledConnection object. Then, the application server can reuse this
PooledConnection object for future requests.
With the JDBC/MP driver, a pooled connection cannot fail to be initialized; therefore, the
connectionErrorOccurred event cannot occur.
The application server manages the connection pool by using the SQLMPConnectionPoolDataSource, which
implements the ConnectionPoolDataSource interface. Use the getter and setter methods, provided by
JDBC/MP, to set the connection-pool configuration properties listed in the table of Standard
ConnectionPoolDataSource Object Properties.
In an environment that uses an application server, deployment of an SQLMPConnectionPoolDataSource object
requires that both an application-visible DataSource object and the underlying
SQLMPConnectionPoolDataSource object be registered with a JNDI-based naming service. For more
information, see Registering the SQLMPConnectionPoolDataSource and DataSource Objects with a JNDI-Based
Naming Service.
Standard ConnectionPoolDataSource Object Properties
Property Name Type
Default
Value*
Description
maxStatements int 0
The maximum number of PreparedStatement objects that
the pool should cache. A value of 0 (zero) disables
statement pooling.
minPoolSize int 0
The number of physical connections the pool should keep
available at all times.
maxPoolSize int 0
The maximum number of physical connections that the
pool should contain. A value of 0 (zero) indicates no
maximum size.
initialPoolSize int 0
The number of physical connections the pool should keep
workable at all times. A value of 0 (zero) indicates that
connections should be created as needed.
maxIdleTime int 0
The number of seconds that a physical connection should
remain unused in the pool before the connection is closed.
propertyCycle int 0
The interval, in seconds, that the pool should wait before
enforcing the current policy defined by the values of the
previous connection-pool properties.
* Note: The application server defines the semantics of how these properties are used.
Registering the ConnectionPoolDataSource and DataSource Objects with
a JNDI-Based Naming Service