PoolDataSourceImpl (Oracle Database JDBC and UCP Java API Reference)

java.lang.Object
- oracle.ucp.jdbc.PoolDataSourceImpl

All Implemented Interfaces:

Serializable, Wrapper, Referenceable, ObjectFactory, CommonDataSource, DataSource, PoolDataSource, UniversalConnectionPoolAdapter

Direct Known Subclasses:

PoolXADataSourceImpl
```
public class PoolDataSourceImpl
extends Object
implements PoolDataSource, Serializable, Referenceable, ObjectFactory, UniversalConnectionPoolAdapter
```
A connection pool-aware data source. This DataSource uses the Universal Connection Pool to get a connection, creating a proxy to that connection, and returning the proxy to the client. When the client calls close on the connection proxy, the underlying physical connection is returned to the pool.
Besides other data source properties, applications must set the connection factory class name. The connection factory class is a class that implements javax.sql.DataSource and does not implement its own connection pooling. The connection factory's getConnection(...) methods should return a physical JDBC connection to the database. For example, "oracle.jdbc.pool.OracleDataSource" is a valid connection factory class name.

See Also:

Serialized Form

Field Summary

Fields
Modifier and Type	Field and Description
`protected Object`	`m_connectionFactory`
`protected String`	`m_connectionFactoryClassName`
`protected JDBCConnectionPool`	`m_cp`
`static String`	`SECRET_STORE_CONNECT`
`static String`	`SECRET_STORE_DEFAULT_PASSWORD`
`static String`	`SECRET_STORE_DEFAULT_USERNAME`
`static String`	`SECRET_STORE_PASSWORD`
`static String`	`SECRET_STORE_USERNAME`

Fields inherited from interface oracle.ucp.jdbc.PoolDataSource
UCP_ABANDONED_CONNECTION_TIMEOUT, UCP_CONNECTION_AFFINITY_CALLBACK, UCP_CONNECTION_FACTORY_CLASS_NAME, UCP_CONNECTION_FACTORY_PROPERTIES, UCP_CONNECTION_HARVEST_MAX_COUNT, UCP_CONNECTION_HARVEST_TRIGGER_COUNT, UCP_CONNECTION_INITIALIZATION_CALLBACK, UCP_CONNECTION_LABELING_CALLBACK, UCP_CONNECTION_LABELING_HIGH_COST, UCP_CONNECTION_POOL_NAME, UCP_CONNECTION_PROPERTIES, UCP_CONNECTION_REPURPOSE_THRESHOLD, UCP_CONNECTION_WAIT_TIMEOUT, UCP_DATA_SOURCE_FROM_CONFIGURATION, UCP_DATA_SOURCE_NAME, UCP_DATABASE_NAME, UCP_DESCRIPTION, UCP_FAST_CONNECTION_FAILOVER_ENABLED, UCP_HIGH_COST_CONNECTION_REUSE_THRESHOLD, UCP_INACTIVE_CONNECTION_TIMEOUT, UCP_INITIAL_POOL_SIZE, UCP_LOGIN_TIMEOUT, UCP_MAX_CONNECTION_REUSE_COUNT, UCP_MAX_CONNECTION_REUSE_TIME, UCP_MAX_CONNECTIONS_PER_SERVICE, UCP_MAX_CONNECTIONS_PER_SHARD, UCP_MAX_IDLE_TIME, UCP_MAX_POOL_SIZE, UCP_MAX_STATEMENTS, UCP_MIN_POOL_SIZE, UCP_NETWORK_PROTOCOL, UCP_NTH_RETURNED_CONNECTION_TO_VALIDATE, UCP_ONS_CONFIGURATION, UCP_PASSWORD, UCP_PDB_ROLES, UCP_PORT_NUMBER, UCP_PROPERTY_CYCLE, UCP_ROLE_NAME, UCP_SECONDS_TO_TRUST_IDLE_CONNECTION, UCP_SERVER_NAME, UCP_SERVICE_NAME, UCP_SQL_FOR_VALIDATE_CONNECTION, UCP_TIME_TO_LIVE_CONNECTION_TIMEOUT, UCP_TIMEOUT_CHECK_INTERVAL, UCP_URL, UCP_USER, UCP_VALIDATE_CONNECTION_ON_BORROW

Constructor Summary

Constructors
Constructor and Description

PoolDataSourceImpl()

