PoolableConnectionFactory (Apache Commons DBCP 2.0 API)

java.lang.Object
- org.apache.commons.dbcp2.PoolableConnectionFactory

All Implemented Interfaces:

PooledObjectFactory<PoolableConnection>

Direct Known Subclasses:

PoolableManagedConnectionFactory
```
public class PoolableConnectionFactory
extends Object
implements PooledObjectFactory<PoolableConnection>
```
A PooledObjectFactory that creates PoolableConnections.

Since:

2.0

Version:

$Revision: 1572242 $ $Date: 2014-02-26 20:34:39 +0000 (Wed, 26 Feb 2014) $

Author:

Rodney Waldhoff, Glenn L. Nielsen, James House, Dirk Verbeeck

Constructor Summary

Constructors
Constructor and Description
`PoolableConnectionFactory(ConnectionFactory connFactory, ObjectName dataSourceJmxName)` Create a new `PoolableConnectionFactory`.

Method Summary

Methods
Modifier and Type	Method and Description
`void`	`activateObject(PooledObject<PoolableConnection> p)`
`void`	`destroyObject(PooledObject<PoolableConnection> p)`
`protected boolean`	`getCacheState()`
`protected ConnectionFactory`	`getConnectionFactory()`
`Integer`	`getDefaultQueryTimeout()`
`protected int`	`getMaxOpenPreparedStatements()`
`ObjectPool<PoolableConnection>`	`getPool()` Returns the `ObjectPool` in which `Connection`s are pooled.
`protected boolean`	`getPoolStatements()`
`protected void`	`initializeConnection(Connection conn)`
`boolean`	`isEnableAutoCommitOnReturn()`
`boolean`	`isRollbackOnReturn()`
`PooledObject<PoolableConnection>`	`makeObject()`
`void`	`passivateObject(PooledObject<PoolableConnection> p)`
`void`	`setCacheState(boolean cacheState)`
`void`	`setConnectionInitSql(Collection<String> connectionInitSqls)` Sets the SQL statements I use to initialize newly created `Connection`s.
`void`	`setDefaultAutoCommit(Boolean defaultAutoCommit)` Sets the default "auto commit" setting for borrowed `Connection`s
`void`	`setDefaultCatalog(String defaultCatalog)` Sets the default "catalog" setting for borrowed `Connection`s
`void`	`setDefaultQueryTimeout(Integer defaultQueryTimeout)`
`void`	`setDefaultReadOnly(Boolean defaultReadOnly)` Sets the default "read only" setting for borrowed `Connection`s
`void`	`setDefaultTransactionIsolation(int defaultTransactionIsolation)` Sets the default "Transaction Isolation" setting for borrowed `Connection`s
`void`	`setEnableAutoCommitOnReturn(boolean enableAutoCommitOnReturn)`
`void`	`setMaxConnLifetimeMillis(long maxConnLifetimeMillis)` Sets the maximum lifetime in milliseconds of a connection after which the connection will always fail activation, passivation and validation.
`void`	`setMaxOpenPrepatedStatements(int maxOpenPreparedStatements)`
`void`	`setPool(ObjectPool<PoolableConnection> pool)` Sets the `ObjectPool` in which to pool `Connection`s.
`void`	`setPoolStatements(boolean poolStatements)`
`void`	`setRollbackOnReturn(boolean rollbackOnReturn)`
`void`	`setValidationQuery(String validationQuery)` Sets the query I use to `validate` `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(PoolableConnection conn)`
`boolean`	`validateObject(PooledObject<PoolableConnection> p)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - PoolableConnectionFactory
```
public PoolableConnectionFactory(ConnectionFactory connFactory,
                         ObjectName dataSourceJmxName)
