PoolDataSource (Oracle Database JDBC and UCP Java API Reference)

All Superinterfaces:

CommonDataSource, DataSource, Wrapper

All Known Subinterfaces:

PoolXADataSource

All Known Implementing Classes:

PoolDataSourceImpl, PoolXADataSourceImpl
```
public interface PoolDataSource
extends DataSource
```
A connection pool-aware data source interface. PoolDataSource uses Universal Connection Pool internally. See setters for pool properties and their default values.

See Also:

UniversalConnectionPool

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`UCP_ABANDONED_CONNECTION_TIMEOUT`
`static String`	`UCP_CONNECTION_AFFINITY_CALLBACK`
`static String`	`UCP_CONNECTION_FACTORY_CLASS_NAME`
`static String`	`UCP_CONNECTION_FACTORY_PROPERTIES`
`static String`	`UCP_CONNECTION_HARVEST_MAX_COUNT`
`static String`	`UCP_CONNECTION_HARVEST_TRIGGER_COUNT`
`static String`	`UCP_CONNECTION_INITIALIZATION_CALLBACK`
`static String`	`UCP_CONNECTION_LABELING_CALLBACK`
`static String`	`UCP_CONNECTION_LABELING_HIGH_COST`
`static String`	`UCP_CONNECTION_POOL_NAME`
`static String`	`UCP_CONNECTION_PROPERTIES`
`static String`	`UCP_CONNECTION_REPURPOSE_THRESHOLD`
`static String`	`UCP_CONNECTION_WAIT_TIMEOUT`
`static String`	`UCP_DATA_SOURCE_FROM_CONFIGURATION`
`static String`	`UCP_DATA_SOURCE_NAME`
`static String`	`UCP_DATABASE_NAME`
`static String`	`UCP_DESCRIPTION`
`static String`	`UCP_FAST_CONNECTION_FAILOVER_ENABLED`
`static String`	`UCP_HIGH_COST_CONNECTION_REUSE_THRESHOLD`
`static String`	`UCP_INACTIVE_CONNECTION_TIMEOUT`
`static String`	`UCP_INITIAL_POOL_SIZE`
`static String`	`UCP_LOGIN_TIMEOUT`
`static String`	`UCP_MAX_CONNECTION_REUSE_COUNT`
`static String`	`UCP_MAX_CONNECTION_REUSE_TIME`
`static String`	`UCP_MAX_CONNECTIONS_PER_SERVICE`
`static String`	`UCP_MAX_CONNECTIONS_PER_SHARD`
`static String`	`UCP_MAX_IDLE_TIME`
`static String`	`UCP_MAX_POOL_SIZE`
`static String`	`UCP_MAX_STATEMENTS`
`static String`	`UCP_MIN_POOL_SIZE`
`static String`	`UCP_NETWORK_PROTOCOL`
`static String`	`UCP_NTH_RETURNED_CONNECTION_TO_VALIDATE`
`static String`	`UCP_ONS_CONFIGURATION`
`static String`	`UCP_PASSWORD`
`static String`	`UCP_PDB_ROLES`
`static String`	`UCP_PORT_NUMBER`
`static String`	`UCP_PROPERTY_CYCLE`
`static String`	`UCP_ROLE_NAME`
`static String`	`UCP_SECONDS_TO_TRUST_IDLE_CONNECTION`
`static String`	`UCP_SERVER_NAME`
`static String`	`UCP_SERVICE_NAME`
`static String`	`UCP_SQL_FOR_VALIDATE_CONNECTION`
`static String`	`UCP_TIME_TO_LIVE_CONNECTION_TIMEOUT`
`static String`	`UCP_TIMEOUT_CHECK_INTERVAL`
`static String`	`UCP_URL`
`static String`	`UCP_USER`
`static String`	`UCP_VALIDATE_CONNECTION_ON_BORROW`

Method Summary

