oracle.ucp.jdbc

Class PooledConnectionConnectionPool

java.lang.Object

oracle.ucp.common.UniversalConnectionPoolBase

oracle.ucp.common.UniversalConnectionPoolImpl

oracle.ucp.jdbc.JDBCConnectionPool

oracle.ucp.jdbc.PooledConnectionConnectionPool

All Implemented Interfaces:

EventListener, ConnectionEventListener, oracle.ucp.common.Failoverable, UniversalConnectionPool

Direct Known Subclasses:

XAConnectionConnectionPool

public class PooledConnectionConnectionPool
extends JDBCConnectionPool
implements ConnectionEventListener

A JDBC connection pool that pools javax.sql.PooledConnection objects. This pool is a javax.sql.ConnectionEventListener and it gets registered as such on each javax.sql.PooledConnection that gets created by this connection pool. If the client closes the javax.sql.PooledConnection object manually (that is, the client does not call closeConnection or abortConnection), this pool is notified and removes the javax.sql.PooledConnection from this connection pool. If a connectionError event is fired, then this pool is notified and also removes the javax.sql.PooledConnection from this connection pool.

Field Summary

Fields inherited from class oracle.ucp.jdbc.JDBCConnectionPool

m_connectionInitializationCallback

Fields inherited from class oracle.ucp.common.UniversalConnectionPoolImpl

m_ucpInternal

Fields inherited from class oracle.ucp.common.UniversalConnectionPoolBase

borrowedAccumulator, borrowedConnectionsCount, borrowedSamples, core, DEFAULT_ABANDONED_CONNECTION_TIMEOUT, DEFAULT_CONNECTION_HARVEST_MAX_COUNT, DEFAULT_CONNECTION_HARVEST_TRIGGER_COUNT, DEFAULT_CONNECTION_WAIT_TIMEOUT, DEFAULT_INACTIVE_CONNECTION_TIMEOUT, DEFAULT_INITIAL_POOL_SIZE, DEFAULT_MAX_CONNECTIONS_PER_SERVICE, DEFAULT_MAX_CONNECTIONS_PER_SHARD, DEFAULT_MAX_POOL_SIZE, DEFAULT_MIN_POOL_SIZE, DEFAULT_POOLNAME_PREFIX, DEFAULT_QUERY_TIMEOUT, DEFAULT_SECONDS_TO_TRUST_IDLE_CONNECTION, DEFAULT_TIME_TO_LIVE_CONNECTION_TIMEOUT, DEFAULT_TIMEOUT_CHECK_INTERVAL, DEFAULT_VALIDATE_BORROWED_CONNECTION, logWriter, m_connectionAffinityCallback, m_connectionLabelingCallback, m_lifeCycleState, THREAD_POOL_SIZE, totalConnectionsCount

Constructor Summary

Constructors

Constructor and Description
PooledConnectionConnectionPool(JDBCConnectionFactoryAdapter connectionFactoryAdapter) Constructor.

Method Summary

Modifier and Type	Method and Description
boolean	closePooledConnection(PooledConnection pooledConnection) Closes the javax.sql.PooledConnection.
void	connectionClosed(ConnectionEvent event) Notifies this ConnectionEventListener that the application has called the method close on its representation of a pooled connection.
void	connectionErrorOccurred(ConnectionEvent event) Notifies this ConnectionEventListener that a fatal error has occurred and the pooled connection can no longer be used.
PooledConnection	getPooledConnection(JDBCConnectionRetrievalInfo connectionRetrievalInfo) Gets a javax.sql.PooledConnection from the connection pool.
boolean	returnPooledConnection(PooledConnection pooledConnection) Returns a javax.sql.PooledConnection back into the connection pool.
protected void	validateConstructor(JDBCConnectionFactoryAdapter connectionFactoryAdapter) Makes sure the constructor is valid.

Methods inherited from class oracle.ucp.jdbc.JDBCConnectionPool

borrowConnection, getConnectionInitializationCallback, getConnectionObjectForLabelingConfigure, getMaxStatements, getSQLForValidateConnection, registerConnectionInitializationCallback, setConnectionFactory, setMaxStatements, setSQLForValidateConnection, unregisterConnectionInitializationCallback

Methods inherited from class oracle.ucp.common.UniversalConnectionPoolImpl

closeConnection, closePhysicalConnection, closePooledConnection, closeUsedPhysicalConnection, computeBorrowGiveUpTimestamp, createOnePooledConnection, createOnePooledConnection, discardUsedConnection, getAvailableConnection, getStatistics, getUsedConnection, incrementCumulativeConnectionsCreated, isAffinityStrict, isStillOkayToBorrow, needToConfigureConnection, purge, recycle, refresh, returnConnection, returnUsedPhysicalConnection, setConnectionHarvestable, setNoWaitBorrow

Methods inherited from class oracle.ucp.common.UniversalConnectionPoolBase

