org.apache.tomcat.dbcp.dbcp2

Class PoolingConnection

java.lang.Object

org.apache.tomcat.dbcp.dbcp2.AbandonedTrace

org.apache.tomcat.dbcp.dbcp2.DelegatingConnection<java.sql.Connection>

org.apache.tomcat.dbcp.dbcp2.PoolingConnection

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.Connection, java.sql.Wrapper, KeyedPooledObjectFactory<PStmtKey,DelegatingPreparedStatement>, TrackedUse

public class PoolingConnection
extends DelegatingConnection<java.sql.Connection>
implements KeyedPooledObjectFactory<PStmtKey,DelegatingPreparedStatement>

A DelegatingConnection that pools PreparedStatements.

The prepareStatement(java.lang.String) and prepareCall(java.lang.String) methods, rather than creating a new PreparedStatement each time, may actually pull the statement from a pool of unused statements. The Statement.close() method of the returned statement doesn't actually close the statement, but rather returns it to the pool. (See PoolablePreparedStatement, PoolableCallableStatement.)

Since:

2.0

Author:

Rodney Waldhoff, Dirk Verbeeck

See Also:

PoolablePreparedStatement

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected static class	PoolingConnection.StatementType The possible statement types.

Field Summary

Fields inherited from interface java.sql.Connection

TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary

Constructors

Constructor and Description
PoolingConnection(java.sql.Connection c) Constructor.

Method Summary

Modifier and Type	Method and Description
void	activateObject(PStmtKey key, PooledObject<DelegatingPreparedStatement> p) KeyedPooledObjectFactory method for activating pooled statements.
void	close() Close and free all PreparedStatements or CallableStatements from the pool, and close the underlying connection.
protected PStmtKey	createKey(java.lang.String sql) Create a PStmtKey for the given arguments.
protected PStmtKey	createKey(java.lang.String sql, int autoGeneratedKeys)
protected PStmtKey	createKey(java.lang.String sql, int resultSetType, int resultSetConcurrency) Create a PStmtKey for the given arguments.
protected PStmtKey	createKey(java.lang.String sql, int resultSetType, int resultSetConcurrency, PoolingConnection.StatementType stmtType) Create a PStmtKey for the given arguments.
protected PStmtKey	createKey(java.lang.String sql, PoolingConnection.StatementType stmtType) Create a PStmtKey for the given arguments.
void	destroyObject(PStmtKey key, PooledObject<DelegatingPreparedStatement> p) KeyedPooledObjectFactory method for destroying PoolablePreparedStatements and PoolableCallableStatements.
PooledObject<DelegatingPreparedStatement>	makeObject(PStmtKey key) KeyedPooledObjectFactory method for creating PoolablePreparedStatements or PoolableCallableStatements.
protected java.lang.String	normalizeSQL(java.lang.String sql) Normalize the given SQL statement, producing a canonical form that is semantically equivalent to the original.
void	passivateObject(PStmtKey key, PooledObject<DelegatingPreparedStatement> p) KeyedPooledObjectFactory method for passivating PreparedStatements or CallableStatements.
java.sql.CallableStatement	prepareCall(java.lang.String sql) Create or obtain a CallableStatement from the pool.
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency) Create or obtain a CallableStatement from the pool.
java.sql.PreparedStatement	prepareStatement(java.lang.String sql) Create or obtain a PreparedStatement from the pool.
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int autoGeneratedKeys)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency) Create or obtain a PreparedStatement from the pool.
void	setStatementPool(KeyedObjectPool<PStmtKey,DelegatingPreparedStatement> pool)
java.lang.String	toString() Returns a string representation of the metadata associated with the innermost delegate connection.
boolean	validateObject(PStmtKey key, PooledObject<DelegatingPreparedStatement> p) KeyedPooledObjectFactory method for validating pooled statements.

Methods inherited from class org.apache.tomcat.dbcp.dbcp2.DelegatingConnection

