oracle.ucp.jdbc

Class ConnectionConnectionPool

java.lang.Object

oracle.ucp.common.UniversalConnectionPoolBase

oracle.ucp.common.UniversalConnectionPoolImpl

oracle.ucp.jdbc.JDBCConnectionPool

oracle.ucp.jdbc.ConnectionConnectionPool

All Implemented Interfaces:

oracle.ucp.common.Failoverable, UniversalConnectionPool

public class ConnectionConnectionPool
extends JDBCConnectionPool

A JDBC connection pool that pools java.sql.Connection objects. The use of this pool is responsible for making sure that close is not called on the java.sql.Connection unless it is explicitly desired. Clients are expected to create a proxy for the java.sql.Connection borrowed from this pool and to return the borrowed java.sql.Connection back into the pool after the JDBC application has closed the connection proxy.

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
ConnectionConnectionPool(JDBCConnectionFactoryAdapter connectionFactoryAdapter) Constructor.

Method Summary

Modifier and Type	Method and Description
boolean	closeConnection(Connection connection) Closes the java.sql.Connection.
Connection	getConnection(JDBCConnectionRetrievalInfo connectionRetrievalInfo) Gets a java.sql.Connection from the connection pool.
boolean	returnConnection(Connection connection) Returns a java.sql.Connection back into the connection pool.

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

ConnectionConnectionPool

public ConnectionConnectionPool(JDBCConnectionFactoryAdapter connectionFactoryAdapter)
                         throws UniversalConnectionPoolException

Constructor.

Parameters:

connectionFactoryAdapter - The connection factory adapter.

Throws:

UniversalConnectionPoolException - If an error occurs constructing this.

Method Detail

getConnection

public Connection getConnection(JDBCConnectionRetrievalInfo connectionRetrievalInfo)
                         throws UniversalConnectionPoolException

Gets a java.sql.Connection from the connection pool. This is a physical connection, not a proxy.

Parameters:

connectionRetrievalInfo - Info to use to get the java.sql.Connection.

Returns:

A physical java.sql.Connection.

Throws:

UniversalConnectionPoolException - if an error occurs getting a java.sql.Connection.

NoAvailableConnectionsException - if all of the connections are in use.

returnConnection

public boolean returnConnection(Connection connection)
                         throws UniversalConnectionPoolException

Returns a java.sql.Connection back into the connection pool.

Parameters:

connection - The java.sql.Connection to return back into the pool.

Returns:

true if the java.sql.Connection is in use and was returned to the pool. false otherwise.

Throws:

UniversalConnectionPoolException - if an error occurs when returning the java.sql.Connection.

closeConnection

public boolean closeConnection(Connection connection)
                        throws UniversalConnectionPoolException

Closes the java.sql.Connection. Do not put it back into the pool.

Parameters:

connection - The java.sql.Connection to close.

Returns:

true if the java.sql.Connection is in use and was closed; false otherwise.

Throws:

UniversalConnectionPoolException - if an error occurs closing the java.sql.Connection.