Package org.apache.commons.dbcp2

Class PoolablePreparedStatement<K>

java.lang.Object

org.apache.commons.dbcp2.AbandonedTrace

org.apache.commons.dbcp2.DelegatingStatement

org.apache.commons.dbcp2.DelegatingPreparedStatement

org.apache.commons.dbcp2.PoolablePreparedStatement<K>

Type Parameters:

K - the key type

public class PoolablePreparedStatement<K>
extends DelegatingPreparedStatement

A DelegatingPreparedStatement that cooperates with PoolingConnection to implement a pool of PreparedStatements.

My close() method returns me to my containing pool. (See PoolingConnection.)

Since:

2.0

Version:

$Id: PoolablePreparedStatement.java 1649430 2015-01-04 21:29:32Z tn $

Author:

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

See Also:

PoolingConnection

Field Summary

Fields inherited from interface java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Constructor Summary

Constructors

Constructor	Description
PoolablePreparedStatement(java.sql.PreparedStatement stmt, K key, org.apache.commons.pool2.KeyedObjectPool<K,PoolablePreparedStatement<K>> pool, DelegatingConnection<?> conn)	Constructor

Method Summary

Modifier and Type	Method	Description
void	activate()
void	addBatch()	Add batch.
void	clearBatch()	Clear Batch.
void	close()	Return me to my pool.
void	passivate()

Methods inherited from class org.apache.commons.dbcp2.AbandonedTrace

getLastUsed

Methods inherited from class org.apache.commons.dbcp2.DelegatingPreparedStatement

clearParameters, execute, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, toString

Methods inherited from class org.apache.commons.dbcp2.DelegatingStatement

addBatch, cancel, clearWarnings, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getDelegate, getFetchDirection, getFetchSize, getGeneratedKeys, getInnermostDelegate, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setCursorName, setDelegate, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.PreparedStatement

executeLargeUpdate, setObject, setObject

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearWarnings, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Detail

PoolablePreparedStatement

public PoolablePreparedStatement(java.sql.PreparedStatement stmt,
                                 K key,
                                 org.apache.commons.pool2.KeyedObjectPool<K,PoolablePreparedStatement<K>> pool,
                                 DelegatingConnection<?> conn)

Constructor

Parameters:

stmt - my underlying PreparedStatement

key - my key" as used by KeyedObjectPool

pool - the KeyedObjectPool from which I was obtained.

conn - the Connection from which I was created

Method Detail

activate

public void activate()
              throws java.sql.SQLException

Throws:

java.sql.SQLException

addBatch

public void addBatch()
              throws java.sql.SQLException

Add batch.

Overrides:

addBatch in class DelegatingPreparedStatement

Throws:

java.sql.SQLException

clearBatch

public void clearBatch()
                throws java.sql.SQLException

Clear Batch.

Overrides:

clearBatch in class DelegatingStatement

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Return me to my pool.

Overrides:

close in class DelegatingStatement

Throws:

java.sql.SQLException

passivate

public void passivate()
               throws java.sql.SQLException

Throws:

java.sql.SQLException