Constructors
Constructor and Description
`PoolDataSourceImpl()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`UCPConnectionBuilder`	`createConnectionBuilder()` Creates a new UCPConnectionBuilder instance.
`protected void`	`createPoolWithDefaultProperties()`
`UniversalConnectionPool`	`createUniversalConnectionPool()` Creates a Universal Connection Pool instance using this adapter.
`UniversalConnectionPoolMBean`	`createUniversalConnectionPoolMBean()` Creates a Universal Connection Pool MBean using this adapter.
`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()` Attempts to obtain a database connection.
`Connection`	`getConnection(Properties labels)` Attempts to obtain a database connection with the requested connection labels.
`Connection`	`getConnection(String username, String password)` Attempts to obtain a database connection.
`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 at 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`	`getLoginTimeout()` Gets the default maximum time in seconds that a driver will wait while attempting to connect to a database once the driver has been identified.
`PrintWriter`	`getLogWriter()`
`int`	`getMaxConnectionReuseCount()` Gets the connection reuse count property.
`long`	`getMaxConnectionReuseTime()` Gets the connection reuse time property.
`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 in a sharded database configuration.
`int`	`getMaxIdleTime()` Gets Idle timeout value.
`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 datasource networkProtocol.
`Object`	`getObjectInstance(Object refObj, Name name, Context nameCtx, Hashtable env)`
`String`	`getONSConfiguration()` Returns the ONS configuration string that is used for remote ONS subscription, in the form specified in setONSConfiguration(String).
`Logger`	`getParentLogger()`
`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 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.
`Reference`	`getReference()`
`String`	`getRoleName()` Gets the datasource 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 for 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.
`protected void`	`ilogFine(Logger logger, Class cls, Executable method, Object receiver, String message)`
`protected void`	`ilogFinest(Logger logger, Class cls, Executable method, Object receiver, String message)` Helpers for writing into log and logWriter
`protected void`	`ilogSevere(Logger logger, Class cls, Executable method, Object receiver, String message)`
`protected void`	`ilogThrowing(Logger logger, Class cls, Executable method, Object receiver, Throwable throwable)`
`protected void`	`ilogWarning(Logger logger, Class cls, Executable method, Object receiver, String message)`
`boolean`	`isWrapperFor(Class<?> iface)` Since this class is not a wrapper, just check to see if this implements the requested interface.
`void`	`reconfigureDataSource(Properties configuration)` Reconfigures the data source.
`void`	`registerConnectionAffinityCallback(ConnectionAffinityCallback cbk)` Registers a ConnectionAffinityCallback on the connection pool.
`void`	`registerConnectionInitializationCallback(ConnectionInitializationCallback cbk)` Registers a connection initialization callback.
`void`	`registerConnectionLabelingCallback(ConnectionLabelingCallback cbk)` Registers a ConnectionLabelingCallback with the underlying connection pool.
`void`	`removeConnectionAffinityCallback()` Removes the ConnectionAffinityCallback 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 at 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`	`setLoginTimeout(int seconds)` Sets the default maximum time in seconds that a driver will wait while attempting to connect to a database once the driver has been identified.
`void`	`setLogWriter(PrintWriter logWriter)`
`void`	`setMaxConnectionReuseCount(int maxConnectionReuseCount)` Gets the connection reuse count property.
`void`	`setMaxConnectionReuseTime(long maxConnectionReuseTime)` Gets the connection reuse time property.
`void`	`setMaxConnectionsPerShard(int maxConnectionsPerShard)` Sets the max number of connections that can be created per shard in a sharded database configuration.
`void`	`setMaxIdleTime(int idleTime)` Sets Idle timeout 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 datasource networkProtocol.
`void`	`setONSConfiguration(String onsConfigStr)` Sets the configuration string used for remote ONS subscription.
`void`	`setPassword(String password)` Sets the password with which connections have to be obtained.
`void`	`setPortNumber(int portNumber)` Sets the database port number.
`void`	`setPropertyCycle(int propertyCycle)` Sets 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 datasource 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(SQL) for 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 user)` 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`	`startPool()` This helper method gets all the pool properties for pool initialization, creates a pool and starts it.
`static Object`	`toBasicType(String value, String type)`
`void`	`unregisterConnectionInitializationCallback()` Unregisters the connection initialization callback on this pool.
`<T> T`	`unwrap(Class<T> iface)` Since this class is not a wrapper, just check to see if this implements the requested interface.

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.PoolDataSource
createShardingKeyBuilder

- Field Detail
  - SECRET_STORE_CONNECT
```
public static final String SECRET_STORE_CONNECT
```
    See Also:
    
    Constant Field Values
  - SECRET_STORE_USERNAME
```
public static final String SECRET_STORE_USERNAME
```
    See Also:
    
    Constant Field Values
  - SECRET_STORE_PASSWORD
```
public static final String SECRET_STORE_PASSWORD
```
    See Also:
    
    Constant Field Values
  - SECRET_STORE_DEFAULT_USERNAME
```
public static final String SECRET_STORE_DEFAULT_USERNAME
```
    See Also:
    
    Constant Field Values
  - SECRET_STORE_DEFAULT_PASSWORD
```
public static final String SECRET_STORE_DEFAULT_PASSWORD
```
    See Also:
    
    Constant Field Values
  - m_connectionFactoryClassName
```
protected String m_connectionFactoryClassName
```
  - m_connectionFactory
```
protected Object m_connectionFactory
```
  - m_cp
```
protected transient JDBCConnectionPool m_cp
```
- Constructor Detail
  - PoolDataSourceImpl
```
public PoolDataSourceImpl()
```
- Method Detail
  - startPool
```
public void startPool()
               throws SQLException
```
    This helper method gets all the pool properties for pool initialization, creates a pool and starts it.
    
    Throws:
    
    SQLException - if a database-access error occurs.
  - createPoolWithDefaultProperties
```
protected void createPoolWithDefaultProperties()
                                        throws SQLException
```
    Throws:
    
    SQLException
  - createUniversalConnectionPool
```
public UniversalConnectionPool createUniversalConnectionPool()
                                                      throws SQLException
```
    Creates a Universal Connection Pool instance using this adapter. Pool and connection factory configuration properties should be set on this adapter prior to invoking this method.
    This method should not register the created pool instance with the Universal Connection Pool Manager. The method createConnectionPool on the UniversalConnectionPoolManager is responsible for that.
    This method is intended to be used in association with a UniversalConnectionPoolManager or MBean. Do not directly invoke this method from an instance of this class.
    
    Specified by:
    
    createUniversalConnectionPool in interface UniversalConnectionPoolAdapter
    
    Returns:
    
    The created Universal Connection Pool instance.
    
    Throws:
    
    SQLException - If any error occurs during the process of connection pool creation.
    
    See Also:
    
    UniversalConnectionPoolManager
  - reconfigureDataSource
```
public 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.
    
    Specified by:
    
    reconfigureDataSource in interface PoolDataSource
    
    Parameters:
    
    configuration - the configuration input
    
    Throws:
    
    SQLException - If an error occurs while configuring the data source.
  - createUniversalConnectionPoolMBean
```
public UniversalConnectionPoolMBean createUniversalConnectionPoolMBean()
                                                                throws SQLException
```
    Creates a Universal Connection Pool MBean using this adapter. If a Universal Connection Pool instance is not yet created, this method must first create a pool instance, in which case pool and connection factory configuration properties should be set on this adapter prior to invoking this method.
    This method should not register the created pool MBean with the MBean server. The operation createConnectionPool on the UniversalConnectionPoolManagerMBean is responsible for that.
    
    Specified by:
    
    createUniversalConnectionPoolMBean in interface UniversalConnectionPoolAdapter
    
    Returns:
    
    The created Universal Connection Pool MBean.
    
    Throws:
    
    SQLException - If any error occurs during the process of connection pool creation.
    
    See Also:
    
    UniversalConnectionPoolManagerMBean
  - getConnection
