Package org.apache.commons.dbcp
Class PoolableConnectionFactory
java.lang.Object
org.apache.commons.dbcp.PoolableConnectionFactory
- All Implemented Interfaces:
org.apache.commons.pool.PoolableObjectFactory
- Direct Known Subclasses:
PoolableManagedConnectionFactory
public class PoolableConnectionFactory
extends Object
implements org.apache.commons.pool.PoolableObjectFactory
A
PoolableObjectFactory
that creates
PoolableConnection
s.- Version:
- $Revision: 883393 $ $Date: 2009-11-23 11:18:35 -0500 (Mon, 23 Nov 2009) $
- Author:
- Rodney Waldhoff, Glenn L. Nielsen, James House, Dirk Verbeeck
-
Constructor Summary
ConstructorsConstructorDescriptionPoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, boolean defaultReadOnly, boolean defaultAutoCommit) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, AbandonedConfig config) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, boolean defaultReadOnly, boolean defaultAutoCommit, AbandonedConfig config) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, boolean defaultReadOnly, boolean defaultAutoCommit) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, Boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, Collection connectionInitSqls, boolean defaultReadOnly, boolean defaultAutoCommit) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, Collection connectionInitSqls, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, Collection connectionInitSqls, Boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, Boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, Collection connectionInitSqls, boolean defaultReadOnly, boolean defaultAutoCommit) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, Collection connectionInitSqls, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation) Create a new PoolableConnectionFactory.PoolableConnectionFactory
(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, Collection connectionInitSqls, Boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) Create a new PoolableConnectionFactory. -
Method Summary
Modifier and TypeMethodDescriptionvoid
activateObject
(Object obj) void
destroyObject
(Object obj) org.apache.commons.pool.ObjectPool
getPool()
Returns theObjectPool
in whichConnection
s are pooled.void
passivateObject
(Object obj) void
setConnectionFactory
(ConnectionFactory connFactory) Sets theConnectionFactory
from which to obtain baseConnection
s.void
setConnectionInitSql
(Collection connectionInitSqls) Sets the SQL statements I use to initialize newly createdConnection
s.void
setDefaultAutoCommit
(boolean defaultAutoCommit) Sets the default "auto commit" setting for borrowedConnection
svoid
setDefaultCatalog
(String defaultCatalog) Sets the default "catalog" setting for borrowedConnection
svoid
setDefaultReadOnly
(boolean defaultReadOnly) Sets the default "read only" setting for borrowedConnection
svoid
setDefaultTransactionIsolation
(int defaultTransactionIsolation) Sets the default "Transaction Isolation" setting for borrowedConnection
svoid
setPool
(org.apache.commons.pool.ObjectPool pool) Sets theObjectPool
in which to poolConnection
s.void
setStatementPoolFactory
(org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory) void
setValidationQuery
(String validationQuery) Sets the query I use tovalidate
Connection
s.void
setValidationQueryTimeout
(int timeout) Sets the validation query timeout, the amount of time, in seconds, that connection validation will wait for a response from the database when executing a validation query.void
validateConnection
(Connection conn) boolean
validateObject
(Object obj)
-
Constructor Details
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, boolean defaultReadOnly, boolean defaultAutoCommit) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
s
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, Collection connectionInitSqls, boolean defaultReadOnly, boolean defaultAutoCommit) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.connectionInitSqls
- a Collection of SQL statements to initializeConnection
s. Using null turns off initialization.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
s- Since:
- 1.3
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, boolean defaultReadOnly, boolean defaultAutoCommit) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.validationQueryTimeout
- the number of seconds that validation queries will wait for database response before failing. Use a value less than or equal to 0 for no timeout.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
s- Since:
- 1.3
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, Collection connectionInitSqls, boolean defaultReadOnly, boolean defaultAutoCommit) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.validationQueryTimeout
- the number of seconds that validation queries will wait for database response before failing. Use a value less than or equal to 0 for no timeout.connectionInitSqls
- a Collection of SQL statements to initializeConnection
s. Using null turns off initialization.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
s- Since:
- 1.3
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sdefaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
s
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, Collection connectionInitSqls, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.connectionInitSqls
- a Collection of SQL statement to initializeConnection
s. Using null turns off initialization.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sdefaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
s- Since:
- 1.3
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.validationQueryTimeout
- the number of seconds that validation queries will wait for database response before failing. Use a value less than or equal to 0 for no timeout.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sdefaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
s- Since:
- 1.3
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, Collection connectionInitSqls, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.validationQueryTimeout
- the number of seconds that validation queries will wait for database response before failing. Use a value less than or equal to 0 for no timeout.connectionInitSqls
- a Collection of SQL statement to initializeConnection
s. Using null turns off initialization.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sdefaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
s- Since:
- 1.3
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, boolean defaultReadOnly, boolean defaultAutoCommit, AbandonedConfig config) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sconfig
- the AbandonedConfig if tracing SQL objects
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, AbandonedConfig config) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sdefaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
sconfig
- the AbandonedConfig if tracing SQL objects
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sdefaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
sdefaultCatalog
- the default "catalog" setting for returnedConnection
sconfig
- the AbandonedConfig if tracing SQL objects
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, Boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sdefaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
sdefaultCatalog
- the default "catalog" setting for returnedConnection
sconfig
- the AbandonedConfig if tracing SQL objects
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, Collection connectionInitSqls, Boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.connectionInitSqls
- a Collection of SQL statements to initializeConnection
s. Using null turns off initialization.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sdefaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
sdefaultCatalog
- the default "catalog" setting for returnedConnection
sconfig
- the AbandonedConfig if tracing SQL objects- Since:
- 1.3
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, Boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.validationQueryTimeout
- the number of seconds that validation queries will wait for database response before failing. Use a value less than or equal to 0 for no timeout.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sdefaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
sdefaultCatalog
- the default "catalog" setting for returnedConnection
sconfig
- the AbandonedConfig if tracing SQL objects- Since:
- 1.3
-
PoolableConnectionFactory
public PoolableConnectionFactory(ConnectionFactory connFactory, org.apache.commons.pool.ObjectPool pool, org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout, Collection connectionInitSqls, Boolean defaultReadOnly, boolean defaultAutoCommit, int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) Create a new PoolableConnectionFactory.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
spool
- theObjectPool
in which to pool thoseConnection
sstmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s, or null to disablePreparedStatement
poolingvalidationQuery
- a query to use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.validationQueryTimeout
- the number of seconds that validation queries will wait for database response before failing. Use a value less than or equal to 0 for no timeout.connectionInitSqls
- a Collection of SQL statements to initializeConnection
s. Using null turns off initialization.defaultReadOnly
- the default "read only" setting for borrowedConnection
sdefaultAutoCommit
- the default "auto commit" setting for returnedConnection
sdefaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
sdefaultCatalog
- the default "catalog" setting for returnedConnection
sconfig
- the AbandonedConfig if tracing SQL objects- Since:
- 1.3
-
-
Method Details
-
setConnectionFactory
Sets theConnectionFactory
from which to obtain baseConnection
s.- Parameters:
connFactory
- theConnectionFactory
from which to obtain baseConnection
s
-
setValidationQuery
Sets the query I use tovalidate
Connection
s. Should return at least one row. Using null turns off validation.- Parameters:
validationQuery
- a query to use tovalidate
Connection
s.
-
setValidationQueryTimeout
public void setValidationQueryTimeout(int timeout) Sets the validation query timeout, the amount of time, in seconds, that connection validation will wait for a response from the database when executing a validation query. Use a value less than or equal to 0 for no timeout.- Parameters:
timeout
- new validation query timeout value in seconds- Since:
- 1.3
-
setConnectionInitSql
Sets the SQL statements I use to initialize newly createdConnection
s. Using null turns off connection initialization.- Parameters:
connectionInitSqls
- SQL statement to initializeConnection
s.- Since:
- 1.3
-
setPool
public void setPool(org.apache.commons.pool.ObjectPool pool) Sets theObjectPool
in which to poolConnection
s.- Parameters:
pool
- theObjectPool
in which to pool thoseConnection
s
-
getPool
public org.apache.commons.pool.ObjectPool getPool()Returns theObjectPool
in whichConnection
s are pooled.- Returns:
- the connection pool
-
setStatementPoolFactory
public void setStatementPoolFactory(org.apache.commons.pool.KeyedObjectPoolFactory stmtPoolFactory) Sets theKeyedObjectPoolFactory
I use to createKeyedObjectPool
s for poolingPreparedStatement
s. Set to null to disablePreparedStatement
pooling.- Parameters:
stmtPoolFactory
- theKeyedObjectPoolFactory
to use to createKeyedObjectPool
s for poolingPreparedStatement
s
-
setDefaultReadOnly
public void setDefaultReadOnly(boolean defaultReadOnly) Sets the default "read only" setting for borrowedConnection
s- Parameters:
defaultReadOnly
- the default "read only" setting for borrowedConnection
s
-
setDefaultAutoCommit
public void setDefaultAutoCommit(boolean defaultAutoCommit) Sets the default "auto commit" setting for borrowedConnection
s- Parameters:
defaultAutoCommit
- the default "auto commit" setting for borrowedConnection
s
-
setDefaultTransactionIsolation
public void setDefaultTransactionIsolation(int defaultTransactionIsolation) Sets the default "Transaction Isolation" setting for borrowedConnection
s- Parameters:
defaultTransactionIsolation
- the default "Transaction Isolation" setting for returnedConnection
s
-
setDefaultCatalog
Sets the default "catalog" setting for borrowedConnection
s- Parameters:
defaultCatalog
- the default "catalog" setting for borrowedConnection
s
-
makeObject
- Specified by:
makeObject
in interfaceorg.apache.commons.pool.PoolableObjectFactory
- Throws:
Exception
-
destroyObject
- Specified by:
destroyObject
in interfaceorg.apache.commons.pool.PoolableObjectFactory
- Throws:
Exception
-
validateObject
- Specified by:
validateObject
in interfaceorg.apache.commons.pool.PoolableObjectFactory
-
validateConnection
- Throws:
SQLException
-
passivateObject
- Specified by:
passivateObject
in interfaceorg.apache.commons.pool.PoolableObjectFactory
- Throws:
Exception
-
activateObject
- Specified by:
activateObject
in interfaceorg.apache.commons.pool.PoolableObjectFactory
- Throws:
Exception
-