getAbandonedConnectionsCount, getAbandonedConnectionTimeout, getAbandonedConnectionTimer, getAvailableConnectionsCount, getAverageBorrowedConnectionsCount, getBorrowedConnectionsCount, getConnectionAffinityCallback, getConnectionFactoryAdapter, getConnectionHarvestMaxCount, getConnectionHarvestTriggerCount, getConnectionLabelingCallback, getConnectionLabelingHighCost, getConnectionRepurposeThreshold, getConnectionRetrievalInfo, getConnectionWaitTimeout, getCumulativeConnectionBorrowedCount, getCumulativeConnectionReturnedCount, getCumulativeConnectionsCreated, getCumulativeConnectionUseTime, getCumulativeFailedConnectionWaitCount, getCumulativeFailedConnectionWaitTime, getCumulativeReturnedConnectionCount, getCumulativeSuccessfulConnectionWaitCount, getCumulativeSuccessfulConnectionWaitTime, getDatabaseTopologyInfo, getFailoverEventHandlerTask, getFailoverInfo, getHighCostConnectionReuseThreshold, getInactiveConnectionTimeout, getInactiveConnectionTimer, getInitialPoolSize, getLifeCycleState, getLoginTimeout, getLogWriter, getMaxConnectionReuseCount, getMaxConnectionReuseTime, getMaxConnectionsPerService, getMaxConnectionsPerShard, getMaxPoolSize, getMinPoolSize, getName, getONSConfiguration, getPeakConnectionsCount, getPeakConnectionWaitTime, getPendingRequestsCount, getQueryTimeout, getSecondsToTrustIdleConnection, getServiceName, getShardedDatabaseInfo, getShardRoutingCacheInfo, getTimeoutCheckInterval, getTimeToLiveConnectionTimeout, getTimeToLiveConnectionTimer, getTotalConnectionsCount, getValidateConnectionOnBorrow, handleFailoverEvent, ilogFine, ilogFinest, ilogThrowing, incrementConnectionsClosedCount, incrementConnectionsCreatedCount, isFailoverEnabled, isFailoverExplicitlySet, isLifecycleFailed, isLifecycleRunning, isLifecycleStarting, isLifecycleStopped, isLifecycleStopping, isRuntimeLoadBalancingEnabled, isShareable, reconfigure, registerConnectionAffinityCallback, registerConnectionLabelingCallback, removeConnectionAffinityCallback, removeConnectionLabelingCallback, resetAllPoolStatistics, resetNonCumulativePoolStatistics, setAbandonedConnectionTimeout, setConnectionHarvestMaxCount, setConnectionHarvestTriggerCount, setConnectionLabelingHighCost, setConnectionRepurposeThreshold, setConnectionRetrievalInfo, setConnectionWaitTimeout, setFailoverEnabled, setFailoverInfo, setHighCostConnectionReuseThreshold, setInactiveConnectionTimeout, setInitialPoolSize, setLoginTimeout, setLogWriter, setMaxConnectionReuseCount, setMaxConnectionReuseTime, setMaxConnectionsPerService, setMaxConnectionsPerShard, setMaxPoolSize, setMinPoolSize, setName, setONSConfiguration, setQueryTimeout, setRuntimeLoadBalancingEnabled, setSecondsToTrustIdleConnection, setShareable, setTimeoutCheckInterval, setTimeToLiveConnectionTimeout, setValidateConnectionOnBorrow, start, stop, validatePoolSizes

Methods inherited from class java.lang.Object

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

Constructor Detail

PooledConnectionConnectionPool

public PooledConnectionConnectionPool(JDBCConnectionFactoryAdapter connectionFactoryAdapter)
                               throws UniversalConnectionPoolException

Constructor.

Parameters:

connectionFactoryAdapter - The connection factory adapter.

Throws:

UniversalConnectionPoolException - If an error occurs constructing this.

Method Detail

getPooledConnection

public PooledConnection getPooledConnection(JDBCConnectionRetrievalInfo connectionRetrievalInfo)
                                     throws UniversalConnectionPoolException

Gets a javax.sql.PooledConnection from the connection pool.

Parameters:

connectionRetrievalInfo - Info to use to get the javax.sql.PooledConnection.

Returns:

A javax.sql.PooledConnection.

Throws:

UniversalConnectionPoolException - if an error occurs getting a javax.sql.PooledConnection.

NoAvailableConnectionsException - if all of the connections are in use.

returnPooledConnection

public boolean returnPooledConnection(PooledConnection pooledConnection)
                               throws UniversalConnectionPoolException

Returns a javax.sql.PooledConnection back into the connection pool.

Parameters:

pooledConnection - The javax.sql.PooledConnection to return back into the pool.

Returns:

true if the javax.sql.PooledConnection is in use and was returned to the pool; false otherwise.

Throws:

UniversalConnectionPoolException - if an error occurs returning the javax.sql.PooledConnection.

closePooledConnection

public boolean closePooledConnection(PooledConnection pooledConnection)
                              throws UniversalConnectionPoolException

Closes the javax.sql.PooledConnection. Do not put it back into the pool.

Parameters:

pooledConnection - The javax.sql.PooledConnection to close.

Returns:

true if the javax.sql.PooledConnection is in use and was closed. false otherwise.

Throws:

UniversalConnectionPoolException - if an error occurs closing the javax.sql.PooledConnection.

validateConstructor

protected void validateConstructor(JDBCConnectionFactoryAdapter connectionFactoryAdapter)
                            throws UniversalConnectionPoolException

Makes sure the constructor is valid.

Parameters:

connectionFactoryAdapter - the connection factory adapter.

Throws:

UniversalConnectionPoolException - If an error occurs.

connectionClosed

public void connectionClosed(ConnectionEvent event)

Notifies this ConnectionEventListener that the application has called the method close on its representation of a pooled connection.

Specified by:

connectionClosed in interface ConnectionEventListener

Parameters:

event - An event object describing the source of the event.

connectionErrorOccurred

public void connectionErrorOccurred(ConnectionEvent event)

Notifies this ConnectionEventListener that a fatal error has occurred and the pooled connection can no longer be used. The driver makes this notification just before it throws the application the SQLException contained in the given ConnectionEvent object.

Specified by:

connectionErrorOccurred in interface ConnectionEventListener

Parameters:

event - An event object describing the source of the event and containing the SQLException that the driver is about to throw.