```
public Connection getConnection()
                         throws SQLException
```
    Attempts to obtain a database connection.
    
    Specified by:
    
    getConnection in interface DataSource
    
    Returns:
    
    A Connection to the database.
    
    Throws:
    
    SQLException - if a database-access error occurs.
  - getConnection
```
public Connection getConnection(String username,
                                String password)
                         throws SQLException
```
    Attempts to obtain a database connection.
    
    Specified by:
    
    getConnection in interface DataSource
    
    Parameters:
    
    username - The database user on whose behalf the connection is being made.
    
    password - The user's password.
    
    Returns:
    
    A Connection to the database.
    
    Throws:
    
    SQLException - if a database-access error occurs.
  - getConnection
```
public Connection getConnection(Properties labels)
                         throws SQLException
```
    Attempts to obtain a database connection with the requested connection labels.
    
    Specified by:
    
    getConnection in interface PoolDataSource
    
    Parameters:
    
    labels - The requested connection labels.
    
    Returns:
    
    A Connection to the database.
    
    Throws:
    
    SQLException - if a database-access error occurs.
  - getConnection
```
public Connection getConnection(String username,
                                String password,
                                Properties labels)
                         throws SQLException
```
    Attempts to obtain a database connection with the requested connection labels.
    
    Specified by:
    
    getConnection in interface PoolDataSource
    
    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.
  - getLogWriter
```
public PrintWriter getLogWriter()
                         throws SQLException
```
    Specified by:
    
    getLogWriter in interface CommonDataSource
    
    Throws:
    
    SQLException
  - setLogWriter
```
public void setLogWriter(PrintWriter logWriter)
                  throws SQLException
```
    Specified by:
    
    setLogWriter in interface CommonDataSource
    
    Throws:
    
    SQLException
  - setLoginTimeout
```
public void setLoginTimeout(int seconds)
                     throws SQLException
```
    Sets the default maximum time in seconds that a driver will wait while attempting to connect to a database once the driver has been identified.
    
    Specified by:
    
    setLoginTimeout in interface CommonDataSource
    
    Parameters:
    
    seconds - timeout
    
    Throws:
    
    SQLException - in case of negative value
  - getLoginTimeout
```
public int getLoginTimeout()
```
    Gets the default maximum time in seconds that a driver will wait while attempting to connect to a database once the driver has been identified.
    
    Specified by:
    
    getLoginTimeout in interface CommonDataSource
    
    Returns:
    
    timeout in seconds
  - getUser
```
public String getUser()
```
    Description copied from interface: PoolDataSource
    
    Gets the user name for this data source.
    
    Specified by:
    
    getUser in interface PoolDataSource
    
    Returns:
    
    userName for this data source.
  - setUser
```
public void setUser(String user)
             throws SQLException
```
    Description copied from interface: PoolDataSource
    
    Sets the user name with which connections have to be obtained.
    
    Specified by:
    
    setUser in interface PoolDataSource
    
    Parameters:
    
    user - Username to be set.
    
    Throws:
    
    SQLException
  - getPassword
```
public String getPassword()
```
    Description copied from interface: PoolDataSource
    
    Gets the Password for this data source.
    
    Specified by:
    
    getPassword in interface PoolDataSource
    
    Returns:
    
    password for this data source.
  - setPassword
```
public void setPassword(String password)
                 throws SQLException
```
    Description copied from interface: PoolDataSource
    
    Sets the password with which connections have to be obtained.
    
    Specified by:
    
    setPassword in interface PoolDataSource
    
    Parameters:
    
    password - Password to be set.
    
    Throws:
    
    SQLException
  - getURL
```
public String getURL()
```
    Description copied from interface: PoolDataSource
    
    Gets the URL for this data source.
    
    Specified by:
    
    getURL in interface PoolDataSource
    
    Returns:
    
    URL for this data source.
  - setURL
```
public void setURL(String url)
            throws SQLException
```
    Description copied from interface: PoolDataSource
    
    Sets the URL that the data source uses to obtain connections to the database.
    
    Specified by:
    
    setURL in interface PoolDataSource
    
    Parameters:
    
    url - URL to be set.
    
    Throws:
    
    SQLException
  - setServerName
```
public void setServerName(String serverName)
                   throws SQLException
```
    Sets the database server name.
    
    Specified by:
    
    setServerName in interface PoolDataSource
    
    Parameters:
    
    serverName - Database server name to be set.
    
    Throws:
    
    SQLException
  - getServerName
```
public String getServerName()
```
    Gets the database server name.
    
    Specified by:
    
    getServerName in interface PoolDataSource
    
    Returns:
    
    Database server name.
  - setPortNumber
```
public void setPortNumber(int portNumber)
                   throws SQLException
```
    Sets the database port number.
    
    Specified by:
    
    setPortNumber in interface PoolDataSource
    
    Parameters:
    
    portNumber - Database port number to be set.
    
    Throws:
    
    SQLException
  - getPortNumber
```
public int getPortNumber()
```
    Gets the database port number.
    
    Specified by:
    
    getPortNumber in interface PoolDataSource
    
    Returns:
    
    Database port number.
  - setDatabaseName
```
public void setDatabaseName(String databaseName)
                     throws SQLException
```
    Sets the database name.
    
    Specified by:
    
    setDatabaseName in interface PoolDataSource
    
    Parameters:
    
    databaseName - Database name to be set.
    
    Throws:
    
    SQLException
  - getDatabaseName
```
public String getDatabaseName()
```
    Gets the database name.
    
    Specified by:
    
    getDatabaseName in interface PoolDataSource
    
    Returns:
    
    Database name.
  - setDataSourceName
```
public void setDataSourceName(String dataSourceName)
                       throws SQLException
```
    Sets the data source name.
    
    Specified by:
    
    setDataSourceName in interface PoolDataSource
    
    Parameters:
    
    dataSourceName - data source name to be set.
    
    Throws:
    
    SQLException
  - getDataSourceName
```
public String getDataSourceName()
```
    Gets the data source name.
    
    Specified by:
    
    getDataSourceName in interface PoolDataSource
    
    Returns:
    
    data source name.
  - setDescription