All Methods Instance Methods Abstract Methods Default Methods
Modifier and Type	Method and Description
`UCPConnectionBuilder`	`createConnectionBuilder()` Creates a new UCPConnectionBuilder instance.
`default OracleShardingKeyBuilder`	`createShardingKeyBuilder()` Creates a new OracleShardingKeyBuilder instance
`int`	`getAbandonedConnectionTimeout()` Gets the abandoned connection timeout value.
`int`	`getAvailableConnectionsCount()` Gets the number of available connections in the pool.
`int`	`getBorrowedConnectionsCount()` Gets the number of borrowed connections from the pool.
`Connection`	`getConnection(Properties labels)` Attempts to obtain a database connection with the requested connection labels.
`Connection`	`getConnection(String username, String password, Properties labels)` Attempts to obtain a database connection with the requested connection labels.
`String`	`getConnectionFactoryClassName()` Gets the Connection Factory class name.
`Properties`	`getConnectionFactoryProperties()` Gets the connection factory properties that are set on this data source.
`String`	`getConnectionFactoryProperty(String propertyName)` Gets the specified connection factory property that are set on this data source.
`int`	`getConnectionHarvestMaxCount()` Gets the maximum number of connections that may be harvested when the connection harvesting occurs.
`int`	`getConnectionHarvestTriggerCount()` Gets the number of available connections below which the connection pool's connection harvesting will occur.
`ConnectionInitializationCallback`	`getConnectionInitializationCallback()` Obtains the registered connection initialization callback, if any.
`int`	`getConnectionLabelingHighCost()` Obtains the cost value which identifies a connection as "high-cost" for connection labeling.
`String`	`getConnectionPoolName()` Gets the connection pool name.
`Properties`	`getConnectionProperties()` Gets the connection properties that are set on this data source.
`String`	`getConnectionProperty(String propertyName)` Gets the specified connection property that are set on this data source.
`int`	`getConnectionRepurposeThreshold()` Gets the connection repurpose threshold for the pool.
`int`	`getConnectionWaitTimeout()` Gets the amount of time to wait (in seconds) for a used connection to be released by a client.
`String`	`getDatabaseName()` Gets the database name.
`String`	`getDataSourceName()` Gets the data source name.
`String`	`getDescription()` Gets the data source description.
`boolean`	`getFastConnectionFailoverEnabled()` Checks if Fast Connection Failover is enabled.
`int`	`getHighCostConnectionReuseThreshold()` Obtains the high-cost connection reuse threshold property value for connection labeling.
`int`	`getInactiveConnectionTimeout()` Gets the inactive connection timeout.
`int`	`getInitialPoolSize()` Gets the initial pool size.
`int`	`getMaxConnectionReuseCount()` Gets the maximum connection reuse count property value.
`long`	`getMaxConnectionReuseTime()` Gets the maximum connection reuse time property value.
`int`	`getMaxConnectionsPerService()` Gets the maximum number of connections that can be obtained to a particular service, in a shared pool.
`int`	`getMaxConnectionsPerShard()` Gets the currently configured max connections that can be created per shard from this connection pool.
`int`	`getMaxIdleTime()` Gets the maximum idle time.
`int`	`getMaxPoolSize()` Gets the maximum number of connections that the connection pool will maintain.
`int`	`getMaxStatements()` Gets the maximum number of statements that may be pooled or cached on a Connection.
`int`	`getMinPoolSize()` Gets the minimum number of connections that the connection pool will maintain.
`String`	`getNetworkProtocol()` Gets the data source network protocol.
`String`	`getONSConfiguration()` Returns the ONS configuration string that is used for remote ONS subscription in the form specified in `setONSConfiguration(String)`.
`String`	`getPassword()` Gets the Password for this data source.
`Properties`	`getPdbRoles()` Gets the PDB roles specified for this datasource
`int`	`getPortNumber()` Gets the database port number.
`int`	`getPropertyCycle()` Gets the property cycle in seconds.
`int`	`getQueryTimeout()` Gets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.
`String`	`getRoleName()` Gets the data source role name.
`int`	`getSecondsToTrustIdleConnection()` Gets the seconds To Trust Idle Connection value.
`String`	`getServerName()` Gets the database server name.
`String`	`getServiceName()` Gets the service name set on this data source
`String`	`getSQLForValidateConnection()` Gets the value of the `SQLForValidateConnection` property.
`JDBCConnectionPoolStatistics`	`getStatistics()` Gets the statistics of the connection pool.
`int`	`getTimeoutCheckInterval()` Gets the timeout check interval (in seconds).
`int`	`getTimeToLiveConnectionTimeout()` Gets the maximum time (in seconds) a connection may remain in-use.
`String`	`getURL()` Gets the URL for this data source.
`String`	`getUser()` Gets the user name for this data source.
`boolean`	`getValidateConnectionOnBorrow()` Returns whether or not a connection being borrowed should first be validated.
`void`	`reconfigureDataSource(Properties configuration)` Reconfigures the data source.
`void`	`registerConnectionAffinityCallback(ConnectionAffinityCallback cbk)` Registers a connection affinity callback on the connection pool.
`void`	`registerConnectionInitializationCallback(ConnectionInitializationCallback cbk)` Registers a connection initialization callback.
`void`	`registerConnectionLabelingCallback(ConnectionLabelingCallback cbk)` Registers a connection labeling callback with the underlying connection pool.
`void`	`removeConnectionAffinityCallback()` Removes the `ConnectionAffinityCallback` object registered on the connection pool.
`void`	`removeConnectionLabelingCallback()` Removes the `ConnectionLabelingCallback` object registered with the underlying connection pool, if any.
`void`	`setAbandonedConnectionTimeout(int abandonedConnectionTimeout)` Sets the abandoned connection timeout.
`void`	`setConnectionFactoryClassName(String factoryClassName)` Sets the Connection Factory class name.
`void`	`setConnectionFactoryProperties(Properties factoryProperties)` Sets the connection factory properties on the connection factory.
`void`	`setConnectionFactoryProperty(String name, String value)` Sets a connection factory property on the connection factory.
`void`	`setConnectionHarvestMaxCount(int connectionHarvestMaxCount)` Sets the maximum number of connections that may be harvested when the connection harvesting occurs.
`void`	`setConnectionHarvestTriggerCount(int connectionHarvestTriggerCount)` Sets the number of available connections below which the connection pool's connection harvesting will occur.
`void`	`setConnectionLabelingHighCost(int highCost)` Sets the cost value which identifies a connection as "high-cost" for connection labeling.
`void`	`setConnectionPoolName(String connectionpoolName)` Sets the connection pool name.
`void`	`setConnectionProperties(Properties connectionProperties)` Sets the connection properties on the connection factory.
`void`	`setConnectionProperty(String name, String value)` Sets a connection property on the connection factory.
`void`	`setConnectionRepurposeThreshold(int threshold)` Sets the connection repurpose threshold for the pool.
`void`	`setConnectionWaitTimeout(int waitTimeout)` Sets the amount of time to wait (in seconds) for a used connection to be released by a client.
`void`	`setDatabaseName(String databaseName)` Sets the database name.
`void`	`setDataSourceName(String dataSourceName)` Sets the data source name.
`void`	`setDescription(String description)` Sets the data source description.
`void`	`setFastConnectionFailoverEnabled(boolean failoverEnabled)` Enables Fast Connection Failover (FCF) for the connection pool accessed using this pool-enabled data source.
`void`	`setHighCostConnectionReuseThreshold(int threshold)` Sets the high-cost connection reuse threshold for connection labeling.
`void`	`setInactiveConnectionTimeout(int inactivityTimeout)` Sets the inactive connection timeout.
`void`	`setInitialPoolSize(int initialPoolSize)` Sets the initial pool size.
`void`	`setMaxConnectionReuseCount(int maxConnectionReuseCount)` Sets the maximum connection reuse count property.
`void`	`setMaxConnectionReuseTime(long maxConnectionReuseTime)` Sets the maximum connection reuse time property.
`void`	`setMaxConnectionsPerShard(int maxConnectionsPerShard)` Sets the max number of connections that can be created per shard from this connection pool.
`void`	`setMaxIdleTime(int idleTime)` Sets the maximum idle time for available connections in the pool.
`void`	`setMaxPoolSize(int maxPoolSize)` Sets the maximum number of connections.
`void`	`setMaxStatements(int maxStatements)` Sets the maximum number of statements that may be pooled or cached on a connection.
`void`	`setMinPoolSize(int minPoolSize)` Sets the minimum number of connections.
`void`	`setNetworkProtocol(String networkProtocol)` Sets the data source network protocol.
`void`	`setONSConfiguration(String onsConfigStr)` Sets the configuration string used for remote ONS subscription.
`void`	`setPassword(String pd)` Sets the password with which connections have to be obtained.
`void`	`setPortNumber(int portNumber)` Sets the database port number.
`void`	`setPropertyCycle(int propertyCycle)` Sets the property cycle in seconds.
`void`	`setQueryTimeout(int queryTimeout)` Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.
`void`	`setRoleName(String roleName)` Sets the data source role name.
`void`	`setSecondsToTrustIdleConnection(int secondsToTrustIdleConnection)` Sets the time in seconds to trust an idle connection to skip a validation test.
`void`	`setServerName(String serverName)` Sets the database server name.
`void`	`setSQLForValidateConnection(String SQLString)` Sets the value of the `SQLForValidateConnection` property.
`void`	`setTimeoutCheckInterval(int timeInterval)` Sets the timeoutCheckInterval (in seconds).
`void`	`setTimeToLiveConnectionTimeout(int timeToLiveConnectionTimeout)` Sets the maximum time (in seconds) a connection may remain in-use.
`void`	`setURL(String url)` Sets the URL that the data source uses to obtain connections to the database.
`void`	`setUser(String userName)` Sets the user name with which connections have to be obtained.
`void`	`setValidateConnectionOnBorrow(boolean validateConnectionOnBorrow)` Sets whether or not a connection being borrowed should first be validated.
`void`	`unregisterConnectionInitializationCallback()` Unregisters the connection initialization callback on this pool.

Methods inherited from interface javax.sql.DataSource
getConnection, getConnection

Methods inherited from interface javax.sql.CommonDataSource
getLoginTimeout, getLogWriter, getParentLogger, setLoginTimeout, setLogWriter

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

- Field Detail
  - UCP_USER
```
static final String UCP_USER
```
    See Also:
    
    Constant Field Values
  - UCP_URL
```
static final String UCP_URL
```
    See Also:
    
    Constant Field Values
  - UCP_PASSWORD
```
static final String UCP_PASSWORD
```
    See Also:
    
    Constant Field Values
  - UCP_SERVER_NAME
