public class OracleOCIConnectionPool extends OracleDataSource
CHECKSUM_PROPERTY, clientChecksum11203x, clientChecksum12x, connectionProperties, databaseName, dataSourceName, DEFAULT_SERVICE_NAME, description, doneDumpOnMemoryPressure, driver, driverType, ENABLE_AC_SUPPORT_PROPERTY, explicitCachingEnabled, explicitCachingEnabledSet, FAILOVER_RESTORE_AUTO, FAILOVER_RESTORE_LEVEL1, FAILOVER_RESTORE_LEVEL2, FAILOVER_RESTORE_NONE, FAILOVER_RESTORE_PROPERTY, FAILOVER_TYPE_AUTO, FAILOVER_TYPE_PROPERTY, FAILOVER_TYPE_TRANSACTION, IGNORE_AC_CONTEXT_PROPERTY, implicitCachingEnabled, implicitCachingEnabledSet, INITIATION_TIMEOUT_PROPERTY, isAutoACEnabled, isFirstConnection, isOracleDataSource, isReplayInDynamicMode, isStateRestorationAuto, isTransactionReplayEnabled, loginTimeout, logWriter, maxStatements, maxStatementsSet, networkProtocol, password, portNumber, RECONNECT_DELAY_PROPERTY, RECONNECT_RETRIES_PROPERTY, reconnectDelay, reconnectRetries, replayInitiationTimeout, REQUEST_SIZE_LIMIT_PROPERTY, serverName, serviceName, SESSION_STATE_CONSISTENCY_STATIC, SESSION_STATE_PROPERTY, stateRestorationType, tnsEntry, TRACE, url, user
CONNECTION_PROPERTIES, DATA_SOURCE_NAME, DATABASE_NAME, DESCRIPTION, EXPLICIT_CACHING_ENABLED, IMPLICIT_CACHING_ENABLED, MAX_STATEMENTS, NETWORK_PROTOCOL, PASSWORD, PORT_NUMBER, ROLE_NAME, SERVER_NAME, URL, USER
Constructor and Description |
---|
OracleOCIConnectionPool()
This will use the user-id, password and connection pool name values
set using the methods setUser, setPassword, setConnectionPoolName.
|
OracleOCIConnectionPool(String us,
String p,
String url)
Deprecated.
|
OracleOCIConnectionPool(String us,
String p,
String url,
Properties info)
Notes: Choose a userid and password that can act as proxy for the users
in the getProxyConnection() method.
|
Modifier and Type | Method and Description |
---|---|
void |
close()
This will destroy the connection pool, and close all the connections
opened from this data source.
|
void |
connectionClosed(oracle.jdbc.oci.OracleOCIConnection conn) |
protected void |
debug(Logger logger,
Level level,
Executable method,
String msg)
AC specifc
|
int |
getActiveSize()
Return the number of active or busy connections in the connection pool
Note that the count cannot be guaranteed on any invoking subsequent
OracleOCIConnectionCacheImpl method.
|
oracle.jdbc.internal.OracleConnection |
getAliasedConnection(byte[] conId)
For creating aliased sessions.
|
Connection |
getConnection()
Attempt to establish a database connection.
|
Connection |
getConnection(String us,
String p)
For getting a connection to the database.
|
protected oracle.jdbc.internal.OracleConnection |
getConnectionDuringExceptionHandling() |
int |
getConnectionIncrement()
Return the Increment for increasing the connections for the Cache.
|
int |
getMaxLimit()
Return the Max limit on Connections.
|
int |
getMinLimit()
Note: There are no individual setMin, setMax and setIncrement since
that needs to be done in one call to setPoolConfig
Return the minimum limit on the no of Connections.
|
String |
getNoWait()
Return the connection No-wait parameter
This attribute determines if retrial for a connection has to be done
when all connections in the pool are found to be busy and the number
of connections already reached max.
|
Properties |
getPoolConfig() |
int |
getPoolSize()
Return the number of physical connections in the connection pool
Note that the count cannot be guaranteed on any invoking subsequent
OracleOCIConnectionCacheImpl method.
|
oracle.jdbc.internal.OracleConnection |
getProxyConnection(String proxytype,
Properties prop)
For creating a proxy connection.
|
Reference |
getReference()
Inherited from referenceable
|
int |
getStmtCacheSize()
Return the size of Statement Cache.
|
int |
getTimeout()
Return the timeout
The connections idle for more than this time (seconds) are
terminated periodically, to maintain optimum number of open
connections.This attribute can be set dynamically.
|
boolean |
isDistributedTransEnabled() |
boolean |
isPoolCreated()
check if the pool has been created.
|
boolean |
isStmtCacheEnabled()
Check whether Statement
Caching is enabled for this pool or Not.
|
static void |
readPoolConfig(int minLimit,
int maxLimit,
int increment,
int timeout,
boolean nowait,
boolean transactionsDistributed,
int[] p)
read the properties into an integer array
|
static void |
readPoolConfig(Properties info,
int[] p) |
void |
setPoolConfig(Properties prop)
(Re-)Set the pool configuration for the Cache.
|
void |
setStmtCacheSize(int size)
Set the statement cache size.
|
void |
setStmtCacheSize(int size,
boolean clearMetaData)
Set the statement cache size.
|
addRefProperties, cleanup, clearDoneDumpOnMemoryPressure, clearReplayStatistics, createConnectionBuilder, enableACAndProxifyIfNecessary, finalize, getConnection, getConnection, getConnectionInitializationCallback, getConnectionNoProxy, getConnectionProperties, getConnectionProperty, getDatabaseName, getDataSourceName, getDescription, getDriverType, getExplicitCachingEnabled, getImplicitCachingEnabled, getLoginTimeout, getLogWriter, getMaxStatements, getMonitorLock, getNetworkProtocol, getParentLogger, getPassword, getPhysicalConnection, getPortNumber, getProxyFactory, getReplayStatistics, getReplayStatisticsString, getRequestSizeLimit, getRoleName, getServerName, getServiceName, getSystemProperty, getTNSEntryName, getURL, getUser, isWrapperFor, makeURL, registerConnectionInitializationCallback, registerMBean, removeReplayStatistics, setConnectionProperties, setConnectionProperty, setDatabaseName, setDataSourceName, setDescription, setDriverType, setExplicitCachingEnabled, setHostnameResolver, setImplicitCachingEnabled, setLoginTimeout, setLogWriter, setMaxStatements, setNetworkProtocol, setPassword, setPortNumber, setRoleName, setServerName, setServiceName, setSingleShardTransactionSupport, setSSLContext, setTNSEntryName, setTokenSupplier, setupACSpecificProperties, setURL, setUser, trace, unregisterConnectionInitializationCallback, unregisterMBean, unwrap, updateReplayStatistics
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
setExecutorService
createShardingKeyBuilder
public oracle.jdbc.oci.OracleOCIConnection m_connection_pool
public static final String IS_CONNECTION_POOLING
public static final String CONNPOOL_OBJECT
public static final String CONNPOOL_LOGON_MODE
public static final String CONNECTION_POOL
public static final String CONNPOOL_CONNECTION
public static final String CONNPOOL_PROXY_CONNECTION
public static final String CONNPOOL_ALIASED_CONNECTION
public static final String PROXY_USER_NAME
public static final String PROXY_DISTINGUISHED_NAME
public static final String PROXY_CERTIFICATE
public static final String PROXY_ROLES
public static final String PROXY_NUM_ROLES
public static final String PROXY_PASSWORD
public static final String PROXYTYPE
public static final String PROXYTYPE_USER_NAME
public static final String PROXYTYPE_DISTINGUISHED_NAME
public static final String PROXYTYPE_CERTIFICATE
public static final String CONNECTION_ID
public static final String CONNPOOL_MIN_LIMIT
public static final String CONNPOOL_MAX_LIMIT
public static final String CONNPOOL_INCREMENT
public static final String CONNPOOL_ACTIVE_SIZE
public static final String CONNPOOL_POOL_SIZE
public static final String CONNPOOL_TIMEOUT
public static final String CONNPOOL_NOWAIT
public static final String CONNPOOL_IS_POOLCREATED
public static final String TRANSACTIONS_DISTRIBUTED
protected int m_stmtCacheSize
protected boolean m_stmtClearMetaData
public OracleOCIConnectionPool(String us, String p, String url, Properties info) throws SQLException
us
- ConnectionPool user-id.p
- ConnectionPool passwordurl
- This would be the full url including the database name.
The database name would be the logical name of the pool.info
- Set of properties (optional) for specifying the pool
configuration.SQLException
public OracleOCIConnectionPool(String us, String p, String url) throws SQLException
SQLException
public OracleOCIConnectionPool() throws SQLException
Notes: No useful operations (like getConnection) can be performed on this class unless the methods setUser, setPassword, setConnectionPoolName are invoked. Choose a userid and password that can act as proxy for the users in the getProxyConnection() method.
SQLException
public Connection getConnection() throws SQLException
OracleDataSource
Attempt to establish a database connection.
getConnection
in interface DataSource
getConnection
in class OracleDataSource
SQLException
- if a database-access error occurs.public Connection getConnection(String us, String p) throws SQLException
getConnection
in interface DataSource
getConnection
in class OracleDataSource
us
- Connection user-idp
- Connection passwordSQLException
- if a database-access error occurs.public Reference getReference() throws NamingException
getReference
in interface Referenceable
getReference
in class OracleDataSource
NamingException
public oracle.jdbc.internal.OracleConnection getProxyConnection(String proxytype, Properties prop) throws SQLException
Notes: The user and password used to create OracleOCIConnectionPool() must be allowed to act as proxy for user 'us'.
proxytype
- Can be one of following types
OracleOCIConnectionPool.PROXYCONNECTION_USER_NAME
- This will be the normal mode of specifying the user name
in proxyUser
OracleOCIConnectionPool.PROXYCONNECTION_DISTINGUISHED_NAME
- This will specify the distinguished name of the user in
proxyUser
OracleOCIConnectionPool.PROXYCONNECTION_CERTIFICATE
- This will specify the proxy certificate in proxyUserproxyUser
- The user, or certificate, to be proxied against.roles
- Set of roles which this proxy connection can useSQLException
public oracle.jdbc.internal.OracleConnection getAliasedConnection(byte[] conId) throws SQLException
Notes: Once this call is issued, this connection object can't be used for any operation, as the intent for connection cloning is failover.
conId
- - byte[] of the connection idSQLException
public void close() throws SQLException
SQLException
public void setPoolConfig(Properties prop) throws SQLException
prop
- SQLException
public static void readPoolConfig(int minLimit, int maxLimit, int increment, int timeout, boolean nowait, boolean transactionsDistributed, int[] p)
public static void readPoolConfig(Properties info, int[] p)
public Properties getPoolConfig() throws SQLException
SQLException
public int getActiveSize() throws SQLException
SQLException
public int getPoolSize() throws SQLException
SQLException
public int getTimeout() throws SQLException
SQLException
public String getNoWait() throws SQLException
SQLException
public int getMinLimit() throws SQLException
SQLException
public int getMaxLimit() throws SQLException
SQLException
public int getConnectionIncrement() throws SQLException
SQLException
public boolean isDistributedTransEnabled()
public boolean isPoolCreated()
public void connectionClosed(oracle.jdbc.oci.OracleOCIConnection conn) throws SQLException
SQLException
public void setStmtCacheSize(int size) throws SQLException
size
- Size of the CacheSQLException
public void setStmtCacheSize(int size, boolean clearMetaData) throws SQLException
size
- Size of the CacheclearMetaData
- Whether the state has to be cleared or notSQLException
public int getStmtCacheSize()
public boolean isStmtCacheEnabled()
protected oracle.jdbc.internal.OracleConnection getConnectionDuringExceptionHandling()
getConnectionDuringExceptionHandling
in class OracleDataSource
protected void debug(Logger logger, Level level, Executable method, String msg)
OracleDataSource
debug
in class OracleDataSource