```
public void setDescription(String description)
                    throws SQLException
```
    Sets the data source description.
    
    Specified by:
    
    setDescription in interface PoolDataSource
    
    Parameters:
    
    description - data source description to be set.
    
    Throws:
    
    SQLException
  - getDescription
```
public String getDescription()
```
    Gets the data source description.
    
    Specified by:
    
    getDescription in interface PoolDataSource
    
    Returns:
    
    data source description.
  - setNetworkProtocol
```
public void setNetworkProtocol(String networkProtocol)
                        throws SQLException
```
    Sets the datasource networkProtocol.
    
    Specified by:
    
    setNetworkProtocol in interface PoolDataSource
    
    Parameters:
    
    networkProtocol - datasource networkProtocol to be set.
    
    Throws:
    
    SQLException
  - getNetworkProtocol
```
public String getNetworkProtocol()
```
    Gets the datasource networkProtocol.
    
    Specified by:
    
    getNetworkProtocol in interface PoolDataSource
    
    Returns:
    
    datasource networkProtocol.
  - setRoleName
```
public void setRoleName(String roleName)
                 throws SQLException
```
    Sets the datasource role name.
    
    Specified by:
    
    setRoleName in interface PoolDataSource
    
    Parameters:
    
    roleName - datasource role name to be set.
    
    Throws:
    
    SQLException
  - getRoleName
```
public String getRoleName()
```
    Gets the datasource role name.
    
    Specified by:
    
    getRoleName in interface PoolDataSource
    
    Returns:
    
    datasource role name.
  - setInitialPoolSize
```
public void setInitialPoolSize(int initialPoolSize)
                        throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setInitialPoolSize in interface PoolDataSource
    
    Parameters:
    
    initialPoolSize - the initial pool size.
    
    Throws:
    
    SQLException
  - getInitialPoolSize
```
public int getInitialPoolSize()
```
    Description copied from interface: PoolDataSource
    
    Gets the initial pool size.
    
    Specified by:
    
    getInitialPoolSize in interface PoolDataSource
    
    Returns:
    
    the initial pool size.
  - setMinPoolSize
```
public void setMinPoolSize(int minPoolSize)
                    throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setMinPoolSize in interface PoolDataSource
    
    Parameters:
    
    minPoolSize - The minimum number of connections.
    
    Throws:
    
    SQLException
  - getMinPoolSize
```
public int getMinPoolSize()
```
    Description copied from interface: PoolDataSource
    
    Gets the minimum number of connections that the connection pool will maintain.
    
    Specified by:
    
    getMinPoolSize in interface PoolDataSource
    
    Returns:
    
    The minimum number of connections.
  - setMaxPoolSize
```
public void setMaxPoolSize(int maxPoolSize)
                    throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setMaxPoolSize in interface PoolDataSource
    
    Parameters:
    
    maxPoolSize - The maximum number of connections.
    
    Throws:
    
    SQLException
  - getMaxPoolSize
```
public int getMaxPoolSize()
```
    Description copied from interface: PoolDataSource
    
    Gets the maximum number of connections that the connection pool will maintain.
    
    Specified by:
    
    getMaxPoolSize in interface PoolDataSource
    
    Returns:
    
    The maximum number of connections.
  - getMaxConnectionsPerService
```
public int getMaxConnectionsPerService()
```
    Description copied from interface: PoolDataSource
    
    Gets the maximum number of connections that can be obtained to a particular service, in a shared pool.
    
    Specified by:
    
    getMaxConnectionsPerService in interface PoolDataSource
    
    Returns:
    
    The maximum number of connections that can be obtained to a particular service.
  - setInactiveConnectionTimeout
```
public void setInactiveConnectionTimeout(int inactivityTimeout)
                                  throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setInactiveConnectionTimeout in interface PoolDataSource
    
    Parameters:
    
    inactivityTimeout - The inactive connection timeout in seconds.
    
    Throws:
    
    SQLException
  - getInactiveConnectionTimeout
```
public int getInactiveConnectionTimeout()
```
    Description copied from interface: PoolDataSource
    
    Gets the inactive connection timeout.
    
    Specified by:
    
    getInactiveConnectionTimeout in interface PoolDataSource
    
    Returns:
    
    The inactivity timeout.
  - setConnectionWaitTimeout
```
public void setConnectionWaitTimeout(int waitTimeout)
                              throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setConnectionWaitTimeout in interface PoolDataSource
    
    Parameters:
    
    waitTimeout - The amount of time to wait.
    
    Throws:
    
    SQLException
  - getConnectionWaitTimeout
```
public int getConnectionWaitTimeout()
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    getConnectionWaitTimeout in interface PoolDataSource
    
    Returns:
    
    The connection wait timeout.
  - setTimeToLiveConnectionTimeout
```
public void setTimeToLiveConnectionTimeout(int timeToLiveConnectionTimeout)
                                    throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setTimeToLiveConnectionTimeout in interface PoolDataSource
    
    Parameters:
    
    timeToLiveConnectionTimeout - The maximum time (in seconds) a used connection may be active.
    
    Throws:
    
    SQLException
  - getTimeToLiveConnectionTimeout
```
public int getTimeToLiveConnectionTimeout()
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    getTimeToLiveConnectionTimeout in interface PoolDataSource
    
    Returns:
    
    The maximum time (in seconds) a used connection may be active.
  - getAbandonedConnectionTimeout
```
public int getAbandonedConnectionTimeout()
```
    Description copied from interface: PoolDataSource
    
    Gets the abandoned connection timeout value.
    
    Specified by:
    
    getAbandonedConnectionTimeout in interface PoolDataSource
    
    Returns:
    
    The abandoned connection timeout.
  - setAbandonedConnectionTimeout
```
public void setAbandonedConnectionTimeout(int abandonedConnectionTimeout)
                                   throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setAbandonedConnectionTimeout in interface PoolDataSource
    
    Parameters:
    
    abandonedConnectionTimeout - The value of how long a connection has not been used before it is abandoned (in seconds).
    
    Throws:
    
    SQLException
  - setTimeoutCheckInterval
```
public void setTimeoutCheckInterval(int timeInterval)
                             throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setTimeoutCheckInterval in interface PoolDataSource
    
    Parameters:
    
    timeInterval - The timeInterval (in seconds) between checks to enforce the timeout properties.
    
    Throws:
    
    SQLException
  - getTimeoutCheckInterval
