public class PoolingConnectionProvider extends Object implements ConnectionProvider
A ConnectionProvider implementation that creates its own
pool of connections.
This class uses DBCP, an Apache-Jakarta-Commons product.
DBConnectionManager,
ConnectionProvider| Modifier and Type | Field and Description |
|---|---|
static String |
DB_DRIVER
The JDBC database driver.
|
static String |
DB_MAX_CONNECTIONS
The maximum number of database connections to have in the pool.
|
static String |
DB_PASSWORD
The database user password.
|
static String |
DB_URL
The JDBC database URL.
|
static String |
DB_USER
The database user name.
|
static String |
DB_VALIDATION_QUERY
The database sql query to execute everytime a connection is retrieved
from the pool to ensure that it is still valid.
|
static int |
DEFAULT_DB_MAX_CONNECTIONS
Default maximum number of database connections in the pool.
|
| Constructor and Description |
|---|
PoolingConnectionProvider(Properties config)
Create a connection pool using the given properties.
|
PoolingConnectionProvider(String dbDriver,
String dbURL,
String dbUser,
String dbPassword,
int maxConnections,
String dbValidationQuery) |
| Modifier and Type | Method and Description |
|---|---|
Connection |
getConnection() |
protected org.apache.commons.dbcp.BasicDataSource |
getDataSource()
Get the DBCP BasicDataSource created during initialization.
|
void |
shutdown() |
public static final String DB_DRIVER
public static final String DB_URL
public static final String DB_USER
public static final String DB_PASSWORD
public static final String DB_MAX_CONNECTIONS
public static final String DB_VALIDATION_QUERY
public static final int DEFAULT_DB_MAX_CONNECTIONS
public PoolingConnectionProvider(String dbDriver, String dbURL, String dbUser, String dbPassword, int maxConnections, String dbValidationQuery) throws SQLException
SQLExceptionpublic PoolingConnectionProvider(Properties config) throws SQLException
The properties passed should contain:
DB_DRIVER- The database driver class name
DB_URL- The database URL
DB_USER- The database user
DB_PASSWORD- The database password
DB_MAX_CONNECTIONS- The maximum # connections in the pool,
optional
DB_VALIDATION_QUERY- The sql validation query, optional
config - configuration propertiesSQLExceptionprotected org.apache.commons.dbcp.BasicDataSource getDataSource()
This can be used to set additional data source properties in a subclass's constructor.
public Connection getConnection() throws SQLException
getConnection in interface ConnectionProviderSQLExceptionpublic void shutdown()
throws SQLException
shutdown in interface ConnectionProviderSQLExceptionCopyright © 2014. All rights reserved.