```
static final String UCP_SERVER_NAME
```
    See Also:
    
    Constant Field Values
  - UCP_PORT_NUMBER
```
static final String UCP_PORT_NUMBER
```
    See Also:
    
    Constant Field Values
  - UCP_DATABASE_NAME
```
static final String UCP_DATABASE_NAME
```
    See Also:
    
    Constant Field Values
  - UCP_DATA_SOURCE_NAME
```
static final String UCP_DATA_SOURCE_NAME
```
    See Also:
    
    Constant Field Values
  - UCP_DESCRIPTION
```
static final String UCP_DESCRIPTION
```
    See Also:
    
    Constant Field Values
  - UCP_NETWORK_PROTOCOL
```
static final String UCP_NETWORK_PROTOCOL
```
    See Also:
    
    Constant Field Values
  - UCP_ROLE_NAME
```
static final String UCP_ROLE_NAME
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_FACTORY_CLASS_NAME
```
static final String UCP_CONNECTION_FACTORY_CLASS_NAME
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_PROPERTIES
```
static final String UCP_CONNECTION_PROPERTIES
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_FACTORY_PROPERTIES
```
static final String UCP_CONNECTION_FACTORY_PROPERTIES
```
    See Also:
    
    Constant Field Values
  - UCP_VALIDATE_CONNECTION_ON_BORROW
```
static final String UCP_VALIDATE_CONNECTION_ON_BORROW
```
    See Also:
    
    Constant Field Values
  - UCP_SQL_FOR_VALIDATE_CONNECTION
```
static final String UCP_SQL_FOR_VALIDATE_CONNECTION
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_POOL_NAME
```
static final String UCP_CONNECTION_POOL_NAME
```
    See Also:
    
    Constant Field Values
  - UCP_INITIAL_POOL_SIZE
```
static final String UCP_INITIAL_POOL_SIZE
```
    See Also:
    
    Constant Field Values
  - UCP_MIN_POOL_SIZE
```
static final String UCP_MIN_POOL_SIZE
```
    See Also:
    
    Constant Field Values
  - UCP_MAX_POOL_SIZE
```
static final String UCP_MAX_POOL_SIZE
```
    See Also:
    
    Constant Field Values
  - UCP_NTH_RETURNED_CONNECTION_TO_VALIDATE
```
static final String UCP_NTH_RETURNED_CONNECTION_TO_VALIDATE
```
    See Also:
    
    Constant Field Values
  - UCP_ABANDONED_CONNECTION_TIMEOUT
```
static final String UCP_ABANDONED_CONNECTION_TIMEOUT
```
    See Also:
    
    Constant Field Values
  - UCP_TIME_TO_LIVE_CONNECTION_TIMEOUT
```
static final String UCP_TIME_TO_LIVE_CONNECTION_TIMEOUT
```
    See Also:
    
    Constant Field Values
  - UCP_INACTIVE_CONNECTION_TIMEOUT
```
static final String UCP_INACTIVE_CONNECTION_TIMEOUT
```
    See Also:
    
    Constant Field Values
  - UCP_MAX_IDLE_TIME
```
static final String UCP_MAX_IDLE_TIME
```
    See Also:
    
    Constant Field Values
  - UCP_TIMEOUT_CHECK_INTERVAL
```
static final String UCP_TIMEOUT_CHECK_INTERVAL
```
    See Also:
    
    Constant Field Values
  - UCP_PROPERTY_CYCLE
```
static final String UCP_PROPERTY_CYCLE
```
    See Also:
    
    Constant Field Values
  - UCP_MAX_STATEMENTS
```
static final String UCP_MAX_STATEMENTS
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_WAIT_TIMEOUT
```
static final String UCP_CONNECTION_WAIT_TIMEOUT
```
    See Also:
    
    Constant Field Values
  - UCP_MAX_CONNECTION_REUSE_TIME
```
static final String UCP_MAX_CONNECTION_REUSE_TIME
```
    See Also:
    
    Constant Field Values
  - UCP_MAX_CONNECTION_REUSE_COUNT
```
static final String UCP_MAX_CONNECTION_REUSE_COUNT
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_HARVEST_TRIGGER_COUNT
```
static final String UCP_CONNECTION_HARVEST_TRIGGER_COUNT
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_HARVEST_MAX_COUNT
```
static final String UCP_CONNECTION_HARVEST_MAX_COUNT
```
    See Also:
    
    Constant Field Values
  - UCP_FAST_CONNECTION_FAILOVER_ENABLED
```
static final String UCP_FAST_CONNECTION_FAILOVER_ENABLED
```
    See Also:
    
    Constant Field Values
  - UCP_ONS_CONFIGURATION
```
static final String UCP_ONS_CONFIGURATION
```
    See Also:
    
    Constant Field Values
  - UCP_SECONDS_TO_TRUST_IDLE_CONNECTION
```
static final String UCP_SECONDS_TO_TRUST_IDLE_CONNECTION
```
    See Also:
    
    Constant Field Values
  - UCP_MAX_CONNECTIONS_PER_SERVICE
```
static final String UCP_MAX_CONNECTIONS_PER_SERVICE
```
    See Also:
    
    Constant Field Values
  - UCP_LOGIN_TIMEOUT
```
static final String UCP_LOGIN_TIMEOUT
```
    See Also:
    
    Constant Field Values
  - UCP_SERVICE_NAME
```
static final String UCP_SERVICE_NAME
```
    See Also:
    
    Constant Field Values
  - UCP_PDB_ROLES
```
static final String UCP_PDB_ROLES
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_AFFINITY_CALLBACK
```
static final String UCP_CONNECTION_AFFINITY_CALLBACK
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_INITIALIZATION_CALLBACK
```
static final String UCP_CONNECTION_INITIALIZATION_CALLBACK
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_LABELING_CALLBACK
```
static final String UCP_CONNECTION_LABELING_CALLBACK
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_LABELING_HIGH_COST
```
static final String UCP_CONNECTION_LABELING_HIGH_COST
```
    See Also:
    
    Constant Field Values
  - UCP_CONNECTION_REPURPOSE_THRESHOLD
```
static final String UCP_CONNECTION_REPURPOSE_THRESHOLD
```
    See Also:
    
    Constant Field Values
  - UCP_HIGH_COST_CONNECTION_REUSE_THRESHOLD
```
static final String UCP_HIGH_COST_CONNECTION_REUSE_THRESHOLD
```
    See Also:
    
    Constant Field Values
  - UCP_DATA_SOURCE_FROM_CONFIGURATION
```
static final String UCP_DATA_SOURCE_FROM_CONFIGURATION
```
    See Also:
    
    Constant Field Values
  - UCP_MAX_CONNECTIONS_PER_SHARD
```
static final String UCP_MAX_CONNECTIONS_PER_SHARD
```
    See Also:
    
    Constant Field Values
- Method Detail
  - getInitialPoolSize
```
int getInitialPoolSize()
```
    Gets the initial pool size.
    
    Returns:
    
    the initial pool size.
  - setInitialPoolSize
```
void setInitialPoolSize(int initialPoolSize)
                 throws SQLException
