public class AS400JDBCConnectionPool extends ConnectionPool implements java.io.Serializable
Note: AS400JDBCConnectionPool objects are threadsafe.
The following example creates a connection pool with 10 connections.
// Obtain an AS400JDBCConnectionPoolDataSource object from JNDI.
Context context = new InitialContext(environment);
AS400JDBCConnectionPoolDataSource datasource = (AS400JDBCConnectionPoolDataSource)context.lookup("jdbc/myDatabase");
// Create an AS400JDBCConnectionPool object.
AS400JDBCConnectionPool pool = new AS400JDBCConnectionPool(datasource);
// Adds 10 connections to the pool that can be used by the application (creates the physical database connections based on the data source).
pool.fill(10);
// Get a handle to a database connection from the pool.
Connection connection = pool.getConnection();
... Perform miscellenous queries/updates on the database.
// Close the connection handle to return it to the pool.
connection.close();
... Application works with some more connections from the pool.
// Close the pool to release all resources.
pool.close();
| Constructor and Description |
|---|
AS400JDBCConnectionPool()
Constructs a default AS400JDBCConnectionPool object.
|
AS400JDBCConnectionPool(AS400JDBCConnectionPoolDataSource dataSource)
Constructs an AS400JDBCConnectionPool object with the specified dataSource.
|
| Modifier and Type | Method and Description |
|---|---|
void |
close()
Closes all the database connections in the pool.
|
void |
fill(int numberOfConnections)
Fills the connection pool with the specified number of database connections.
|
protected void |
finalize()
Closes the connection pool if not explicitly closed by the caller.
|
int |
getActiveConnectionCount()
Returns the number of active connections the pool has created.
|
int |
getAvailableConnectionCount()
Returns the number of available PooledConnections in the pool.
|
java.sql.Connection |
getConnection()
Returns a connection from the pool.
|
AS400JDBCConnectionPoolDataSource |
getDataSource()
Returns the data source used to make connections.
|
boolean |
isClosed()
Indicates whether the connection pool is closed.
|
void |
setDataSource(AS400JDBCConnectionPoolDataSource dataSource)
Sets the data source used to make connections.
|
addConnectionPoolListener, addPropertyChangeListener, getCleanupInterval, getMaxConnections, getMaxInactivity, getMaxLifetime, getMaxUseCount, getMaxUseTime, isPretestConnections, isRunMaintenance, isThreadUsed, removeConnectionPoolListener, removePropertyChangeListener, setCleanupInterval, setMaxConnections, setMaxInactivity, setMaxLifetime, setMaxUseCount, setMaxUseTime, setPretestConnections, setRunMaintenance, setThreadUsedpublic AS400JDBCConnectionPool()
public AS400JDBCConnectionPool(AS400JDBCConnectionPoolDataSource dataSource)
dataSource - The AS400JDBCConnectionPoolDataSource object.public void close()
close in class ConnectionPoolpublic void fill(int numberOfConnections)
throws ConnectionPoolException
numberOfConnections - The number of connections to add to the pool.ConnectionPoolException - If a database error occurs creating a connection for the pool, or the maximum number of connections has been reached for the pool.ExtendedIllegalArgumentException - if the number of connections to fill the pool with is less than one.protected void finalize()
throws java.lang.Throwable
finalize in class ConnectionPooljava.lang.Throwable - If an error occurs.public int getActiveConnectionCount()
public int getAvailableConnectionCount()
public java.sql.Connection getConnection()
throws ConnectionPoolException
ConnectionPoolException - If a database error occurs getting the connection.public AS400JDBCConnectionPoolDataSource getDataSource()
public boolean isClosed()
public void setDataSource(AS400JDBCConnectionPoolDataSource dataSource) throws java.beans.PropertyVetoException
dataSource - The AS400JDBCConnectionPoolDataSource object.java.beans.PropertyVetoException - If a change is vetoed.