Package oracle.jdbc.pool

Class OracleOCIConnectionPool

    • Constructor Detail

      • OracleOCIConnectionPool

        public OracleOCIConnectionPool​(String us,
                               String p,
                               String url,
                               Properties info)
                        throws SQLException
        Notes: Choose a userid and password that can act as proxy for the users in the getProxyConnection() method.
        Parameters:
        us - ConnectionPool user-id.
        p - ConnectionPool password
        url - 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.
        Throws:
        SQLException

      • OracleOCIConnectionPool

        public OracleOCIConnectionPool()
                        throws SQLException
        This will use the user-id, password and connection pool name values set using the methods setUser, setPassword, setConnectionPoolName.

        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.

        Throws:
        SQLException

    • Method Detail

      • getProxyConnection

        public oracle.jdbc.internal.OracleConnection getProxyConnection​(String proxytype,
                                                                Properties prop)
                                                         throws SQLException
        For creating a proxy connection.

        Notes: The user and password used to create OracleOCIConnectionPool() must be allowed to act as proxy for user 'us'.

        Parameters:
        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 proxyUser
        proxyUser - The user, or certificate, to be proxied against.
        roles - Set of roles which this proxy connection can use
        Returns:
        connection object
        Throws:
        SQLException

      • getAliasedConnection

        public oracle.jdbc.internal.OracleConnection getAliasedConnection​(byte[] conId)
                                                           throws SQLException
        For creating aliased sessions.

        Notes: Once this call is issued, this connection object can't be used for any operation, as the intent for connection cloning is failover.

        Parameters:
        conId - - byte[] of the connection id
        Throws:
        SQLException

      • close

        public void close()
           throws SQLException
        This will destroy the connection pool, and close all the connections opened from this data source. Hence all the statement objects created from these connection objects will also be closed.
        Throws:
        SQLException

      • setPoolConfig

        public void setPoolConfig​(Properties prop)
                   throws SQLException
        (Re-)Set the pool configuration for the Cache. Note: We will not be exposing set for individual settings of the pool's configuration. Users will have to call setPoolConfig with min, max & increment in order for the pool's configuration to be changed.
        Parameters:
        prop -
        Throws:
        SQLException

      • readPoolConfig

        public static void readPoolConfig​(int minLimit,
                                  int maxLimit,
                                  int increment,
                                  int timeout,
                                  boolean nowait,
                                  boolean transactionsDistributed,
                                  int[] p)
        read the properties into an integer array

      • readPoolConfig

        public static void readPoolConfig​(Properties info,
                                  int[] p)

      • getActiveSize

        public int getActiveSize()
                  throws SQLException
        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. This should be used only as estimate and perhaps for statistical analysis.
        Returns:
        Throws:
        SQLException

      • getPoolSize

        public int getPoolSize()
                throws SQLException
        Return the number of physical connections in the connection pool Note that the count cannot be guaranteed on any invoking subsequent OracleOCIConnectionCacheImpl method. This should be used only as estimate and perhaps for statistical analysis.
        Returns:
        Throws:
        SQLException

      • getTimeout

        public int getTimeout()
               throws SQLException
        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. If this attribute is not set, the connections are never timed out.
        Returns:
        Throws:
        SQLException

      • getNoWait

        public String getNoWait()
                 throws SQLException
        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. If this attribute is set, an error is thrown when all the connections are busy and no more connections can be opened. Otherwise the call waits till it gets a connection.
        Returns:
        Throws:
        SQLException

      • getMinLimit

        public int getMinLimit()
                throws SQLException
        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.
        Returns:
        minimum limit on the no of Connections.
        Throws:
        SQLException

      • getMaxLimit

        public int getMaxLimit()
                throws SQLException
        Return the Max limit on Connections.
        Returns:
        int Max no of Connections that can be opened.
        Throws:
        SQLException

      • getConnectionIncrement

        public int getConnectionIncrement()
                           throws SQLException
        Return the Increment for increasing the connections for the Cache.
        Returns:
        int Increment
        Throws:
        SQLException

      • isDistributedTransEnabled

        public boolean isDistributedTransEnabled()

      • isPoolCreated

        public boolean isPoolCreated()
        check if the pool has been created. This occurs when is called with user/password or getConnection() has been called

      • connectionClosed

        public void connectionClosed​(oracle.jdbc.oci.OracleOCIConnection conn)
                      throws SQLException
        Throws:
        SQLException

      • setStmtCacheSize

        public void setStmtCacheSize​(int size)
                      throws SQLException
        Set the statement cache size. Default is 0. You cannot set this for logicalhandles obtained from this pool. If more than size cursors are already cached than they will be closed. By default the meta data of the cursor will be saved. Only data and the state will be cleared. You need to call this first to enable either type of Statement caching. When both types of Statement caching are enabled, the size is the total number of cursors cached for both the schemes together.
        Parameters:
        size - Size of the Cache
        Throws:
        SQLException

      • setStmtCacheSize

        public void setStmtCacheSize​(int size,
                             boolean clearMetaData)
                      throws SQLException
        Set the statement cache size. Default is 0. You cannot set this for logicalhandles obtained from this pool. If more than size cursors are already cached than they will be closed. By default, the meta data of the cursor will be saved. But if clearMetaData is set to true, even that will be cleared. You need to call this first to enable either type of Statement caching. When both types of Statement caching are enabled, the size is the total number of cursors cached for both the schemes together.
        Parameters:
        size - Size of the Cache
        clearMetaData - Whether the state has to be cleared or not
        Throws:
        SQLException

      • getStmtCacheSize

        public int getStmtCacheSize()
        Return the size of Statement Cache.
        Returns:
        int Size of Statement Cache. If not set, the default 0 is returned.

      • isStmtCacheEnabled

        public boolean isStmtCacheEnabled()
        Check whether Statement Caching is enabled for this pool or Not.