abort, activate, checkOpen, clearCachedState, clearWarnings, closeInternal, commit, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStatement, createStatement, createStatement, createStruct, getAutoCommit, getCacheState, getCatalog, getClientInfo, getClientInfo, getDefaultQueryTimeout, getDelegate, getDelegateInternal, getHoldability, getInnermostDelegate, getInnermostDelegateInternal, getMetaData, getNetworkTimeout, getSchema, getTransactionIsolation, getTypeMap, getWarnings, handleException, innermostDelegateEquals, isClosed, isClosedInternal, isReadOnly, isValid, isWrapperFor, nativeSQL, passivate, prepareCall, prepareStatement, prepareStatement, prepareStatement, releaseSavepoint, rollback, rollback, setAutoCommit, setCacheState, setCatalog, setClientInfo, setClientInfo, setClosedInternal, setDefaultQueryTimeout, setDelegate, setHoldability, setNetworkTimeout, setReadOnly, setSavepoint, setSavepoint, setSchema, setTransactionIsolation, setTypeMap, unwrap

Methods inherited from class org.apache.tomcat.dbcp.dbcp2.AbandonedTrace

addTrace, clearTrace, getLastUsed, getTrace, removeTrace, setLastUsed, setLastUsed

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

PoolingConnection

public PoolingConnection(java.sql.Connection c)

Constructor.

Parameters:

c - the underlying Connection.

Method Detail

setStatementPool

public void setStatementPool(KeyedObjectPool<PStmtKey,DelegatingPreparedStatement> pool)

close

public void close()
           throws java.sql.SQLException

Close and free all PreparedStatements or CallableStatements from the pool, and close the underlying connection.

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface java.sql.Connection

Overrides:

close in class DelegatingConnection<java.sql.Connection>

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql)
                                            throws java.sql.SQLException

Create or obtain a PreparedStatement from the pool.

Specified by:

prepareStatement in interface java.sql.Connection

Overrides:

prepareStatement in class DelegatingConnection<java.sql.Connection>

Parameters:

sql - the sql string used to define the PreparedStatement

Returns:

a PoolablePreparedStatement

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int autoGeneratedKeys)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

Overrides:

prepareStatement in class DelegatingConnection<java.sql.Connection>

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int resultSetType,
                                                   int resultSetConcurrency)
                                            throws java.sql.SQLException

Create or obtain a PreparedStatement from the pool.

Specified by:

prepareStatement in interface java.sql.Connection

Overrides:

prepareStatement in class DelegatingConnection<java.sql.Connection>

Parameters:

sql - the sql string used to define the PreparedStatement

resultSetType - result set type

resultSetConcurrency - result set concurrency

Returns:

a PoolablePreparedStatement

Throws:

java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql)
                                       throws java.sql.SQLException

Create or obtain a CallableStatement from the pool.

Specified by:

prepareCall in interface java.sql.Connection

Overrides:

prepareCall in class DelegatingConnection<java.sql.Connection>

Parameters:

sql - the sql string used to define the CallableStatement

Returns:

a PoolableCallableStatement

Throws:

java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql,
                                              int resultSetType,
                                              int resultSetConcurrency)
                                       throws java.sql.SQLException

Create or obtain a CallableStatement from the pool.

Specified by:

prepareCall in interface java.sql.Connection

Overrides:

prepareCall in class DelegatingConnection<java.sql.Connection>

Parameters:

sql - the sql string used to define the CallableStatement

resultSetType - result set type

resultSetConcurrency - result set concurrency

Returns:

a PoolableCallableStatement

Throws:

java.sql.SQLException

createKey

protected PStmtKey createKey(java.lang.String sql,
                             int autoGeneratedKeys)

createKey

protected PStmtKey createKey(java.lang.String sql,
                             int resultSetType,
                             int resultSetConcurrency)

Create a PStmtKey for the given arguments.

Parameters:

sql - the sql string used to define the statement

resultSetType - result set type

resultSetConcurrency - result set concurrency

createKey

protected PStmtKey createKey(java.lang.String sql,
                             int resultSetType,
                             int resultSetConcurrency,
                             PoolingConnection.StatementType stmtType)

Create a PStmtKey for the given arguments.

Parameters:

sql - the sql string used to define the statement

resultSetType - result set type