```
    Sets the initial pool size. This is the number of connections that will be created and placed in the pool when the pool is started.
    The range of valid values is 0 to Integer.MAX_VALUE. It is illegal to set this to a value greater than the maximum pool size. Defaults to 0.
    
    Parameters:
    
    initialPoolSize - the initial pool size.
    
    Throws:
    
    SQLException
  - getMinPoolSize
```
int getMinPoolSize()
```
    Gets the minimum number of connections that the connection pool will maintain.
    
    Returns:
    
    The minimum number of connections.
  - setMinPoolSize
```
void setMinPoolSize(int minPoolSize)
             throws SQLException
```
    Sets the minimum number of connections. If the number of available connections + the number of connections in use < the minimum then the connection is returned to the pool. Otherwise, the connection is closed.
    The range of valid values is 0 to Integer.MAX_VALUE. It is illegal to set this to a value greater than the maximum pool size. Defaults to 0.
    
    Parameters:
    
    minPoolSize - The minimum number of connections.
    
    Throws:
    
    SQLException
  - getMaxPoolSize
```
int getMaxPoolSize()
```
    Gets the maximum number of connections that the connection pool will maintain.
    
    Returns:
    
    The maximum number of connections.
  - setMaxPoolSize
```
void setMaxPoolSize(int maxPoolSize)
             throws SQLException
```
    Sets the maximum number of connections. The maximum number of connections includes the number of connections that are in use as well as the number of available connections.
    The range of valid values is 1 to Integer.MAX_VALUE. Defaults to Integer.MAX_VALUE.
    
    Parameters:
    
    maxPoolSize - The maximum number of connections.
    
    Throws:
    
    SQLException
  - getInactiveConnectionTimeout
```
int getInactiveConnectionTimeout()
```
    Gets the inactive connection timeout.
    
    Returns:
    
    The inactivity timeout.
  - setInactiveConnectionTimeout
```
void setInactiveConnectionTimeout(int inactivityTimeout)
                           throws SQLException
```
    Sets the inactive connection timeout. This timeout determines how long an available connection remains in the connection pool before it is removed from the pool.
    The range of valid values is 0 to Integer.MAX_VALUE. Defaults to 0.
    Setting the value to 0 disables inactive connection timeout processing.
    
    Parameters:
    
    inactivityTimeout - The inactive connection timeout in seconds.
    
    Throws:
    
    SQLException
  - getAbandonedConnectionTimeout
```
int getAbandonedConnectionTimeout()
```
    Gets the abandoned connection timeout value.
    
    Returns:
    
    The abandoned connection timeout.
  - setAbandonedConnectionTimeout
```
void setAbandonedConnectionTimeout(int abandonedConnectionTimeout)
                            throws SQLException
```
    Sets the abandoned connection timeout. This timeout determines how long a borrowed connection can remain unused before it is considered as abandoned and reclaimed by the connection pool.
    The range of valid values is 0 to Integer.MAX_VALUE. Defaults to 0.
    Setting the value to 0 disables abandoned connection timeout.
    
    Parameters:
    
    abandonedConnectionTimeout - The value of how long a connection has not been used before it is abandoned (in seconds).
    
    Throws:
    
    SQLException
  - getConnectionWaitTimeout
```
int getConnectionWaitTimeout()
```
    Gets the amount of time to wait (in seconds) for a used connection to be released by a client. This only applies when the maximum number of connections has been borrowed from the connection pool. When a client tries to borrow a connection from the pool and all connections are in use, the connection pool waits for a connection to be released back to the pool.
    
    Returns:
    
    The connection wait timeout.
  - setConnectionWaitTimeout
```
void setConnectionWaitTimeout(int waitTimeout)
                       throws SQLException
```
    Sets the amount of time to wait (in seconds) for a used connection to be released by a client.
    The range of valid values is 0 to Integer.MAX_VALUE. Defaults to 3.
    Setting the value to 0 disables connection wait timeout processing.
    
    Parameters:
    
    waitTimeout - The amount of time to wait.
    
    Throws:
    
    SQLException
  - getTimeToLiveConnectionTimeout
```
int getTimeToLiveConnectionTimeout()
```
    Gets the maximum time (in seconds) a connection may remain in-use. When this timeout expires, the used connection is unconditionally returned to the connection pool. A value of 0 means that the feature is not enabled.
    
    Returns:
    
    The maximum time (in seconds) a used connection may be active.
  - setTimeToLiveConnectionTimeout
```
void setTimeToLiveConnectionTimeout(int timeToLiveConnectionTimeout)
                             throws SQLException
```
    Sets the maximum time (in seconds) a connection may remain in-use.
    The range of valid values is 0 to Integer.MAX_VALUE. Defaults to 0.
    Setting the value to 0 disables time-to-live connection timeout processing.
    
    Parameters:
    
    timeToLiveConnectionTimeout - The maximum time (in seconds) a used connection may be active.
    
    Throws:
    
    SQLException
  - setTimeoutCheckInterval
```
void setTimeoutCheckInterval(int timeInterval)
                      throws SQLException
```
    Sets the timeoutCheckInterval (in seconds). This interval specifies how often the timeout properties such as InactiveConnectionTimeout, AbandonedConnectionTimeout, and TimeToLiveConnectionTimeout are enforced.
    The range of valid values is 0 to Integer.MAX_VALUE. Defaults to 30.
    Setting the value to 0 disables all connection timeout processing.
    
    Parameters:
    
    timeInterval - The timeInterval (in seconds) between checks to enforce the timeout properties.
    
    Throws:
    
    SQLException
  - getTimeoutCheckInterval
```
int getTimeoutCheckInterval()
```
    Gets the timeout check interval (in seconds).
    
    Returns:
    
    timeInterval The timeInterval (in seconds) between checks to enforce the timeout properties.
  - setFastConnectionFailoverEnabled
```
void setFastConnectionFailoverEnabled(boolean failoverEnabled)
                               throws SQLException
```
    Enables Fast Connection Failover (FCF) for the connection pool accessed using this pool-enabled data source. By default, FCF is disabled.
    
    Parameters:
    
    failoverEnabled - true if Fast Connection Failover is enabled; false if not.
    
    Throws:
    
    SQLException
  - getFastConnectionFailoverEnabled
```
boolean getFastConnectionFailoverEnabled()
```
    Checks if Fast Connection Failover is enabled.
    
    Returns:
    
    true if Fast Connection Failover is enabled; false if not.
  - getConnectionFactoryClassName
```
String getConnectionFactoryClassName()
```
    Gets the Connection Factory class name.
    
    Returns:
    
    Name of the connection factory class specified.
  - setConnectionFactoryClassName
```
void setConnectionFactoryClassName(String factoryClassName)
                            throws SQLException
```
    Sets the Connection Factory class name. This is the connection factory used by the connection pool to create physical connections. Must be set for PoolDataSource to operate.
    
    Parameters:
    
    factoryClassName - Connection factory class name for obtaining physical connections.
    
    Throws:
    
    SQLException
  - setMaxStatements
```
void setMaxStatements(int maxStatements)
               throws SQLException