```
public int getTimeoutCheckInterval()
```
    Description copied from interface: PoolDataSource
    
    Gets the timeout check interval (in seconds).
    
    Specified by:
    
    getTimeoutCheckInterval in interface PoolDataSource
    
    Returns:
    
    timeInterval The timeInterval (in seconds) between checks to enforce the timeout properties.
  - setFastConnectionFailoverEnabled
```
public void setFastConnectionFailoverEnabled(boolean failoverEnabled)
                                      throws SQLException
```
    Description copied from interface: PoolDataSource
    
    Enables Fast Connection Failover (FCF) for the connection pool accessed using this pool-enabled data source. By default, FCF is disabled.
    
    Specified by:
    
    setFastConnectionFailoverEnabled in interface PoolDataSource
    
    Parameters:
    
    failoverEnabled - true if Fast Connection Failover is enabled; false if not.
    
    Throws:
    
    SQLException
  - getFastConnectionFailoverEnabled
```
public boolean getFastConnectionFailoverEnabled()
```
    Description copied from interface: PoolDataSource
    
    Checks if Fast Connection Failover is enabled.
    
    Specified by:
    
    getFastConnectionFailoverEnabled in interface PoolDataSource
    
    Returns:
    
    true if Fast Connection Failover is enabled; false if not.
  - getConnectionFactoryClassName
```
public String getConnectionFactoryClassName()
```
    Description copied from interface: PoolDataSource
    
    Gets the Connection Factory class name.
    
    Specified by:
    
    getConnectionFactoryClassName in interface PoolDataSource
    
    Returns:
    
    Name of the connection factory class specified.
  - setConnectionFactoryClassName
```
public void setConnectionFactoryClassName(String factoryClassName)
                                   throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setConnectionFactoryClassName in interface PoolDataSource
    
    Parameters:
    
    factoryClassName - Connection factory class name for obtaining physical connections.
    
    Throws:
    
    SQLException
  - setMaxStatements
```
public 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.
    
    Specified by:
    
    setMaxStatements in interface PoolDataSource
    
    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
```
public int getMaxStatements()
```
    Gets the maximum number of statements that may be pooled or cached on a Connection.
    
    Specified by:
    
    getMaxStatements in interface PoolDataSource
    
    Returns:
    
    The maximum number of statements that may be pooled or cached on a Connection.
  - setMaxIdleTime
```
public void setMaxIdleTime(int idleTime)
                    throws SQLException
```
    Sets Idle timeout for available connections in the pool.
    
    Specified by:
    
    setMaxIdleTime in interface PoolDataSource
    
    Parameters:
    
    idleTime - Idle timeout value in seconds.
    
    Throws:
    
    SQLException
  - getMaxIdleTime
```
public int getMaxIdleTime()
```
    Gets Idle timeout value.
    
    Specified by:
    
    getMaxIdleTime in interface PoolDataSource
    
    Returns:
    
    Idle timeout.
  - setPropertyCycle
```
public void setPropertyCycle(int propertyCycle)
                      throws SQLException
```
    Sets Property cycle in seconds. This is the time interval between checks to enforce connection pool timeout properties.
    
    Specified by:
    
    setPropertyCycle in interface PoolDataSource
    
    Parameters:
    
    propertyCycle - Time interval in seconds to enforce connection pool timeout properties.
    
    Throws:
    
    SQLException
  - getPropertyCycle
```
public int getPropertyCycle()
```
    Gets Property cycle in seconds.
    
    Specified by:
    
    getPropertyCycle in interface PoolDataSource
    
    Returns:
    
    PropertyCycle value.
  - setConnectionPoolName
```
public 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.
    
    Specified by:
    
    setConnectionPoolName in interface PoolDataSource
    
    Parameters:
    
    connectionPoolName - Name of connection pool.
    
    Throws:
    
    SQLException
  - getConnectionPoolName
```
public String getConnectionPoolName()
```
    Gets the connection pool name.
    
    Specified by:
    
    getConnectionPoolName in interface PoolDataSource
    
    Returns:
    
    connectionpoolName.
  - setValidateConnectionOnBorrow
```
public void setValidateConnectionOnBorrow(boolean validateConnectionOnBorrow)
                                   throws SQLException
```
    Sets whether or not a connection being borrowed should first be validated.
    
    Specified by:
    
    setValidateConnectionOnBorrow in interface PoolDataSource
    
    Parameters:
    
    validateConnectionOnBorrow - Whether or not a connection being borrowed should first be validated.
    
    Throws:
    
    SQLException
  - getValidateConnectionOnBorrow
```
public boolean getValidateConnectionOnBorrow()
```
    Returns whether or not a connection being borrowed should first be validated.
    
    Specified by:
    
    getValidateConnectionOnBorrow in interface PoolDataSource
    
    Returns:
    
    Whether or not a connection being borrowed should first be validated.
  - setSQLForValidateConnection
```
public void setSQLForValidateConnection(String SQLString)
                                 throws SQLException
```
    Sets the value(SQL) for SQLForValidateConnection property. This is used in conjunction with the ValidateConnectionOnBorrow property. The SQL specified should be applicable to back end database and the JDBC driver configured.
    
    Specified by:
    
    setSQLForValidateConnection in interface PoolDataSource
    
    Parameters:
    
    SQLString - The SQL string used for connection validation.
    
    Throws:
    
    SQLException
  - getSQLForValidateConnection
```
public String getSQLForValidateConnection()
```
    Gets the Value for SQLForValidateConnection property.
    
    Specified by:
    
    getSQLForValidateConnection in interface PoolDataSource
    
    Returns:
    
    SQLForValidateConnection value.
  - getConnectionHarvestTriggerCount
```
public int getConnectionHarvestTriggerCount()
```
    Gets the number of available connections at which the connection pool's connection harvesting will occur.
    
    Specified by:
    
    getConnectionHarvestTriggerCount in interface PoolDataSource
    
    Returns:
    
    The number of available connections at which the connection pool's connection harvesting will occur.
  - setConnectionHarvestTriggerCount
```
public void setConnectionHarvestTriggerCount(int connectionHarvestTriggerCount)
                                      throws SQLException
