oracle.ucp.jdbc.oracle

Class OraclePooledConnectionConnectionPool

java.lang.Object

oracle.ucp.common.UniversalConnectionPoolBase

oracle.ucp.common.UniversalConnectionPoolImpl

oracle.ucp.jdbc.JDBCConnectionPool

oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool

oracle.ucp.jdbc.oracle.OraclePooledConnectionConnectionPool

All Implemented Interfaces:

EventListener, ConnectionEventListener, oracle.ucp.common.Failoverable, RACCallback, RACManagerImpl.RACCallbackExtended, UniversalConnectionPool

Direct Known Subclasses:

OracleXAConnectionConnectionPool

public class OraclePooledConnectionConnectionPool
extends OracleJDBCConnectionPool
implements ConnectionEventListener

Oracle-specific JDBC pool that handles JDBC pooled connections.

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

availCondition, availLock, 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
OraclePooledConnectionConnectionPool(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 close method 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.

Methods inherited from class oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool

borrowConnection, closePhysicalConnection, createOnePooledConnection, getAvailableConnections, getAvailableConnectionToInstance, getConnectionRepurposeCount, getDRCPPLSQLCallbackName, getFailedAffinityBasedBorrowCount, getFailedAffinityBasedBorrowCount, getFailedRCLBBasedBorrowCount, getFailedRCLBBasedBorrowCount, getFCFProcessingInfo, getFCFProcessingInfo, getFCFProcessingInfoProcessedOnly, getFCFProcessingInfoProcessedOnly, getPoolName, getRoomToGrowPool, getShardConnectionStats, getStatistics, getSuccessfulAffinityBasedBorrowCount, getSuccessfulAffinityBasedBorrowCount, getSuccessfulRCLBBasedBorrowCount, getSuccessfulRCLBBasedBorrowCount, getUrl, initiateDownEventProcessing, initiateUpEventProcessing, isDRCPEnabled, isDRCPMultiTagEnabled, isRuntimeLoadBalancingEnabled, isValid, lbaEventOccurred, onAddingConnectionToPool, onRemovingConnectionFromPool, openNewConnection, registerConnectionAffinityCallback, removeConnectionAffinityCallback, start, superClosePhysicalConnection, tearDownConnectionsForInstance, useStrictWebSessionAffinity, useStrictXAAffinity

Methods inherited from class oracle.ucp.jdbc.JDBCConnectionPool

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

Methods inherited from class oracle.ucp.common.UniversalConnectionPoolImpl

closeConnection, closeUsedPhysicalConnection, createOnePooledConnection, discardUsedConnection, getAvailableConnection, getUsedConnection, incrementCumulativeConnectionsCreated, isAffinityStrict, needToConfigureConnection, purge, recycle, refresh, returnConnection, returnUsedPhysicalConnection, setConnectionHarvestable

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, isShareable, reconfigure, registerConnectionLabelingCallback, 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, stop, validatePoolSizes

Methods inherited from class java.lang.Object

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

Methods inherited from interface oracle.ucp.jdbc.oracle.RACCallback

getMaxPoolSize, getMinPoolSize, getTotalConnectionsCount, getValidateConnectionOnBorrow

Constructor Detail

OraclePooledConnectionConnectionPool

public OraclePooledConnectionConnectionPool(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.

connectionClosed

public void connectionClosed(ConnectionEvent event)

Notifies this ConnectionEventListener that the application has called the close method 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