```
    Sets the maximum number of statements that may be pooled or cached on a connection. This is used to enable the statement pooling.
    The range of valid values is 0 to Integer.MAX_VALUE. Defaults to 0.
    
    Parameters:
    
    maxStatements - maximum number of statements to be pooled.
    
    Throws:
    
    SQLException - Exception occurred during the process of setting maximum statements that may be pooled on a connection.
  - getMaxStatements
```
int getMaxStatements()
```
    Gets the maximum number of statements that may be pooled or cached on a Connection.
    
    Returns:
    
    m_maxStatements maximum number of statements that may be pooled or cached on a Connection.
  - setMaxIdleTime
```
void setMaxIdleTime(int idleTime)
             throws SQLException
```
    Sets the maximum idle time for available connections in the pool. This has the same effect as setting the inactive connection timeout.
    The range of valid values is 0 to Integer.MAX_VALUE. Defaults to 0.
    
    Parameters:
    
    idleTime - Maximum idle time in seconds.
    
    Throws:
    
    SQLException
  - getMaxIdleTime
```
int getMaxIdleTime()
```
    Gets the maximum idle time.
    
    Returns:
    
    The maximum idle time.
  - setPropertyCycle
```
void setPropertyCycle(int propertyCycle)
               throws SQLException
```
    Sets the property cycle in seconds. This is the time interval between checks to enforce connection pool timeout properties. This has the same effect as setting timeoutCheckInterval.
    The range of valid values is 0 to Integer.MAX_VALUE. Defaults to 30.
    
    Parameters:
    
    propertyCycle - Time interval in seconds to enforce connection pool timeout properties.
    
    Throws:
    
    SQLException
  - getPropertyCycle
```
int getPropertyCycle()
```
    Gets the property cycle in seconds.
    
    Returns:
    
    The PropertyCycle value.
  - setConnectionPoolName
```
void setConnectionPoolName(String connectionpoolName)
                    throws SQLException
```
    Sets the connection pool name. This property allows the user to specify a String value to name a connection pool instance.
    If not set, the pool name will be automatically generated.
    
    Parameters:
    
    connectionpoolName - Name of the connection pool.
    
    Throws:
    
    SQLException
  - getConnectionPoolName
```
String getConnectionPoolName()
```
    Gets the connection pool name.
    
    Returns:
    
    The connection pool name.
  - setURL
```
void setURL(String url)
     throws SQLException
```
    Sets the URL that the data source uses to obtain connections to the database.
    
    Parameters:
    
    url - URL to be set.
    
    Throws:
    
    SQLException
  - getURL
```
String getURL()
```
    Gets the URL for this data source.
    
    Returns:
    
    URL for this data source.
  - setUser
```
void setUser(String userName)
      throws SQLException
```
    Sets the user name with which connections have to be obtained.
    
    Parameters:
    
    userName - Username to be set.
    
    Throws:
    
    SQLException
  - getUser
```
String getUser()
```
    Gets the user name for this data source.
    
    Returns:
    
    userName for this data source.
  - setPassword
```
void setPassword(String pd)
          throws SQLException
```
    Sets the password with which connections have to be obtained.
    
    Parameters:
    
    pd - Password to be set.
    
    Throws:
    
    SQLException
  - getPassword
```
String getPassword()
```
    Gets the Password for this data source.
    
    Returns:
    
    password for this data source.
  - setServerName
```
void setServerName(String serverName)
            throws SQLException
```
    Sets the database server name.
    
    Parameters:
    
    serverName - Database server name to be set.
    
    Throws:
    
    SQLException
  - getServerName
```
String getServerName()
```
    Gets the database server name.
    
    Returns:
    
    Database server name.
  - setPortNumber
```
void setPortNumber(int portNumber)
            throws SQLException
```
    Sets the database port number.
    
    Parameters:
    
    portNumber - Database port number to be set.
    
    Throws:
    
    SQLException
  - getPortNumber
```
int getPortNumber()
```
    Gets the database port number.
    
    Returns:
    
    Database port number.
  - setDatabaseName
```
void setDatabaseName(String databaseName)
              throws SQLException
```
    Sets the database name.
    
    Parameters:
    
    databaseName - Database name to be set.
    
    Throws:
    
    SQLException
  - getDatabaseName
```
String getDatabaseName()
```
    Gets the database name.
    
    Returns:
    
    Database name.
  - setDataSourceName
```
void setDataSourceName(String dataSourceName)
                throws SQLException
```
    Sets the data source name.
    
    Parameters:
    
    dataSourceName - data source name to be set.
    
    Throws:
    
    SQLException
  - getDataSourceName
```
String getDataSourceName()
```
    Gets the data source name.
    
    Returns:
    
    data source name.
  - setDescription
```
void setDescription(String description)
             throws SQLException
```
    Sets the data source description.
    
    Parameters:
    
    description - data source description to be set.
    
    Throws:
    
    SQLException
  - getDescription
```
String getDescription()
```
    Gets the data source description.
    
    Returns:
    
    data source description.
  - setNetworkProtocol
```
void setNetworkProtocol(String networkProtocol)
                 throws SQLException
```
    Sets the data source network protocol.
    
    Parameters:
    
    networkProtocol - data source network protocol to be set.
    
    Throws:
    
    SQLException
  - getNetworkProtocol
```
String getNetworkProtocol()
```
    Gets the data source network protocol.
    
    Returns:
    
    data source network protocol.
  - setRoleName
```
void setRoleName(String roleName)
          throws SQLException
```
    Sets the data source role name.
    
    Parameters:
    
    roleName - data source role name to be set.
    
    Throws:
    
    SQLException
  - getRoleName
```
String getRoleName()
```
    Gets the data source role name.
    
    Returns:
    
    data source role name.
  - setValidateConnectionOnBorrow
```
void setValidateConnectionOnBorrow(boolean validateConnectionOnBorrow)
                            throws SQLException
```
    Sets whether or not a connection being borrowed should first be validated. Defaults to false.
    
    Parameters:
    
    validateConnectionOnBorrow - Whether or not a connection being borrowed should first be validated.
    
    Throws:
    
    SQLException
  - getValidateConnectionOnBorrow
```
boolean getValidateConnectionOnBorrow()
```
    Returns whether or not a connection being borrowed should first be validated.
    
    Returns:
    
    Whether or not a connection being borrowed should first be validated.
  - setSQLForValidateConnection
```
void setSQLForValidateConnection(String SQLString)
                          throws SQLException
```
    Sets the value of the SQLForValidateConnection property. This is a SQL command used in conjunction with the ValidateConnectionOnBorrow property. The SQL specified should be applicable to the backend database and the JDBC driver configured. Defaults to null.
    
    Parameters:
    
    SQLString - The SQL string used for connection validation.
    
    Throws:
    
    SQLException
  - getSQLForValidateConnection
```
String getSQLForValidateConnection()
```
    Gets the value of the SQLForValidateConnection property.
    
    Returns:
    
    The SQLForValidateConnection property value.
  - getConnectionHarvestTriggerCount
```
int getConnectionHarvestTriggerCount()
```
    Gets the number of available connections below which the connection pool's connection harvesting will occur. For example, if the value is set to 10, then connection harvesting will occur when the number of available connections drops to 10.
    
    Returns:
    
    The number of available connections below which the connection pool's connection harvesting will occur.
  - setConnectionHarvestTriggerCount
```
void setConnectionHarvestTriggerCount(int connectionHarvestTriggerCount)
                               throws SQLException
