Class PooledConnection

  • All Implemented Interfaces:

    public class PooledConnection
    extends java.lang.Object
    implements PooledConnectionMBean
    Represents a pooled connection and holds a reference to the Connection object
    • Field Detail


        public static final int VALIDATE_BORROW
        Validate when connection is borrowed flag
        See Also:
        Constant Field Values

        public static final int VALIDATE_RETURN
        Validate when connection is returned flag
        See Also:
        Constant Field Values

        public static final int VALIDATE_IDLE
        Validate when connection is idle flag
        See Also:
        Constant Field Values

        public static final int VALIDATE_INIT
        Validate when connection is initialized flag
        See Also:
        Constant Field Values
      • poolProperties

        protected PoolConfiguration poolProperties
        The properties for the connection pool
      • xaConnection

        protected volatile javax.sql.XAConnection xaConnection
        If using a XAConnection underneath.
    • Constructor Detail

      • PooledConnection

        public PooledConnection​(PoolConfiguration prop,
                                ConnectionPool parent)
        prop - - pool properties
        parent - - the parent connection pool
    • Method Detail

      • checkUser

        public boolean checkUser​(java.lang.String username,
                                 java.lang.String password)
        use shouldForceReconnect(String, String) method kept since it was public, to avoid changing interface.
        username - The user name
        password - The password
        trueif the pool does not need to reconnect
      • shouldForceReconnect

        public boolean shouldForceReconnect​(java.lang.String username,
                                            java.lang.String password)
        Returns true if we must force reconnect based on credentials passed in. Returns false if PoolConfiguration.isAlternateUsernameAllowed() method returns false. Returns false if the username/password has not changed since this connection was connected
        username - the username you wish to connect with, pass in null to accept the default username from PoolConfiguration.getUsername()
        password - the password you wish to connect with, pass in null to accept the default username from PoolConfiguration.getPassword()
        true is the pool must reconnect
      • connect

        public void connect()
                     throws java.sql.SQLException
        Connects the underlying connection to the database.
        java.sql.SQLException - if the method release() has been called.
        java.sql.SQLException - if driver instantiation fails
        java.sql.SQLException - if a call to Driver.connect(String, java.util.Properties) fails.
        java.sql.SQLException - if default properties are configured and a call to Connection.setAutoCommit(boolean), Connection.setCatalog(String), Connection.setTransactionIsolation(int) or Connection.setReadOnly(boolean) fails.
      • connectUsingDataSource

        protected void connectUsingDataSource()
                                       throws java.sql.SQLException
      • connectUsingDriver

        protected void connectUsingDriver()
                                   throws java.sql.SQLException
      • isInitialized

        public boolean isInitialized()
        Specified by:
        isInitialized in interface PooledConnectionMBean
        true if connect() was called successfully and disconnect has not yet been called
      • reconnect

        public void reconnect()
                       throws java.sql.SQLException
        Issues a call to disconnect(boolean) with the argument false followed by a call to connect()
        java.sql.SQLException - if the call to connect() fails.
      • getAbandonTimeout

        public long getAbandonTimeout()
        Returns abandon timeout in milliseconds
        abandon timeout in milliseconds
      • validate

        public boolean validate​(int validateAction)
        Returns true if the object is still valid. if not the pool will call the getExpiredAction() and follow up with one of the four expired methods
        validateAction - The value
        true if the connection is valid
      • validate

        public boolean validate​(int validateAction,
                                java.lang.String sql)
        Validates a connection.
        validateAction - the action used. One of VALIDATE_BORROW, VALIDATE_IDLE, VALIDATE_INIT or VALIDATE_RETURN
        sql - the SQL to be used during validation. If the PoolConfiguration.setInitSQL(String) has been called with a non null value and the action is VALIDATE_INIT the init SQL will be used for validation.
        true if the connection was validated successfully. It returns true even if validation was not performed, such as when PoolConfiguration.setValidationInterval(long) has been called with a positive value.

        false if the validation failed. The caller should close the connection if false is returned since a session could have been left in an unknown state during initialization.

      • release

        public boolean release()
        This method is called if (Now - timeCheckedIn > getReleaseTime()) This method disconnects the connection, logs an error in debug mode if it happens then sets the released flag to false. Any attempts to connect this cached object again will fail per connect() The connection pool uses the atomic return value to decrement the pool size counter.
        true if this is the first time this method has been called. false if this method has been called before.
      • setStackTrace

        public void setStackTrace​(java.lang.String trace)
        The pool will set the stack trace when it is check out and checked in
        trace - the stack trace for this connection
      • getStackTrace

        public java.lang.String getStackTrace()
        Returns the stack trace from when this connection was borrowed. Can return null if no stack trace was set.
        the stack trace or null of no trace was set
      • setTimestamp

        public void setTimestamp​(long timestamp)
        Sets a timestamp on this connection. A timestamp usually means that some operation performed successfully.
        timestamp - the timestamp as defined by System.currentTimeMillis()
      • setSuspect

        public void setSuspect​(boolean suspect)
      • setDiscarded

        public void setDiscarded​(boolean discarded)
        An interceptor can call this method with the value true, and the connection will be closed when it is returned to the pool.
        discarded - - only valid value is true
        java.lang.IllegalStateException - if this method is called with the value false and the value true has already been set.
      • setLastValidated

        public void setLastValidated​(long lastValidated)
        Set the timestamp the connection was last validated. This flag is used to keep track when we are using a validation-interval.
        lastValidated - a timestamp as defined by System.currentTimeMillis()
      • setPoolProperties

        public void setPoolProperties​(PoolConfiguration poolProperties)
        Sets the pool configuration for this connection and connection pool. Object is shared with the ConnectionPool
        poolProperties - The pool properties
      • isDiscarded

        public boolean isDiscarded()
        Returns the discarded flag.
        Specified by:
        isDiscarded in interface PooledConnectionMBean
        the discarded flag. If the value is true, either disconnect(boolean) has been called or it will be called when the connection is returned to the pool.
      • getLastValidated

        public long getLastValidated()
        Returns the timestamp of the last successful validation query execution.
        Specified by:
        getLastValidated in interface PooledConnectionMBean
        the timestamp of the last successful validation query execution as defined by System.currentTimeMillis()
      • getPoolProperties

        public PoolConfiguration getPoolProperties()
        Returns the configuration for this connection and pool
        the configuration for this connection and pool
      • unlock

        public void unlock()
        Unlocks the connection only if the sweeper is enabled Otherwise this is a noop for performance
      • getConnection

        public java.sql.Connection getConnection()
        Returns the underlying connection
        the underlying JDBC connection as it was returned from the JDBC driver
        See Also:
      • getXAConnection

        public javax.sql.XAConnection getXAConnection()
        Returns the underlying XA connection
        the underlying XA connection as it was returned from the Datasource
      • getLastConnected

        public long getLastConnected()
        Returns the timestamp of when the connection was last connected to the database. ie, a successful call to Driver.connect(String, java.util.Properties).
        Specified by:
        getLastConnected in interface PooledConnectionMBean
        the timestamp when this connection was created as defined by System.currentTimeMillis()
      • getHandler

        public JdbcInterceptor getHandler()
        Returns the first handler in the interceptor chain
        the first interceptor for this connection
      • toString

        public java.lang.String toString()
        toString in class java.lang.Object
      • isReleased

        public boolean isReleased()
        Returns true if this connection has been released and wont be reused.
        Specified by:
        isReleased in interface PooledConnectionMBean
        true if the method release() has been called
      • getAttributes

        public java.util.HashMap<java.lang.Object,​java.lang.Object> getAttributes()
      • createMBean

        public void createMBean()
      • getObjectName

        public getObjectName()
      • isClosed

        public boolean isClosed()
                         throws java.sql.SQLException
        Specified by:
        isClosed in interface PooledConnectionMBean
      • getAutoCommit

        public boolean getAutoCommit()
                              throws java.sql.SQLException
        Specified by:
        getAutoCommit in interface PooledConnectionMBean
      • getCatalog

        public java.lang.String getCatalog()
                                    throws java.sql.SQLException
        Specified by:
        getCatalog in interface PooledConnectionMBean
      • isReadOnly

        public boolean isReadOnly()
                           throws java.sql.SQLException
        Specified by:
        isReadOnly in interface PooledConnectionMBean
      • getSchema

        public java.lang.String getSchema()
                                   throws java.sql.SQLException
        Specified by:
        getSchema in interface PooledConnectionMBean