```
    Sets the number of available connections at which the connection pool's connection harvesting will occur.
    
    Specified by:
    
    setConnectionHarvestTriggerCount in interface PoolDataSource
    
    Parameters:
    
    connectionHarvestTriggerCount - The number of available connections at which the connection pool's connection harvesting will occur.
    
    Throws:
    
    SQLException
  - getConnectionHarvestMaxCount
```
public 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.
    
    Specified by:
    
    getConnectionHarvestMaxCount in interface PoolDataSource
    
    Returns:
    
    The maximum number of connections that may be harvested when the connection harvesting occurs.
  - setConnectionHarvestMaxCount
```
public void setConnectionHarvestMaxCount(int connectionHarvestMaxCount)
                                  throws SQLException
```
    Sets the maximum number of connections that may be harvested when the connection harvesting occurs.
    
    Specified by:
    
    setConnectionHarvestMaxCount in interface PoolDataSource
    
    Parameters:
    
    connectionHarvestMaxCount - the maximum number of connections that may be harvested when the connection harvesting occurs.
    
    Throws:
    
    SQLException
  - getMaxConnectionReuseTime
```
public long getMaxConnectionReuseTime()
```
    Gets the connection reuse time property.
    
    Specified by:
    
    getMaxConnectionReuseTime in interface PoolDataSource
    
    Returns:
    
    connection reuse time (in seconds), 0 value means that the feature is disabled.
  - setMaxConnectionReuseTime
```
public void setMaxConnectionReuseTime(long maxConnectionReuseTime)
                               throws SQLException
```
    Gets the connection reuse time property.
    
    Specified by:
    
    setMaxConnectionReuseTime in interface PoolDataSource
    
    Parameters:
    
    connection - reuse time (in seconds), 0 value means that the feature is disabled.
    
    Throws:
    
    SQLException
  - getMaxConnectionReuseCount
```
public int getMaxConnectionReuseCount()
```
    Gets the connection reuse count property.
    
    Specified by:
    
    getMaxConnectionReuseCount in interface PoolDataSource
    
    Returns:
    
    connection reuse count, 0 value means that the feature is disabled.
  - setMaxConnectionReuseCount
```
public void setMaxConnectionReuseCount(int maxConnectionReuseCount)
                                throws SQLException
```
    Gets the connection reuse count property.
    
    Specified by:
    
    setMaxConnectionReuseCount in interface PoolDataSource
    
    Parameters:
    
    connection - reuse count, 0 value means that the feature is disabled.
    
    Throws:
    
    SQLException
  - getAvailableConnectionsCount
```
public int getAvailableConnectionsCount()
```
    Gets the number of available connections in the pool.
    
    Specified by:
    
    getAvailableConnectionsCount in interface PoolDataSource
    
    Returns:
    
    AvailableConnectionsCount.
  - getBorrowedConnectionsCount
```
public int getBorrowedConnectionsCount()
```
    Gets the number of borrowed connections from the pool.
    
    Specified by:
    
    getBorrowedConnectionsCount in interface PoolDataSource
    
    Returns:
    
    BorrowedConnectionsCount.
  - getONSConfiguration
```
public 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 Load Balancing.
    
    Specified by:
    
    getONSConfiguration in interface PoolDataSource
    
    Returns:
    
    The ONS configuration string used for remote ONS subscription.
    
    Throws:
    
    SQLException
  - setONSConfiguration
```
public 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", and contains a list of "
    =" pairs separated by newline character '\n', where can be one of "nodes", "walletfile", or "walletpassword". The parameter string should at least specify the ONS configuration attribute "nodes", as a list of host:port pairs separated by 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.
    Specified by:
    
    setONSConfiguration in interface PoolDataSource
    
    Parameters:
    
    onsConfigStr - The configuration string for remote ONS subscription.
    
    Throws:
    
    SQLException
  - registerConnectionLabelingCallback
```
public void registerConnectionLabelingCallback(ConnectionLabelingCallback cbk)
                                        throws SQLException
```
    Registers a ConnectionLabelingCallback with the underlying connection pool.
    
    Specified by:
    
    registerConnectionLabelingCallback in interface PoolDataSource
    
    Parameters:
    
    cbk - The ConnectionLabelingCallback object to be registered.
    
    Throws:
    
    SQLException - If there is a callback already registered with the pool.
  - removeConnectionLabelingCallback
```
public void removeConnectionLabelingCallback()
                                      throws SQLException
```
    Removes the ConnectionLabelingCallback object registered with the underlying connection pool, if any.
    
    Specified by:
    
    removeConnectionLabelingCallback in interface PoolDataSource
    
    Throws:
    
    SQLException - If callback removal fails.
  - registerConnectionAffinityCallback
```
public void registerConnectionAffinityCallback(ConnectionAffinityCallback cbk)
                                        throws SQLException
```
    Registers a ConnectionAffinityCallback on the connection pool.
    
    Specified by:
    
    registerConnectionAffinityCallback in interface PoolDataSource
    
    Parameters:
    
    cbk - Affinity Callback object that must be registered.
    
    Throws:
    
    SQLException - If callback registration fails.
  - removeConnectionAffinityCallback
```
public void removeConnectionAffinityCallback()
                                      throws SQLException
```
    Removes the ConnectionAffinityCallback registered on the connection pool.
    
    Specified by:
    
    removeConnectionAffinityCallback in interface PoolDataSource
    
    Throws:
    
    SQLException - If callback removal fails.
  - getStatistics
```
public JDBCConnectionPoolStatistics getStatistics()
```
    Gets the statistics of the connection pool.
    
    Specified by:
    
    getStatistics in interface PoolDataSource
    
    Returns:
    
    The statistics of the connection pool.
  - getServiceName
```
public String getServiceName()
```
    Gets the service name set on this data source
    
    Specified by:
    
    getServiceName in interface PoolDataSource
    
    Returns:
    
    service name on this data source
  - getConnectionProperties