resultSetConcurrency - result set concurrency

stmtType - statement type

createKey

protected PStmtKey createKey(java.lang.String sql)

Create a PStmtKey for the given arguments.

Parameters:

sql - the sql string used to define the statement

createKey

protected PStmtKey createKey(java.lang.String sql,
                             PoolingConnection.StatementType stmtType)

Create a PStmtKey for the given arguments.

Parameters:

sql - the SQL string used to define the statement

stmtType - statement type

normalizeSQL

protected java.lang.String normalizeSQL(java.lang.String sql)

Normalize the given SQL statement, producing a canonical form that is semantically equivalent to the original.

makeObject

public PooledObject<DelegatingPreparedStatement> makeObject(PStmtKey key)
                                                     throws java.lang.Exception

KeyedPooledObjectFactory method for creating PoolablePreparedStatements or PoolableCallableStatements. The stmtType field in the key determines whether a PoolablePreparedStatement or PoolableCallableStatement is created.

Specified by:

makeObject in interface KeyedPooledObjectFactory<PStmtKey,DelegatingPreparedStatement>

Parameters:

key - the key for the PreparedStatement to be created

Returns:

a PooledObject wrapping an instance that can be served by the pool.

Throws:

java.lang.Exception - if there is a problem creating a new instance, this will be propagated to the code requesting an object.

See Also:

createKey(String, int, int, StatementType)

destroyObject

public void destroyObject(PStmtKey key,
                          PooledObject<DelegatingPreparedStatement> p)
                   throws java.lang.Exception

KeyedPooledObjectFactory method for destroying PoolablePreparedStatements and PoolableCallableStatements. Closes the underlying statement.

Specified by:

destroyObject in interface KeyedPooledObjectFactory<PStmtKey,DelegatingPreparedStatement>

Parameters:

key - ignored

p - the wrapped pooled statement to be destroyed.

Throws:

java.lang.Exception - should be avoided as it may be swallowed by the pool implementation.

See Also:

KeyedPooledObjectFactory.validateObject(K, org.apache.tomcat.dbcp.pool2.PooledObject<V>), KeyedObjectPool.invalidateObject(K, V)

validateObject

public boolean validateObject(PStmtKey key,
                              PooledObject<DelegatingPreparedStatement> p)

KeyedPooledObjectFactory method for validating pooled statements. Currently always returns true.

Specified by:

validateObject in interface KeyedPooledObjectFactory<PStmtKey,DelegatingPreparedStatement>

Parameters:

key - ignored

p - ignored

Returns:

true

activateObject

public void activateObject(PStmtKey key,
                           PooledObject<DelegatingPreparedStatement> p)
                    throws java.lang.Exception

KeyedPooledObjectFactory method for activating pooled statements.

Specified by:

activateObject in interface KeyedPooledObjectFactory<PStmtKey,DelegatingPreparedStatement>

Parameters:

key - ignored

p - wrapped pooled statement to be activated

Throws:

java.lang.Exception - if there is a problem activating obj, this exception may be swallowed by the pool.

See Also:

KeyedPooledObjectFactory.destroyObject(K, org.apache.tomcat.dbcp.pool2.PooledObject<V>)

passivateObject

public void passivateObject(PStmtKey key,
                            PooledObject<DelegatingPreparedStatement> p)
                     throws java.lang.Exception

KeyedPooledObjectFactory method for passivating PreparedStatements or CallableStatements. Invokes PreparedStatement.clearParameters().

Specified by:

passivateObject in interface KeyedPooledObjectFactory<PStmtKey,DelegatingPreparedStatement>

Parameters:

key - ignored

p - a wrapped PreparedStatement

Throws:

java.lang.Exception - if there is a problem passivating obj, this exception may be swallowed by the pool.

See Also:

KeyedPooledObjectFactory.destroyObject(K, org.apache.tomcat.dbcp.pool2.PooledObject<V>)

toString

public java.lang.String toString()

Description copied from class: DelegatingConnection

Returns a string representation of the metadata associated with the innermost delegate connection.

Overrides:

toString in class DelegatingConnection<java.sql.Connection>