Error validating database 121 sql error opening connection
This section describes the following concepts: Note: The instructions in this section use a pool-enabled data source to implicitly create and start a connection pool.
The connection factory is typically provided as part of a JDBC driver and can be a data source itself.UCP JDBC connection pools maintain both available connections and borrowed connections.A connection is reused from the pool if an application requests to borrow a connection that matches an available connection.A new connection is created if no available connection in the pool match the requested connection.The number of available connections and borrowed connections are subjected to pool properties such as pool size, timeout intervals, and validation rules.A UCP JDBC connection pool can use any JDBC driver to create physical connections that are then maintained by the pool.
The In addition to the connection factory class, a pool-enabled data source requires the URL, user name, and password that is used to connect to a database.
A pool-enabled data source instance includes methods to set each of these properties.
An application borrows connections using a pool-enabled data source.
The UCP for JDBC API provides two pool-enabled data sources; one for borrowing regular connections; and one for borrowing XA connections.
These data sources provide access to UCP JDBC connection pool functionality and include a set of methods that are used to borrow connections.
The same pool features are included in both XA and non-XA UCP JDBC connection pools.