```
    Sets the number of available connections below which the connection pool's connection harvesting will occur.
    The range of valid values is 0 to maxPoolSize. Defaults to Integer.MAX_VALUE.
    Setting the value to Integer.MAX_VALUE disables connection harvesting.
    
    Parameters:
    
    connectionHarvestTriggerCount - The number of available connections below which the connection pool's connection harvesting will occur.
    
    Throws:
    
    SQLException
  - getConnectionHarvestMaxCount
```
int getConnectionHarvestMaxCount()
```
    Gets the maximum number of connections that may be harvested when the connection harvesting occurs. Note that it is possible that the number of connections that are harvested may be anywhere from 0 to the connectionHarvestMaxCount.
    
    Returns:
    
    The maximum number of connections that may be harvested when the connection harvesting occurs.
  - setConnectionHarvestMaxCount
```
void setConnectionHarvestMaxCount(int connectionHarvestMaxCount)
                           throws SQLException
```
    Sets the maximum number of connections that may be harvested when the connection harvesting occurs.
    The range of valid values is 1 to maxPoolSize. Defaults to 1.
    
    Parameters:
    
    connectionHarvestMaxCount - the maximum number of connections that may be harvested when the connection harvesting occurs.
    
    Throws:
    
    SQLException
  - getAvailableConnectionsCount
```
int getAvailableConnectionsCount()
                          throws SQLException
```
    Gets the number of available connections in the pool.
    
    Returns:
    
    AvailableConnectionsCount
    
    Throws:
    
    SQLException
  - getBorrowedConnectionsCount
```
int getBorrowedConnectionsCount()
                         throws SQLException
```
    Gets the number of borrowed connections from the pool.
    
    Returns:
    
    BorrowedConnectionsCount
    
    Throws:
    
    SQLException
  - getONSConfiguration
```
String getONSConfiguration()
                    throws SQLException
```
    Returns the ONS configuration string that is used for remote ONS subscription in the form specified in setONSConfiguration(String). This is used by Fast Connection Failover and Runtime Connection Load Balancing.
    
    Returns:
    
    The ONS configuration string used for remote ONS subscription.
    
    Throws:
    
    SQLException
  - setONSConfiguration
```
void setONSConfiguration(String onsConfigStr)
                  throws SQLException
```
    Sets the configuration string used for remote ONS subscription. The parameter string closely resembles the content of the ONS configuration file (ons.config). The string contains a list of name=value pairs separated by a newline character (\n). The name can be one of nodes, walletfile, or walletpassword.
    The parameter string should at least specify the ONS configuration nodes attribute as a list of host:port pairs separated by a comma. SSL would be used when the walletfile attribute is specified as an Oracle wallet file.
    
    An example ONS configuration string:
```
   "nodes=host1:4200,host2:4200\nwalletfile=wfile\nwalletpassword=wpwd"
 
```
    This is used primarily by Fast Connection Failover and Runtime Load Balancing.
    Parameters:
    
    onsConfigStr - The configuration string for remote ONS subscription.
    
    Throws:
    
    SQLException
  - getConnection
```
Connection getConnection(Properties labels)
                  throws SQLException
```
    Attempts to obtain a database connection with the requested connection labels.
    
    Parameters:
    
    labels - The requested connection labels.
    
    Returns:
    
    A Connection to the database.
    
    Throws:
    
    SQLException - if a database-access error occurs.
  - getConnection
```
Connection getConnection(String username,
                         String password,
                         Properties labels)
                  throws SQLException
```
    Attempts to obtain a database connection with the requested connection labels.
    
    Parameters:
    
    username - The database user on whose behalf the connection is being made.
    
    password - The user's password.
    
    labels - The requested connection labels.
    
    Returns:
    
    A Connection to the database.
    
    Throws:
    
    SQLException - if a database-access error occurs.
  - registerConnectionLabelingCallback
```
void registerConnectionLabelingCallback(ConnectionLabelingCallback cbk)
                                 throws SQLException
```
    Registers a connection labeling callback with the underlying connection pool.
    
    Parameters:
    
    cbk - The ConnectionLabelingCallback object to be registered.
    
    Throws:
    
    SQLException - If there is a callback already registered with the pool.
  - removeConnectionLabelingCallback
```
void removeConnectionLabelingCallback()
                               throws SQLException
```
    Removes the ConnectionLabelingCallback object registered with the underlying connection pool, if any.
    
    Throws:
    
    SQLException - If callback removal fails.
  - registerConnectionAffinityCallback
```
void registerConnectionAffinityCallback(ConnectionAffinityCallback cbk)
                                 throws SQLException
```
    Registers a connection affinity callback on the connection pool.
    
    Parameters:
    
    cbk - Affinity Callback object that must be registered.
    
    Throws:
    
    SQLException - If callback registration fails.
  - removeConnectionAffinityCallback
```
void removeConnectionAffinityCallback()
                               throws SQLException
```
    Removes the ConnectionAffinityCallback object registered on the connection pool.
    
    Throws:
    
    SQLException - If callback removal fails.
  - getConnectionProperties
```
Properties getConnectionProperties()
```
    Gets the connection properties that are set on this data source.
    
    Returns:
    
    Connection properties.
  - getConnectionProperty
```
String getConnectionProperty(String propertyName)
```
    Gets the specified connection property that are set on this data source.
    
    Parameters:
    
    propertyName - The name of the specified property.
    
    Returns:
    
    The value of the inquired connection property. Null if the property is not set.
  - setConnectionProperty
```
void setConnectionProperty(String name,
                           String value)
                    throws SQLException
```
    Sets a connection property on the connection factory. This is used only for DataSource connection factories that also support connection properties; for example, the oracle.jdbc.pool.OracleDataSource in the Oracle JDBC driver.
    
    Parameters:
    
    name - The name of the connection property to be set on the connection factory class.
    
    value - The value of the connection property to be set on the connection factory class.
    
    Throws:
    
    SQLException - If any exception occurred while setting the connection property.
    
    See Also:
    
    setConnectionFactoryProperties
  - setConnectionProperties
```
void setConnectionProperties(Properties connectionProperties)
                      throws SQLException
```
    Sets the connection properties on the connection factory. This is used only for DataSource connection factories that also support connection properties; for example, the oracle.jdbc.pool.OracleDataSource in the Oracle JDBC driver.
    
    Parameters:
    
    connectionProperties - Connection properties to be set on the connection factory class.
    
    Throws:
    
    SQLException - If any exception occurred while setting the connection properties.
    
    See Also:
    
    setConnectionFactoryProperties
  - getConnectionFactoryProperties
```
Properties getConnectionFactoryProperties()
```
    Gets the connection factory properties that are set on this data source.
    
    Returns:
    
    Connection factory properties.
  - getConnectionFactoryProperty
```
String getConnectionFactoryProperty(String propertyName)
```
    Gets the specified connection factory property that are set on this data source.
    
    Parameters:
    
    propertyName - The name of the specified property.
    
    Returns:
    
    The value of the inquired connection factory property. Null if the property is not set.
  - setConnectionFactoryProperty
```
void setConnectionFactoryProperty(String name,
                                  String value)
                           throws SQLException