```
public Properties getConnectionProperties()
```
    Gets the connection properties that are set on this data source.
    
    Specified by:
    
    getConnectionProperties in interface PoolDataSource
    
    Returns:
    
    Connection properties.
  - getConnectionProperty
```
public String getConnectionProperty(String propertyName)
```
    Gets the specified connection property that are set on this data source.
    
    Specified by:
    
    getConnectionProperty in interface PoolDataSource
    
    Parameters:
    
    propertyName - The name of the specified property.
    
    Returns:
    
    The value of the inquired connection property. Null if the property is not set.
  - setConnectionProperty
```
public 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.
    
    Specified by:
    
    setConnectionProperty in interface PoolDataSource
    
    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
```
public 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.
    
    Specified by:
    
    setConnectionProperties in interface PoolDataSource
    
    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
```
public Properties getConnectionFactoryProperties()
```
    Gets the connection factory properties that are set on this data source.
    
    Specified by:
    
    getConnectionFactoryProperties in interface PoolDataSource
    
    Returns:
    
    Connection factory properties.
  - getConnectionFactoryProperty
```
public String getConnectionFactoryProperty(String propertyName)
```
    Gets the specified connection factory property that are set on this data source.
    
    Specified by:
    
    getConnectionFactoryProperty in interface PoolDataSource
    
    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
```
public 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.
    
    Specified by:
    
    setConnectionFactoryProperty in interface PoolDataSource
    
    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
```
public 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.
    
    Specified by:
    
    setConnectionFactoryProperties in interface PoolDataSource
    
    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.
  - toBasicType
```
public static final Object toBasicType(String value,
                                       String type)
```
  - getReference
```
public Reference getReference()
                       throws NamingException
```
    Specified by:
    
    getReference in interface Referenceable
    
    Throws:
    
    NamingException
  - getObjectInstance
```
public Object getObjectInstance(Object refObj,
                                Name name,
                                Context nameCtx,
                                Hashtable env)
                         throws Exception
```
    Specified by:
    
    getObjectInstance in interface ObjectFactory
    
    Throws:
    
    Exception
  - isWrapperFor
```
public boolean isWrapperFor(Class<?> iface)
                     throws SQLException
```
    Since this class is not a wrapper, just check to see if this implements the requested interface.
    
    Specified by:
    
    isWrapperFor in interface Wrapper
    
    Parameters:
    
    iface - Requested interface.
    
    Returns:
    
    true If this implements the requested interface.
    
    Throws:
    
    SQLException - If the argument is not an interface.
    
    Since:
    
    JDBC 4.0
  - unwrap
```
public <T> T unwrap(Class<T> iface)
             throws SQLException
```
    Since this class is not a wrapper, just check to see if this implements the requested interface.
    
    Specified by:
    
    unwrap in interface Wrapper
    
    Parameters:
    
    iface - Requested interface.
    
    Returns:
    
    this If this implements the requested interface.
    
    Throws:
    
    SQLException - If this does not implement the arg or the arg is not an interface.
    
    Since:
    
    JDBC 4.0
  - registerConnectionInitializationCallback
```
public void registerConnectionInitializationCallback(ConnectionInitializationCallback cbk)
                                              throws SQLException
```
    Registers a connection initialization callback.
    
    Specified by:
    
    registerConnectionInitializationCallback in interface PoolDataSource
    
    Parameters:
    
    cbk - The ConnectionInitializationCallback object to be registered.
    
    Throws:
    
    SQLException - If there is a callback already registered with the pool.
  - unregisterConnectionInitializationCallback
```
public void unregisterConnectionInitializationCallback()
                                                throws SQLException
```
    Unregisters the connection initialization callback on this pool.
    
    Specified by:
    
    unregisterConnectionInitializationCallback in interface PoolDataSource
    
    Throws:
    
    SQLException - If callback removal fails.
  - getConnectionInitializationCallback
```
public ConnectionInitializationCallback getConnectionInitializationCallback()
```
    Obtains the registered connection initialization callback, if any.
    
    Specified by:
    
    getConnectionInitializationCallback in interface PoolDataSource
    
    Returns:
    
    The registered ConnectionInitializationCallback, or null if there is no callback registered.
  - getConnectionLabelingHighCost
```
public int getConnectionLabelingHighCost()
```
    Description copied from interface: PoolDataSource
    
    Obtains the cost value which identifies a connection as "high-cost" for connection labeling.
    
    Specified by:
    
    getConnectionLabelingHighCost in interface PoolDataSource
    
    Returns:
    
    The cost value that identifies a connection as "high-cost" for connection labeling.
    
    See Also:
    
    setConnectionLabelingHighCost
  - setConnectionLabelingHighCost
```
public void setConnectionLabelingHighCost(int highCost)
                                   throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setConnectionLabelingHighCost in interface PoolDataSource
    
    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.
  - getConnectionRepurposeThreshold
```
public int getConnectionRepurposeThreshold()
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    getConnectionRepurposeThreshold in interface PoolDataSource
    
    Returns:
    
    connection repurpose threshold property value currently set.
  - setConnectionRepurposeThreshold
```
public void setConnectionRepurposeThreshold(int threshold)
                                     throws SQLException
```
    Description copied from interface: PoolDataSource
    
    Sets the connection repurpose threshold for the pool. This property is applicable only for multi-tenant databases.
    
    Specified by:
    
    setConnectionRepurposeThreshold in interface PoolDataSource
    
    Parameters:
    
    threshold - connection repurpose threshold to set.
    
    Throws:
    
    SQLException - If any exception occurs while setting the threshold.
    
    See Also:
    
    getConnectionRepurposeThreshold
  - getHighCostConnectionReuseThreshold
```
public int getHighCostConnectionReuseThreshold()
```
    Description copied from interface: PoolDataSource
    
    Obtains the high-cost connection reuse threshold property value for connection labeling.
    
    Specified by:
    
    getHighCostConnectionReuseThreshold in interface PoolDataSource
    
    Returns:
    
    The high-cost connection reuse threshold property value currently set.
    
    See Also:
    
    setConnectionLabelingHighCost, setHighCostConnectionReuseThreshold
  - setHighCostConnectionReuseThreshold
