public class PoolingConnection extends DelegatingConnection implements Connection, KeyedPoolableObjectFactory
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.)
PoolablePreparedStatement| Modifier and Type | Field and Description |
|---|---|
protected KeyedObjectPool |
_pstmtPool
Pool of
PreparedStatements. |
_closed, _connTRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE| Constructor and Description |
|---|
PoolingConnection(Connection c)
Constructor.
|
PoolingConnection(Connection c,
KeyedObjectPool pool)
Constructor.
|
| Modifier and Type | Method and Description |
|---|---|
void |
activateObject(Object key,
Object obj) |
void |
close()
Close and free all
PreparedStatements or CallableStatement from the pool, and
close the underlying connection. |
protected Object |
createKey(String sql) |
protected Object |
createKey(String sql,
byte stmtType) |
protected Object |
createKey(String sql,
int resultSetType,
int resultSetConcurrency) |
protected Object |
createKey(String sql,
int resultSetType,
int resultSetConcurrency,
byte stmtType) |
void |
destroyObject(Object key,
Object obj) |
Object |
makeObject(Object obj) |
protected String |
normalizeSQL(String sql) |
void |
passivateObject(Object key,
Object obj) |
CallableStatement |
prepareCall(String sql) |
CallableStatement |
prepareCall(String sql,
int resultSetType,
int resultSetConcurrency) |
PreparedStatement |
prepareStatement(String sql)
Create or obtain a
PreparedStatement from the pool. |
PreparedStatement |
prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency)
Create or obtain a
PreparedStatement from the pool. |
String |
toString()
Returns a string representation of the metadata associated with
the innnermost delegate connection.
|
boolean |
validateObject(Object key,
Object obj) |
abort, activate, checkOpen, clearWarnings, commit, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStatement, createStatement, createStatement, createStruct, equals, getAutoCommit, getCatalog, getClientInfo, getClientInfo, getDelegate, getDelegateInternal, getHoldability, getInnermostDelegate, getInnermostDelegateInternal, getMetaData, getNetworkTimeout, getSchema, getTransactionIsolation, getTypeMap, getWarnings, handleException, hashCode, innermostDelegateEquals, isClosed, isReadOnly, isValid, isWrapperFor, nativeSQL, passivate, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, releaseSavepoint, rollback, rollback, setAutoCommit, setCatalog, setClientInfo, setClientInfo, setDelegate, setHoldability, setNetworkTimeout, setReadOnly, setSavepoint, setSavepoint, setSchema, setTransactionIsolation, setTypeMap, unwrapaddTrace, clearTrace, getConfig, getLastUsed, getTrace, printStackTrace, removeTrace, setLastUsed, setLastUsed, setStackTraceclone, finalize, getClass, notify, notifyAll, wait, wait, waitabort, clearWarnings, commit, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStatement, createStatement, createStatement, createStruct, getAutoCommit, getCatalog, getClientInfo, getClientInfo, getHoldability, getMetaData, getNetworkTimeout, getSchema, getTransactionIsolation, getTypeMap, getWarnings, isClosed, isReadOnly, isValid, nativeSQL, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, releaseSavepoint, rollback, rollback, setAutoCommit, setCatalog, setClientInfo, setClientInfo, setHoldability, setNetworkTimeout, setReadOnly, setSavepoint, setSavepoint, setSchema, setTransactionIsolation, setTypeMapisWrapperFor, unwrapprotected KeyedObjectPool _pstmtPool
PreparedStatements. and CallableStatementspublic PoolingConnection(Connection c)
c - the underlying Connection.public PoolingConnection(Connection c, KeyedObjectPool pool)
c - the underlying Connection.pool - KeyedObjectPool of PreparedStatements and CallableStatements.public void close()
throws SQLException
PreparedStatements or CallableStatement from the pool, and
close the underlying connection.close in interface AutoCloseableclose in interface Connectionclose in class DelegatingConnectionSQLExceptionpublic PreparedStatement prepareStatement(String sql) throws SQLException
PreparedStatement from the pool.prepareStatement in interface ConnectionprepareStatement in class DelegatingConnectionsql - the sql string used to define the PreparedStatementPoolablePreparedStatementSQLExceptionpublic PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency) throws SQLException
PreparedStatement from the pool.prepareStatement in interface ConnectionprepareStatement in class DelegatingConnectionsql - the sql string used to define the PreparedStatementresultSetType - result set typeresultSetConcurrency - result set concurrencyPoolablePreparedStatementSQLExceptionpublic CallableStatement prepareCall(String sql) throws SQLException
prepareCall in interface ConnectionprepareCall in class DelegatingConnectionSQLExceptionpublic CallableStatement prepareCall(String sql, int resultSetType, int resultSetConcurrency) throws SQLException
prepareCall in interface ConnectionprepareCall in class DelegatingConnectionSQLExceptionprotected Object createKey(String sql, int resultSetType, int resultSetConcurrency, byte stmtType)
public Object makeObject(Object obj) throws Exception
makeObject in interface KeyedPoolableObjectFactoryExceptionpublic void destroyObject(Object key, Object obj) throws Exception
destroyObject in interface KeyedPoolableObjectFactoryExceptionpublic boolean validateObject(Object key, Object obj)
validateObject in interface KeyedPoolableObjectFactorypublic void activateObject(Object key, Object obj) throws Exception
activateObject in interface KeyedPoolableObjectFactoryExceptionpublic void passivateObject(Object key, Object obj) throws Exception
passivateObject in interface KeyedPoolableObjectFactoryExceptionpublic String toString()
DelegatingConnectiontoString in class DelegatingConnectionCopyright © 2017. All rights reserved.