```
    Sets a connection factory property on the connection factory.
    For connection factories that implement java.sql.Driver, the connection factory property specified here will be assumed as a connection property.
    For DataSource connection factories, the property specified here will be assumed as a DataSource property.
    
    Parameters:
    
    name - The name of the connection factory property to be set on the connection factory class.
    
    value - The value of the connection factory property to be set on the connection factory class.
    
    Throws:
    
    SQLException - If any exception occurred while setting the connection factory property.
    
    IllegalArgumentException - If the property name or value is invalid.
  - setConnectionFactoryProperties
```
void setConnectionFactoryProperties(Properties factoryProperties)
                             throws SQLException
```
    Sets the connection factory properties on the connection factory.
    For connection factories that implement java.sql.Driver, the connection factory properties specified here will be assumed as the connection properties.
    For DataSource connection factories, the properties specified here will be assumed as the DataSource properties.
    
    Parameters:
    
    factoryProperties - Connection factory properties to be set on the connection factory class.
    
    Throws:
    
    SQLException - If any exception occurred while setting the connection factory properties.
    
    IllegalArgumentException - If factoryProperties is empty.
  - getMaxConnectionReuseTime
```
long getMaxConnectionReuseTime()
```
    Gets the maximum connection reuse time property value. See property description in setMaxConnectionReuseTime().
    
    Returns:
    
    Maximum connection reuse time (in seconds).
  - setMaxConnectionReuseTime
```
void setMaxConnectionReuseTime(long maxConnectionReuseTime)
                        throws SQLException
```
    Sets the maximum connection reuse time property. This property specifies the maximum time any connection can potentially be reused after which the pool removes and closes a connection. The value is specified in seconds and must be greater than 0. For example, if the specified value is 3600 seconds, then when a connection is in existence for more than 3600 seconds, the connection is closed and removed from the pool. Connections are closed gracefully after they are returned to the pool and the specified property value has been exceeded. Default is 0, which means this feature is not enabled.
    
    Parameters:
    
    maxConnectionReuseTime - Maximum connection reuse time (in seconds).
    
    Throws:
    
    SQLException
  - getMaxConnectionReuseCount
```
int getMaxConnectionReuseCount()
```
    Gets the maximum connection reuse count property value. See property description in setMaxConnectionReuseCount().
    
    Returns:
    
    Maximum connection reuse count.
  - setMaxConnectionReuseCount
```
void setMaxConnectionReuseCount(int maxConnectionReuseCount)
                         throws SQLException
```
    Sets the maximum connection reuse count property. This property specifies the maximum number of times any connection can be reused after which the pool removes and closes a connection. The value must be greater than 0 for this feature to be enabled. For example, if the specified value is 100, then when a connection is reused or borrowed 100 times from the pool, it is closed and removed from the pool. Connections are closed gracefully after they are returned to the pool and the property value has been exceeded. Default is 0, which means this feature is not enabled.
    
    Parameters:
    
    maxConnectionReuseCount - Maximum connection reuse count.
    
    Throws:
    
    SQLException
  - getStatistics
```
JDBCConnectionPoolStatistics getStatistics()
```
    Gets the statistics of the connection pool.
    
    Returns:
    
    The statistics of the connection pool.
  - registerConnectionInitializationCallback
```
void registerConnectionInitializationCallback(ConnectionInitializationCallback cbk)
                                       throws SQLException
```
    Registers a connection initialization callback.
    
    Parameters:
    
    cbk - The ConnectionInitializationCallback object to be registered.
    
    Throws:
    
    SQLException - If there is a callback already registered with the pool.
  - unregisterConnectionInitializationCallback
```
void unregisterConnectionInitializationCallback()
                                         throws SQLException
```
    Unregisters the connection initialization callback on this pool.
    
    Throws:
    
    SQLException - If callback removal fails.
  - getConnectionInitializationCallback
```
ConnectionInitializationCallback getConnectionInitializationCallback()
```
    Obtains the registered connection initialization callback, if any.
    
    Returns:
    
    The registered ConnectionInitializationCallback, or null if there is no callback registered.
  - getConnectionLabelingHighCost
```
int getConnectionLabelingHighCost()
```
    Obtains the cost value which identifies a connection as "high-cost" for connection labeling.
    
    Returns:
    
    The cost value that identifies a connection as "high-cost" for connection labeling.
    
    See Also:
    
    setConnectionLabelingHighCost
  - setConnectionLabelingHighCost
```
void setConnectionLabelingHighCost(int highCost)
                            throws SQLException
```
    Sets the cost value which identifies a connection as "high-cost" for connection labeling. Connection labeling uses the cost(Properties, Properties) method in ConnectionLabelingCallback to find a connection in the pool for a request. When this property is set, connections with a cost value equal to or greater than the property value are considered "high-cost" connections. The default value is Integer.MAX_VALUE.
    
    Parameters:
    
    highCost - The cost value that identifies a connection as "high-cost" for connection labeling.
    
    Throws:
    
    SQLException - If an exception occurs while setting the cost.
  - getHighCostConnectionReuseThreshold
```
int getHighCostConnectionReuseThreshold()
```
    Obtains the high-cost connection reuse threshold property value for connection labeling.
    
    Returns:
    
    The high-cost connection reuse threshold property value currently set.
    
    See Also:
    
    setConnectionLabelingHighCost, setHighCostConnectionReuseThreshold
  - setHighCostConnectionReuseThreshold
```
void setHighCostConnectionReuseThreshold(int threshold)
                                  throws SQLException
```
    Sets the high-cost connection reuse threshold for connection labeling. This property works together with the ConnectionLabelingHighCost property to determine when high-cost connections are reused for connection labeling. This property specifies a threshold of the number of total connections in the pool. If Connection Labeling finds all available connections are high-cost connections (i.e., the lowest cost value exceeds the ConnectionLabelingHighCost value), it checks this threshold to determine whether to reuse those connections. Only when this threshold is reached, Connection Labeling will try to reuse the high-cost connections in the pool to serve a labeled connection request. Otherwise, Connection Labeling picks a low-cost connection, a no-label connection available in the pool, or creates a brand-new physical connection to serve a labeled request. For example, if the property value is set to 10, Connection Labeling reuses high-cost connections when there are no low-cost connections available and the total connections reach 10. Note that any labeled connection with cost Integer.MAX_VALUE will not be reused. This is consistent with connection labeling behavior when this property and ConnectionLabelingHighCost are not set. A Connection Labeling callback must be registered at the same time for this property to take effect. The default value is 0, which is treated the same way as MinPoolSize.
    
    Parameters:
    
    threshold - The high-cost connection reuse threshold to set.
    
    Throws:
    
    SQLException - If any exception occurs while setting the threshold.
  - createConnectionBuilder
```
UCPConnectionBuilder createConnectionBuilder()
```
    Creates a new UCPConnectionBuilder instance.
    
    Type Parameters:
    
    S - Connection type for this ConnectionBuilder
    
    B - Builder type to use
    
    Returns:
    
    The OracleConnectionBuilder instance that was created
  - createShardingKeyBuilder
```
default OracleShardingKeyBuilder createShardingKeyBuilder()
```
    Creates a new OracleShardingKeyBuilder instance
    
    Returns:
    
    The OracleShardingKeyBuilder instance that was created
  - getConnectionRepurposeThreshold
```
int getConnectionRepurposeThreshold()
```
    Gets the connection repurpose threshold for the pool. This property is used in cases when the connection pool is shared by multiple datasources connecting to the same database but using different services.Only when this threshold is reached the pool will try to repurpose connections between different services before trying to create new connections. This property is applicable only for multi-tenant databases.
    
    Returns:
    
    connection repurpose threshold property value currently set.
  - setConnectionRepurposeThreshold
```
void setConnectionRepurposeThreshold(int threshold)
                              throws SQLException