```
public void setHighCostConnectionReuseThreshold(int threshold)
                                         throws SQLException
```
    Description copied from interface: PoolDataSource
    
    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.
    
    Specified by:
    
    setHighCostConnectionReuseThreshold in interface PoolDataSource
    
    Parameters:
    
    threshold - The high-cost connection reuse threshold to set.
    
    Throws:
    
    SQLException - If any exception occurs while setting the threshold.
  - getPdbRoles
```
public Properties getPdbRoles()
```
    Gets the PDB roles specified for this datasource
    
    Specified by:
    
    getPdbRoles in interface PoolDataSource
    
    Returns:
    
    roles key values pairs that correspond to the role names and password that are set for this datasource
    
    See Also:
    
    setPdbRoles
  - getSecondsToTrustIdleConnection
```
public int getSecondsToTrustIdleConnection()
```
    Gets the seconds To Trust Idle Connection value. See property description in setSecondsToTrustIdleConnection().
    
    Specified by:
    
    getSecondsToTrustIdleConnection in interface PoolDataSource
    
    Returns:
    
    Seconds To Trust Idle Connection value.
  - setSecondsToTrustIdleConnection
```
public 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.
    
    Specified by:
    
    setSecondsToTrustIdleConnection in interface PoolDataSource
    
    Parameters:
    
    secondsToTrustIdleConnection - The value of how long a connection can be trusted to skip connectionValidationOnBorrow
    
    Throws:
    
    SQLException
  - createConnectionBuilder
```
public UCPConnectionBuilder createConnectionBuilder()
```
    Description copied from interface: PoolDataSource
    
    Creates a new UCPConnectionBuilder instance.
    
    Specified by:
    
    createConnectionBuilder in interface PoolDataSource
    
    Returns:
    
    Connection builder that builds OracleConnection
    
    See Also:
    
    PoolDataSource.createConnectionBuilder()
  - getParentLogger
```
public Logger getParentLogger()
                       throws SQLFeatureNotSupportedException
```
    Specified by:
    
    getParentLogger in interface CommonDataSource
    
    Returns:
    
    null
    
    Throws:
    
    SQLFeatureNotSupportedException
    
    See Also:
    
    CommonDataSource.getParentLogger()
  - getQueryTimeout
```
public int getQueryTimeout()
```
    Gets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.
    
    Specified by:
    
    getQueryTimeout in interface PoolDataSource
    
    Returns:
    
    The query timeout in seconds
  - setQueryTimeout
```
public 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.
    
    Specified by:
    
    setQueryTimeout in interface PoolDataSource
    
    Parameters:
    
    queryTimeout - in seconds
    
    Throws:
    
    SQLException
  - getMaxConnectionsPerShard
```
public int getMaxConnectionsPerShard()
```
    Gets the currently configured max connections that can be created per shard in a sharded database configuration.
    
    Specified by:
    
    getMaxConnectionsPerShard in interface PoolDataSource
    
    Returns:
    
    The configured max number of connections that can be created per shard.
  - setMaxConnectionsPerShard
```
public void setMaxConnectionsPerShard(int maxConnectionsPerShard)
                               throws SQLException
```
    Sets the max number of connections that can be created per shard in a sharded database configuration. (Note: This configuration is not compatible with Sharded database configured with Oracle Golden gate)
    
    Specified by:
    
    setMaxConnectionsPerShard in interface PoolDataSource
    
    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
  - ilogFinest
```
protected void ilogFinest(Logger logger,
                          Class cls,
                          Executable method,
                          Object receiver,
                          String message)
```
    Helpers for writing into log and logWriter
  - ilogFine
```
protected void ilogFine(Logger logger,
                        Class cls,
                        Executable method,
                        Object receiver,
                        String message)
```
  - ilogWarning
```
protected void ilogWarning(Logger logger,
                           Class cls,
                           Executable method,
                           Object receiver,
                           String message)
```
  - ilogSevere
```
protected void ilogSevere(Logger logger,
                          Class cls,
                          Executable method,
                          Object receiver,
                          String message)
```
  - ilogThrowing
```
protected void ilogThrowing(Logger logger,
                            Class cls,
                            Executable method,
                            Object receiver,
                            Throwable throwable)
```

Class PoolDataSourceImpl

Field Summary

Fields inherited from interface oracle.ucp.jdbc.PoolDataSource

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface oracle.ucp.jdbc.PoolDataSource

Field Detail

SECRET_STORE_CONNECT

SECRET_STORE_USERNAME

SECRET_STORE_PASSWORD

SECRET_STORE_DEFAULT_USERNAME

SECRET_STORE_DEFAULT_PASSWORD

m_connectionFactoryClassName

m_connectionFactory

m_cp

Constructor Detail

PoolDataSourceImpl

Method Detail

startPool

createPoolWithDefaultProperties

createUniversalConnectionPool

reconfigureDataSource

createUniversalConnectionPoolMBean

getConnection

getConnection

getConnection

getConnection

getLogWriter

setLogWriter

setLoginTimeout

getLoginTimeout

getUser

setUser

getPassword

setPassword

getURL

setURL

setServerName

getServerName

setPortNumber

getPortNumber

setDatabaseName

getDatabaseName

setDataSourceName

getDataSourceName

setDescription

getDescription

setNetworkProtocol

getNetworkProtocol

setRoleName

getRoleName

setInitialPoolSize

getInitialPoolSize

setMinPoolSize

getMinPoolSize

setMaxPoolSize

getMaxPoolSize

getMaxConnectionsPerService

setInactiveConnectionTimeout

getInactiveConnectionTimeout

setConnectionWaitTimeout

getConnectionWaitTimeout

setTimeToLiveConnectionTimeout

getTimeToLiveConnectionTimeout

getAbandonedConnectionTimeout

setAbandonedConnectionTimeout

setTimeoutCheckInterval

getTimeoutCheckInterval

setFastConnectionFailoverEnabled

getFastConnectionFailoverEnabled

getConnectionFactoryClassName

setConnectionFactoryClassName

setMaxStatements

getMaxStatements

setMaxIdleTime

getMaxIdleTime

setPropertyCycle

getPropertyCycle

setConnectionPoolName