```
    Create a new PoolableConnectionFactory.
    
    Parameters:
    connFactory - the ConnectionFactory from which to obtain base Connections
- Method Detail
  - setValidationQuery
```
public void setValidationQuery(String validationQuery)
```
    Sets the query I use to validate Connections. Should return at least one row. If not specified, Connection.isValid(int) will be used to validate connections.
    
    Parameters:
    validationQuery - a query to use to validate Connections.
  - 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
  - setConnectionInitSql
```
public void setConnectionInitSql(Collection<String> connectionInitSqls)
```
    Sets the SQL statements I use to initialize newly created Connections. Using null turns off connection initialization.
    
    Parameters:
    connectionInitSqls - SQL statement to initialize Connections.
  - setPool
```
public void setPool(ObjectPool<PoolableConnection> pool)
```
    Sets the ObjectPool in which to pool Connections.
    
    Parameters:
    pool - the ObjectPool in which to pool those Connections
  - getPool
```
public ObjectPool<PoolableConnection> getPool()
```
    Returns the ObjectPool in which Connections are pooled.
    
    Returns:
    the connection pool
  - setDefaultReadOnly
```
public void setDefaultReadOnly(Boolean defaultReadOnly)
```
    Sets the default "read only" setting for borrowed Connections
    
    Parameters:
    defaultReadOnly - the default "read only" setting for borrowed Connections
  - setDefaultAutoCommit
```
public void setDefaultAutoCommit(Boolean defaultAutoCommit)
```
    Sets the default "auto commit" setting for borrowed Connections
    
    Parameters:
    defaultAutoCommit - the default "auto commit" setting for borrowed Connections
  - setDefaultTransactionIsolation
```
public void setDefaultTransactionIsolation(int defaultTransactionIsolation)
```
    Sets the default "Transaction Isolation" setting for borrowed Connections
    
    Parameters:
    defaultTransactionIsolation - the default "Transaction Isolation" setting for returned Connections
  - setDefaultCatalog
```
public void setDefaultCatalog(String defaultCatalog)
```
    Sets the default "catalog" setting for borrowed Connections
    
    Parameters:
    defaultCatalog - the default "catalog" setting for borrowed Connections
  - setCacheState
```
public void setCacheState(boolean cacheState)
```
  - setPoolStatements
```
public void setPoolStatements(boolean poolStatements)
```
  - setMaxOpenPrepatedStatements
```
public void setMaxOpenPrepatedStatements(int maxOpenPreparedStatements)
```
  - setMaxConnLifetimeMillis
```
public void setMaxConnLifetimeMillis(long maxConnLifetimeMillis)
```
    Sets the maximum lifetime in milliseconds of a connection after which the connection will always fail activation, passivation and validation. A value of zero or less indicates an infinite lifetime. The default value is -1.
  - isEnableAutoCommitOnReturn
```
public boolean isEnableAutoCommitOnReturn()
```
  - setEnableAutoCommitOnReturn
```
public void setEnableAutoCommitOnReturn(boolean enableAutoCommitOnReturn)
```
  - isRollbackOnReturn
```
public boolean isRollbackOnReturn()
```
  - setRollbackOnReturn
```
public void setRollbackOnReturn(boolean rollbackOnReturn)
```
  - getDefaultQueryTimeout
```
public Integer getDefaultQueryTimeout()
```
  - setDefaultQueryTimeout
```
public void setDefaultQueryTimeout(Integer defaultQueryTimeout)
```
  - makeObject
```
public PooledObject<PoolableConnection> makeObject()
                                            throws Exception
```
    Specified by:
    
    makeObject in interface PooledObjectFactory<PoolableConnection>
    
    Throws:
    
    Exception
  - initializeConnection
```
protected void initializeConnection(Connection conn)
                             throws SQLException
```
    Throws:
    
    SQLException
  - destroyObject
```
public void destroyObject(PooledObject<PoolableConnection> p)
                   throws Exception
```
    Specified by:
    
    destroyObject in interface PooledObjectFactory<PoolableConnection>
    
    Throws:
    
    Exception
  - validateObject
```
public boolean validateObject(PooledObject<PoolableConnection> p)
```
    Specified by:
    
    validateObject in interface PooledObjectFactory<PoolableConnection>
  - validateConnection
```
public void validateConnection(PoolableConnection conn)
                        throws SQLException
```
    Throws:
    
    SQLException
  - passivateObject
```
public void passivateObject(PooledObject<PoolableConnection> p)
                     throws Exception
```
    Specified by:
    
    passivateObject in interface PooledObjectFactory<PoolableConnection>
    
    Throws:
    
    Exception
  - activateObject
```
public void activateObject(PooledObject<PoolableConnection> p)
                    throws Exception
```
    Specified by:
    
    activateObject in interface PooledObjectFactory<PoolableConnection>
    
    Throws:
    
    Exception
  - getConnectionFactory
```
protected ConnectionFactory getConnectionFactory()
```
  - getPoolStatements
```
protected boolean getPoolStatements()
```
  - getMaxOpenPreparedStatements
```
protected int getMaxOpenPreparedStatements()
```
  - getCacheState
```
protected boolean getCacheState()
```

Class PoolableConnectionFactory

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

PoolableConnectionFactory

Method Detail

setValidationQuery

setValidationQueryTimeout

setConnectionInitSql

setPool

getPool

setDefaultReadOnly

setDefaultAutoCommit

setDefaultTransactionIsolation

setDefaultCatalog

setCacheState

setPoolStatements

setMaxOpenPrepatedStatements

setMaxConnLifetimeMillis

isEnableAutoCommitOnReturn

setEnableAutoCommitOnReturn

isRollbackOnReturn

setRollbackOnReturn

getDefaultQueryTimeout

setDefaultQueryTimeout

makeObject

initializeConnection

destroyObject

validateObject

validateConnection

passivateObject

activateObject

getConnectionFactory

getPoolStatements

getMaxOpenPreparedStatements

getCacheState