```
    Sets the connection repurpose threshold for the pool. This property is applicable only for multi-tenant databases.
    
    Parameters:
    
    threshold - connection repurpose threshold to set.
    
    Throws:
    
    SQLException - If any exception occurs while setting the threshold.
    
    See Also:
    
    getConnectionRepurposeThreshold
  - getPdbRoles
```
Properties getPdbRoles()
```
    Gets the PDB roles specified for this datasource
    
    Returns:
    
    roles key values pairs that correspond to the role names and password that are set for this datasource
    
    See Also:
    
    setPdbRoles
  - getServiceName
```
String getServiceName()
```
    Gets the service name set on this data source
    
    Returns:
    
    service name on this data source
  - getSecondsToTrustIdleConnection
```
int getSecondsToTrustIdleConnection()
```
    Gets the seconds To Trust Idle Connection value.
    
    Returns:
    
    The seconds To Trust Idle Connection.
  - setSecondsToTrustIdleConnection
```
void setSecondsToTrustIdleConnection(int secondsToTrustIdleConnection)
                              throws SQLException
```
    Sets the time in seconds to trust an idle connection to skip a validation test. It works in conjunction with setValidateConnectionOnBorrow(boolean). When set to any positive value, a connection validation during the checkout is skipped if the connection was successfully used and returned to the pool within the time specified for secondsToTrustIdleConnection. Default value is set to 0 seconds which means that the feature is disabled.
    
    Parameters:
    
    secondsToTrustIdleConnection - The value of how long a connection can be trusted to skip connectionValidationOnBorrow
    
    Throws:
    
    SQLException
  - reconfigureDataSource
```
void reconfigureDataSource(Properties configuration)
                    throws SQLException
```
    Reconfigures the data source. This API can be only used to modify existing data source properties. To add a new data source to a running pool instance, use PoolDataSourceFactory's getPoolDataSource(Properties configuration) API instead. Only the following data source properties can be modified using this API: user, password, description, serviceName, pdbRoles.
    
    Parameters:
    
    configuration - the configuration input
    
    Throws:
    
    SQLException - If an error occurs while configuring the data source.
  - getMaxConnectionsPerService
```
int getMaxConnectionsPerService()
```
    Gets the maximum number of connections that can be obtained to a particular service, in a shared pool.
    
    Returns:
    
    The maximum number of connections that can be obtained to a particular service.
  - getQueryTimeout
```
int getQueryTimeout()
```
    Gets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.
    
    Returns:
    
    The query timeout in seconds
  - setQueryTimeout
```
void setQueryTimeout(int queryTimeout)
              throws SQLException
```
    Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.
    
    Parameters:
    
    queryTimeout - in seconds
    
    Throws:
    
    SQLException
  - getMaxConnectionsPerShard
```
int getMaxConnectionsPerShard()
```
    Gets the currently configured max connections that can be created per shard from this connection pool.
    
    Returns:
    
    The configured max number of connections that can be created per shard.
  - setMaxConnectionsPerShard
```
void setMaxConnectionsPerShard(int maxConnectionsPerShard)
                        throws SQLException
```
    Sets the max number of connections that can be created per shard from this connection pool. (Note: This property is applicable to Sharded databases only. It should not be used when the Sharded database is configured with Oracle Golden Gate)
    
    Parameters:
    
    maxConnectionsPerShard - The max number of connections that can be created per shard
    
    Throws:
    
    SQLException - if there is an any exception while setting this parameter

Interface PoolDataSource

Field Summary

Method Summary

Methods inherited from interface javax.sql.DataSource

Methods inherited from interface javax.sql.CommonDataSource

Methods inherited from interface java.sql.Wrapper

Field Detail

UCP_USER

UCP_URL

UCP_PASSWORD

UCP_SERVER_NAME

UCP_PORT_NUMBER

UCP_DATABASE_NAME

UCP_DATA_SOURCE_NAME

UCP_DESCRIPTION

UCP_NETWORK_PROTOCOL

UCP_ROLE_NAME

UCP_CONNECTION_FACTORY_CLASS_NAME

UCP_CONNECTION_PROPERTIES

UCP_CONNECTION_FACTORY_PROPERTIES

UCP_VALIDATE_CONNECTION_ON_BORROW

UCP_SQL_FOR_VALIDATE_CONNECTION

UCP_CONNECTION_POOL_NAME

UCP_INITIAL_POOL_SIZE

UCP_MIN_POOL_SIZE

UCP_MAX_POOL_SIZE

UCP_NTH_RETURNED_CONNECTION_TO_VALIDATE

UCP_ABANDONED_CONNECTION_TIMEOUT

UCP_TIME_TO_LIVE_CONNECTION_TIMEOUT

UCP_INACTIVE_CONNECTION_TIMEOUT

UCP_MAX_IDLE_TIME

UCP_TIMEOUT_CHECK_INTERVAL

UCP_PROPERTY_CYCLE

UCP_MAX_STATEMENTS

UCP_CONNECTION_WAIT_TIMEOUT

UCP_MAX_CONNECTION_REUSE_TIME

UCP_MAX_CONNECTION_REUSE_COUNT

UCP_CONNECTION_HARVEST_TRIGGER_COUNT

UCP_CONNECTION_HARVEST_MAX_COUNT

UCP_FAST_CONNECTION_FAILOVER_ENABLED

UCP_ONS_CONFIGURATION

UCP_SECONDS_TO_TRUST_IDLE_CONNECTION

UCP_MAX_CONNECTIONS_PER_SERVICE

UCP_LOGIN_TIMEOUT

UCP_SERVICE_NAME

UCP_PDB_ROLES

UCP_CONNECTION_AFFINITY_CALLBACK

UCP_CONNECTION_INITIALIZATION_CALLBACK

UCP_CONNECTION_LABELING_CALLBACK

UCP_CONNECTION_LABELING_HIGH_COST

UCP_CONNECTION_REPURPOSE_THRESHOLD

UCP_HIGH_COST_CONNECTION_REUSE_THRESHOLD

UCP_DATA_SOURCE_FROM_CONFIGURATION

UCP_MAX_CONNECTIONS_PER_SHARD

Method Detail

getInitialPoolSize

setInitialPoolSize

getMinPoolSize

setMinPoolSize

getMaxPoolSize

setMaxPoolSize

getInactiveConnectionTimeout

setInactiveConnectionTimeout

getAbandonedConnectionTimeout

setAbandonedConnectionTimeout

getConnectionWaitTimeout

setConnectionWaitTimeout

getTimeToLiveConnectionTimeout

setTimeToLiveConnectionTimeout

setTimeoutCheckInterval

getTimeoutCheckInterval

setFastConnectionFailoverEnabled

getFastConnectionFailoverEnabled

getConnectionFactoryClassName

setConnectionFactoryClassName

setMaxStatements

getMaxStatements

setMaxIdleTime

getMaxIdleTime

setPropertyCycle