atg.service.resourcepool
Class JDBCConnectionPool

java.lang.Object
  atg.nucleus.logging.VariableArgumentApplicationLoggingImpl
      atg.nucleus.GenericService
          atg.service.resourcepool.ResourcePool
              atg.service.resourcepool.JDBCConnectionPool

All Implemented Interfaces:

atg.naming.AbsoluteNameable, NameContextBindingListener, NameContextElement, atg.naming.NameContextParentable, NameResolver, AdminableService, atg.nucleus.Configured, ApplicationLogging, atg.nucleus.logging.ApplicationLoggingSender, atg.nucleus.logging.TraceApplicationLogging, VariableArgumentApplicationLogging, ComponentNameResolver, Service, ServiceListener, ConnectionStats, atg.service.resourcepool.ResourcePoolResourceKeys, java.util.EventListener

Deprecated. use atg.service.jdbc.MonitoredDataSource

public class JDBCConnectionPool
extends ResourcePool
implements ConnectionStats

JDBCConnectionPool manages a pool of JDBC Connection objects. Connections from the JDBCConnectionPool can also be obtained through normal JDBC calls, so that applications can use the connection pool without knowing about this class.

The connection pool is automatically accessible as a JDBC driver with the url "jdbc:atgpool:{connectionPoolName}". Where {connectionPoolName} is the name of the component in its NameContext. For example, if the component is defined as /atg/dynamo/service/jdbc/ConnectionPool.properties, its name is URL is: "jdbc:atgpool:ConnectionPool".

In order for this feature to work, a ConnectionPoolRegistry component must exist in the same NameContext (i.e. configured from the same directory). Here is an example code snippet to retrieve a connection using the JDBC driver calls:

 Connection conn = DriverManager.getConnection ("jdbc:atgpool:ConnectionPool");
 ...
 conn.close ();
 

The close() command automatically checks the connection back into the connection pool.

In addition, a "transaction aware" JDBC driver is also created that can be accessed through the url "jdbc:atgtrans:{connectionPoolName}". When this url is used, the driver first checks to see if there is a Connection associated with the current transaction. If so, that connection is returned. Otherwise, a new Connection is checked out from the pool and associated with the transaction. When the transaction commits or aborts, the Connection is automatically committed or aborted, then checked back into the pool.

Once an application obtains a transaction-aware Connection, it must not call commit(), rollback(), or close() on that connection.

Nested Class Summary

class

JDBCConnectionPool.SQLLogging Deprecated. A utility class which builds a separate logging interface for SQL logging to have access to.

Field Summary

static java.lang.String	CLASS_VERSION Deprecated. Class version string
java.lang.String	mDatabase Deprecated. The db name.
java.lang.String	mDriver Deprecated. The class name of the JDBC driver to load.
java.lang.String	mPassword Deprecated. The db user password.
java.lang.String	mServer Deprecated. The db server name.
java.lang.String	mURL Deprecated. The JDBC URL string.
java.lang.String	mUser Deprecated. The db user to login as.

Fields inherited from class atg.service.resourcepool.ResourcePool

mBlocking, mCheckoutBlockTime, mCreatingResources, mCreationTimeLimit, mFreeResources, mHealthy, mMax, mMaxFree, mMaxPendingCreations, mMaxStartupAttempts, mMin, mPool, mResourceClassName, mStartupSleepTime, mUnusedPoolSlots

Fields inherited from class atg.nucleus.GenericService

SERVICE_INFO_KEY

Fields inherited from interface atg.service.resourcepool.ResourcePoolResourceKeys

RESOURCE_BUNDLE, RSRC_blockTimeout, RSRC_ciCreateFailure, RSRC_ciForeignResource, RSRC_ciWrongResource, RSRC_coNonRunning, RSRC_creationLimit, RSRC_creationTimeout, RSRC_failedInitialPopulation, RSRC_hitPoolMax, RSRC_maxResourcePerThread, RSRC_maxThreads, RSRC_misconfiguration, RSRC_nestedCheckout, RSRC_nonOwningThread, RSRC_notImplemented, RSRC_poolDisabled, RSRC_startupFailure, RSRC_usingClosedConnection

Fields inherited from interface atg.nucleus.logging.TraceApplicationLogging

DEFAULT_LOG_TRACE_STATUS

Fields inherited from interface atg.nucleus.logging.ApplicationLogging

DEFAULT_LOG_DEBUG_STATUS, DEFAULT_LOG_ERROR_STATUS, DEFAULT_LOG_INFO_STATUS, DEFAULT_LOG_WARNING_STATUS

Constructor Summary

JDBCConnectionPool()
Deprecated. Constructs an uninitialized JDBCConnectionPool.

Method Summary

void	addConnectionPoolShutdownListener(atg.service.resourcepool.ConnectionPoolShutdownListener newListener) Deprecated. Adds a new shutdown event listener.
void	checkIn(ResourceObject pResource) Deprecated. Checks a resource into the pool.
ResourceObject	checkOut(java.lang.String pCheckOutTag) Deprecated. Adds to the ResourcePool's checkout() an additional validity check on the outbound object, in our case to make sure that the Connection is good and open.
java.lang.Object	createResource() Deprecated. Gets a JDBC Connection.
void	destroyResource(java.lang.Object pResource) Deprecated. Closes the JDBC Connection.
void	doStartService() Deprecated. Register the driver is a connectionPoolName has been specified
void	doStopService() Deprecated. Send a shutdown event and stop the service.
protected void	fireShutdownEvent() Deprecated. Sends a ConnectionPoolShutdownEvent to all listeners.
java.util.Properties	getAdditionalConnectionProperties() Deprecated. Set of properties that should be used to create new connections.
boolean	getAutoCommit() Deprecated. Returns the flag indicating if the created Connections will be set with autoCommit on.
int	getCommitCount() Deprecated. Returns the number of times commit() has been called
int	getCreateStatementCount() Deprecated. Returns the number of times createStatement() has been called
java.lang.String	getDatabase() Deprecated. Returns the db name.
java.lang.String	getDriver() Deprecated. Returns the class name of the JDBC driver used.
int	getErrorCount() Deprecated. Returns the number of times a SQLException resulted from calls.
int	getExecuteCount() Deprecated. Returns the number of times Statement.execute() has been called
int	getExecuteQueryCount() Deprecated. Returns the number of times Statement.executeQuery() has been called
int	getExecuteUpdateCount() Deprecated. Returns the number of times Statement.executeUpdate() has been called
int	getGetMoreResultsCount() Deprecated. Returns the number of times Statement.getMoreResults() has been called
java.lang.String[]	getInitializingSQL() Deprecated. Returns the array of SQL commands that are executed upon a Connection being created
java.lang.Integer	getMaxFieldSize() Deprecated. Returns the size of the data that can be returned for any column.
java.lang.Integer	getMaxRows() Deprecated. Returns the maximum number of rows that can be returned for any query.
boolean	getNeedsSeparateUserInfo() Deprecated. Returns the flag that indicates whether this driver needs to use the special getConnection(url, user, password) form of the connection call.
java.lang.String	getPassword() Deprecated. Returns the password for the user name.
java.lang.String	getPoolTransURL() Deprecated. Returns the JDBC URL that can be used to access this pool transactionally through the JDBC DriverManager.
java.lang.String	getPoolURL() Deprecated. Returns the JDBC URL that can be used to access this pool through the JDBC DriverManager.
int	getPrepareCallCount() Deprecated. Returns the number of times prepareCall() has been called
int	getPrepareStatementCount() Deprecated. Returns the number of times prepareStatement() has been called
java.lang.Integer	getQueryTimeout() Deprecated. Returns the maximum number of seconds that the driver will wait for a Statement to execute.
boolean	getReadOnly() Deprecated. Returns the flag indicating if the created Connections will be set with readOnly on.
int	getResultSetRowCount() Deprecated. Returns the number of times ResultSet.next() has been called
int	getRollbackCount() Deprecated. Returns the number of times rollback() has been called
java.lang.String	getServer() Deprecated. Returns the db server name.
java.lang.String	getURL() Deprecated. Returns the JDBC URL.
java.lang.String	getUser() Deprecated. Returns the db user name.
void	incrementCommitCount() Deprecated. Increments the number of times commit() has been called
void	incrementCreateStatementCount() Deprecated. Increments the number of times createStatement() has been called
void	incrementErrorCount() Deprecated. Increments the number of times a SQLException resulted from calls.
void	incrementExecuteCount() Deprecated. Increments the number of times Statement.execute() has been called
void	incrementExecuteQueryCount() Deprecated. Increments the number of times Statement.executeQuery() has been called
void	incrementExecuteUpdateCount() Deprecated. Increments the number of times Statement.executeUpdate() has been called
void	incrementGetMoreResultsCount() Deprecated. Increments the number of times Statement.getMoreResults() has been called
void	incrementPrepareCallCount() Deprecated. Increments the number of times prepareCall() has been called
void	incrementPrepareStatementCount() Deprecated. Increments the number of times prepareStatement() has been called
void	incrementResultSetRowCount() Deprecated. Increments the number of times ResultSet.next() has been called
void	incrementRollbackCount() Deprecated. Increments the number of times rollback() has been called
boolean	isGeneratingMonitoredConnections() Deprecated. Returns the flag indicating whether or not this is generating monitored connections.
boolean	isLoggingSQLDebug() Deprecated. This method returns whether or not an debug log event should be broadcast for MonitoredConnections.
boolean	isLoggingSQLError() Deprecated. This method returns whether or not an error log event should be broadcast for MonitoredConnections.
boolean	isLoggingSQLInfo() Deprecated. This method returns whether or not an info log event should be broadcast for MonitoredConnections.
boolean	isLoggingSQLWarning() Deprecated. This method returns whether or not an warning log event should be broadcast for MonitoredConnections.
void	removeConnectionPoolShutdownListener(atg.service.resourcepool.ConnectionPoolShutdownListener oldListener) Deprecated. Removes a shutdown event listener.
void	setAdditionalConnectionProperties(java.util.Properties pValue) Deprecated. Set of properties that should be used to create new connections.
void	setAutoCommit(boolean pAutoCommit) Deprecated. Sets the flag indicating if the created Connections will be set with autoCommit on.
void	setDatabase(java.lang.String pDatabase) Deprecated. Sets the db name.
void	setDriver(java.lang.String pDriver) Deprecated. Sets the class name of the JDBC driver to load.
void	setGeneratingMonitoredConnections(boolean pGeneratingMonitoredConnections) Deprecated. Sets the flag indicating whether or not this is generating monitored connections.
void	setInitializingSQL(java.lang.String[] pInitializingSQL) Deprecated. Sets the array of SQL commands that are executed upon a Connection being created
void	setLoggingSQLDebug(boolean pLogging) Deprecated. Sets whether or not error log events should be logged for MonitoredConnections.
void	setLoggingSQLError(boolean pLogging) Deprecated. Sets whether or not error log events should be logged for MonitoredConnections.
void	setLoggingSQLInfo(boolean pLogging) Deprecated. Sets whether or not info log events should be logged for MonitoredConnections.
void	setLoggingSQLWarning(boolean pLogging) Deprecated. Sets whether or not warning log events should be logged for MonitoredConnections.
void	setMaxFieldSize(java.lang.Integer pMaxFieldSize) Deprecated. Sets the size of the data that can be returned for any column.
void	setMaxRows(java.lang.Integer pMaxRows) Deprecated. Sets the maximum number of rows that can be returned for any query.
void	setNeedsSeparateUserInfo(boolean pInfo) Deprecated. Sets the flag that indicates whether this driver needs to use the special getConnection(url, user, password) form of the connection call.
void	setPassword(java.lang.String pPassword) Deprecated. Sets the password associated with the user name.
void	setQueryTimeout(java.lang.Integer pQueryTimeout) Deprecated. Sets the maximum number of seconds that the driver will wait for a Statement to execute.
void	setReadOnly(boolean pReadOnly) Deprecated. Sets the flag indicating if the created Connections will be set with readOnly on.
void	setServer(java.lang.String pServer) Deprecated. Sets the db server name.
void	setURL(java.lang.String pURL) Deprecated. Sets the JDBC URL to use for opening connections.
void	setUser(java.lang.String pUser) Deprecated. Sets the user name to log into the db server as.
boolean	verifyResourceValidity(ResourceObject pResource) Deprecated. Checks to make sure that the in-coming JDBC Connection has not been closed.

Methods inherited from class atg.service.resourcepool.ResourcePool

addAdminInfo, block, createAdminServlet, finalize, getAverageResourceCreationTime, getBlocking, getCheckoutBlockTime, getCreationTimeLimit, getCurrentStack, getDebugConnections, getLastError, getMax, getMaxConcurrentResourcesPerThread, getMaxConcurrentThreads, getMaxFree, getMaxIdleAge, getMaxPendingCreations, getMaxResourceAge, getMaxResourcesPerThread, getMaxSimultaneousResourcesOut, getMaxThreadsWithResourcesOut, getMin, getNumCheckedOutResources, getNumFreeResources, getNumTotalResources, getResourceClassName, getStartupAttempts, getStartupFailureSleepTime, invalidateAllResources, isEnabled, isWarnOnNestedCheckouts, populateSlot, pruneFreeResources, reclaimResource, resetMaxConcurrentResourcesPerThread, resetMaxConcurrentThreads, resetMaxSimultaneousResourcesOut, setBlocking, setCheckoutBlockTime, setCreationTimeLimit, setDebugConnections, setLastError, setMax, setMaxFree, setMaxIdleAge, setMaxPendingCreations, setMaxResourceAge, setMaxResourcesPerThread, setMaxThreadsWithResourcesOut, setMin, setResourceClassName, setStartupAttempts, setStartupFailureSleepTime, setWarnOnNestedCheckouts, unblock

Methods inherited from class atg.nucleus.GenericService

addLogListener, getAbsoluteName, getAdminServlet, getAdminServletOutputStreamEncoding, getLoggingForVlogging, getLogListenerCount, getLogListeners, getName, getNameContext, getNucleus, getRoot, getServiceConfiguration, getServiceInfo, isAdminServletUseServletOutputStream, isLoggingDebug, isLoggingError, isLoggingInfo, isLoggingTrace, isLoggingWarning, isRunning, logDebug, logDebug, logDebug, logError, logError, logError, logInfo, logInfo, logInfo, logTrace, logTrace, logTrace, logWarning, logWarning, logWarning, nameContextElementBound, nameContextElementUnbound, removeLogListener, reResolveThis, resolveName, resolveName, resolveName, resolveName, sendLogEvent, setAdminServletOutputStreamEncoding, setAdminServletUseServletOutputStream, setLoggingDebug, setLoggingError, setLoggingInfo, setLoggingTrace, setLoggingWarning, setNucleus, setServiceInfo, startService, stopService

Methods inherited from class atg.nucleus.logging.VariableArgumentApplicationLoggingImpl

vlogDebug, vlogDebug, vlogDebug, vlogDebug, vlogDebugTrace, vlogError, vlogError, vlogError, vlogError, vlogInfo, vlogInfo, vlogInfo, vlogInfo, vlogTrace, vlogTrace, vlogTrace, vlogTrace, vlogWarning, vlogWarning, vlogWarning, vlogWarning

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

CLASS_VERSION

public static java.lang.String CLASS_VERSION

Deprecated.

Class version string

mDriver

public java.lang.String mDriver

Deprecated.

The class name of the JDBC driver to load.

mURL

public java.lang.String mURL

Deprecated.

The JDBC URL string.

mServer

public java.lang.String mServer

Deprecated.

The db server name.

mDatabase

public java.lang.String mDatabase

Deprecated.

The db name.

mUser

public java.lang.String mUser

Deprecated.

The db user to login as.

mPassword

public java.lang.String mPassword

Deprecated.

The db user password.

Constructor Detail

JDBCConnectionPool

public JDBCConnectionPool()

Deprecated.

Constructs an uninitialized JDBCConnectionPool.

Method Detail

isLoggingSQLInfo

public boolean isLoggingSQLInfo()

Deprecated.

This method returns whether or not an info log event should be broadcast for MonitoredConnections.

Returns:

boolean true if info log events should be logged
false if info log events should not be logged

setLoggingSQLInfo

public void setLoggingSQLInfo(boolean pLogging)

Deprecated.

Sets whether or not info log events should be logged for MonitoredConnections.

isLoggingSQLWarning

public boolean isLoggingSQLWarning()

Deprecated.

This method returns whether or not an warning log event should be broadcast for MonitoredConnections.

Returns:

boolean true if warning log events should be logged
false if warning log events should not be logged

setLoggingSQLWarning

public void setLoggingSQLWarning(boolean pLogging)

Deprecated.

Sets whether or not warning log events should be logged for MonitoredConnections.

isLoggingSQLError

public boolean isLoggingSQLError()

Deprecated.

This method returns whether or not an error log event should be broadcast for MonitoredConnections.

Returns:

boolean true if error log events should be logged
false if error log events should not be logged

setLoggingSQLError

public void setLoggingSQLError(boolean pLogging)

Deprecated.

Sets whether or not error log events should be logged for MonitoredConnections.

isLoggingSQLDebug

public boolean isLoggingSQLDebug()

Deprecated.

This method returns whether or not an debug log event should be broadcast for MonitoredConnections.

Returns:

boolean true if debug log events should be logged
false if debug log events should not be logged

setLoggingSQLDebug

public void setLoggingSQLDebug(boolean pLogging)

Deprecated.

Sets whether or not error log events should be logged for MonitoredConnections.

setDriver

public void setDriver(java.lang.String pDriver)

Deprecated.

Sets the class name of the JDBC driver to load. This driver name must include the full package path, e.g. foo.jdbc.Driver.

Parameters:

pDriver - the Driver

setURL

public void setURL(java.lang.String pURL)

Deprecated.

Sets the JDBC URL to use for opening connections.

Parameters:

pURL - the URL

setServer

public void setServer(java.lang.String pServer)

Deprecated.

Sets the db server name.

Parameters:

pServerName - the server name

setDatabase

public void setDatabase(java.lang.String pDatabase)

Deprecated.

Sets the db name.

Parameters:

pDatabase - the database

setUser

public void setUser(java.lang.String pUser)

Deprecated.

Sets the user name to log into the db server as.

Parameters:

pUser - the user name

setPassword

public void setPassword(java.lang.String pPassword)

Deprecated.

Sets the password associated with the user name.

Parameters:

pPassword - the password

setAdditionalConnectionProperties

public void setAdditionalConnectionProperties(java.util.Properties pValue)

Deprecated.

Set of properties that should be used to create new connections. Some drivers require additional properties be set for new connections, such as charsets for international DBs. This property will pass such a set of properties on to the DriverManager for the creation of new connections.

getDriver

public java.lang.String getDriver()

Deprecated.

Returns the class name of the JDBC driver used.

Returns:

String

getURL

public java.lang.String getURL()

Deprecated.

Returns the JDBC URL.

Returns:

String

getServer

public java.lang.String getServer()

Deprecated.

Returns the db server name.

Returns:

String

getDatabase

public java.lang.String getDatabase()

Deprecated.

Returns the db name.

Returns:

String

getUser

public java.lang.String getUser()

Deprecated.

Returns the db user name.

Returns:

String

getPassword

public java.lang.String getPassword()

Deprecated.

Returns the password for the user name.

Returns:

String

getAdditionalConnectionProperties

public java.util.Properties getAdditionalConnectionProperties()

Deprecated.

Set of properties that should be used to create new connections. Some drivers require additional properties be set for new connections, such as charsets for international DBs. This property will pass such a set of properties on to the DriverManager for the creation of new connections.

getAutoCommit

public boolean getAutoCommit()

Deprecated.

Returns the flag indicating if the created Connections will be set with autoCommit on.

setAutoCommit

public void setAutoCommit(boolean pAutoCommit)

Deprecated.

Sets the flag indicating if the created Connections will be set with autoCommit on.

getReadOnly

public boolean getReadOnly()

Deprecated.

Returns the flag indicating if the created Connections will be set with readOnly on.

setReadOnly

public void setReadOnly(boolean pReadOnly)

Deprecated.

Sets the flag indicating if the created Connections will be set with readOnly on.

getInitializingSQL

public java.lang.String[] getInitializingSQL()

Deprecated.

Returns the array of SQL commands that are executed upon a Connection being created

setInitializingSQL

public void setInitializingSQL(java.lang.String[] pInitializingSQL)

Deprecated.

Sets the array of SQL commands that are executed upon a Connection being created

getMaxFieldSize

public java.lang.Integer getMaxFieldSize()

Deprecated.

Returns the size of the data that can be returned for any column. Passed to every MonitoredConnection for use with MonitoredStatements

setMaxFieldSize

public void setMaxFieldSize(java.lang.Integer pMaxFieldSize)

Deprecated.

Sets the size of the data that can be returned for any column. Setting this to a -1 value is equivalent to disabling it.

getMaxRows

public java.lang.Integer getMaxRows()

Deprecated.

Returns the maximum number of rows that can be returned for any query. Passed to every MonitoredConnection for use with MonitoredStatements

setMaxRows

public void setMaxRows(java.lang.Integer pMaxRows)

Deprecated.

Sets the maximum number of rows that can be returned for any query.

getQueryTimeout

public java.lang.Integer getQueryTimeout()

Deprecated.

Returns the maximum number of seconds that the driver will wait for a Statement to execute. Passed to every MonitoredConnection for use with MonitoredStatements

setQueryTimeout

public void setQueryTimeout(java.lang.Integer pQueryTimeout)

Deprecated.

Sets the maximum number of seconds that the driver will wait for a Statement to execute.

isGeneratingMonitoredConnections

public boolean isGeneratingMonitoredConnections()

Deprecated.

Returns the flag indicating whether or not this is generating monitored connections. If this is generating monitored connections, then operations performed on the connections and errors are reported through this object's logging facilities.

getNeedsSeparateUserInfo

public boolean getNeedsSeparateUserInfo()

Deprecated.

Returns the flag that indicates whether this driver needs to use the special getConnection(url, user, password) form of the connection call. The oracle thin driver currently requires this to be used.

getPoolURL

public java.lang.String getPoolURL()

Deprecated.

Returns the JDBC URL that can be used to access this pool through the JDBC DriverManager.

getPoolTransURL

public java.lang.String getPoolTransURL()

Deprecated.

Returns the JDBC URL that can be used to access this pool transactionally through the JDBC DriverManager.

setNeedsSeparateUserInfo

public void setNeedsSeparateUserInfo(boolean pInfo)

Deprecated.

Sets the flag that indicates whether this driver needs to use the special getConnection(url, user, password) form of the connection call. The oracle thin driver currently requires this to be used.

setGeneratingMonitoredConnections

public void setGeneratingMonitoredConnections(boolean pGeneratingMonitoredConnections)

Deprecated.

Sets the flag indicating whether or not this is generating monitored connections. If this is generating monitored connections, then operations performed on the connections and errors are reported through this object's logging facilities.

doStartService

public void doStartService()
                    throws ServiceException

Deprecated.

Register the driver is a connectionPoolName has been specified

Overrides:

doStartService in class ResourcePool

Throws:

ServiceException - if an error occurred during the operation

doStopService

public void doStopService()
                   throws ServiceException

Deprecated.

Send a shutdown event and stop the service.

Overrides:

doStopService in class ResourcePool

Throws:

ServiceException - if an error occurred during the operation

addConnectionPoolShutdownListener

public void addConnectionPoolShutdownListener(atg.service.resourcepool.ConnectionPoolShutdownListener newListener)

Deprecated.

Adds a new shutdown event listener.

See Also:

ConnectionPoolShutdownListener, ConnectionPoolShutdownEvent

removeConnectionPoolShutdownListener

public void removeConnectionPoolShutdownListener(atg.service.resourcepool.ConnectionPoolShutdownListener oldListener)

Deprecated.

Removes a shutdown event listener.

See Also:

ConnectionPoolShutdownListener, ConnectionPoolShutdownEvent

fireShutdownEvent

protected void fireShutdownEvent()

Deprecated.

Sends a ConnectionPoolShutdownEvent to all listeners.

See Also:

ConnectionPoolShutdownListener, ConnectionPoolShutdownEvent

createResource

public java.lang.Object createResource()
                                throws ResourcePoolException

Deprecated.

Gets a JDBC Connection.

Overrides:

createResource in class ResourcePool

Returns:

Object on success

Throws:

ResourcePoolException - if there was a problem creating the JDBC connection

destroyResource

public void destroyResource(java.lang.Object pResource)

Deprecated.

Closes the JDBC Connection.

Overrides:

destroyResource in class ResourcePool

Parameters:

pResource - the Object to destroy

verifyResourceValidity

public boolean verifyResourceValidity(ResourceObject pResource)

Deprecated.

Checks to make sure that the in-coming JDBC Connection has not been closed. The ResourceObject validity flag is also checked in case the Connection was deemed unsuitable for reuse while it was checked out.

Overrides:

verifyResourceValidity in class ResourcePool

Parameters:

pResource - the ResourceObject to verify

Returns:

boolean true if the resource is still usable
false if the resource is not usable

checkOut

public ResourceObject checkOut(java.lang.String pCheckOutTag)
                        throws ResourcePoolException

Deprecated.

Adds to the ResourcePool's checkout() an additional validity check on the outbound object, in our case to make sure that the Connection is good and open.

Overrides:

checkOut in class ResourcePool

Returns:

The object or null if mConfig.mPoolMax has been reached

Throws:

ResourcePoolException - if an error occurred during the operation

checkIn

public void checkIn(ResourceObject pResource)
             throws ResourcePoolException

Deprecated.

Checks a resource into the pool.

Overrides:

checkIn in class ResourcePool

Parameters:

pResource - a resource checked out from this pool

Throws:

ResourcePoolException - if an error occurred during the operation

incrementErrorCount

public void incrementErrorCount()

Deprecated.

Increments the number of times a SQLException resulted from calls.

Specified by:

incrementErrorCount in interface ConnectionStats

getErrorCount

public int getErrorCount()

Deprecated.

Returns the number of times a SQLException resulted from calls.

incrementCommitCount

public void incrementCommitCount()

Deprecated.

Increments the number of times commit() has been called

Specified by:

incrementCommitCount in interface ConnectionStats

getCommitCount

public int getCommitCount()

Deprecated.

Returns the number of times commit() has been called

incrementRollbackCount

public void incrementRollbackCount()

Deprecated.

Increments the number of times rollback() has been called

Specified by:

incrementRollbackCount in interface ConnectionStats

getRollbackCount

public int getRollbackCount()

Deprecated.

Returns the number of times rollback() has been called

incrementCreateStatementCount

public void incrementCreateStatementCount()

Deprecated.

Increments the number of times createStatement() has been called

Specified by:

incrementCreateStatementCount in interface ConnectionStats

getCreateStatementCount

public int getCreateStatementCount()

Deprecated.

Returns the number of times createStatement() has been called

incrementPrepareStatementCount

public void incrementPrepareStatementCount()

Deprecated.

Increments the number of times prepareStatement() has been called

Specified by:

incrementPrepareStatementCount in interface ConnectionStats

getPrepareStatementCount

public int getPrepareStatementCount()

Deprecated.

Returns the number of times prepareStatement() has been called

incrementPrepareCallCount

public void incrementPrepareCallCount()

Deprecated.

Increments the number of times prepareCall() has been called

Specified by:

incrementPrepareCallCount in interface ConnectionStats

getPrepareCallCount

public int getPrepareCallCount()

Deprecated.

Returns the number of times prepareCall() has been called

incrementExecuteQueryCount

public void incrementExecuteQueryCount()

Deprecated.

Increments the number of times Statement.executeQuery() has been called

Specified by:

incrementExecuteQueryCount in interface ConnectionStats

getExecuteQueryCount

public int getExecuteQueryCount()

Deprecated.

Returns the number of times Statement.executeQuery() has been called

incrementExecuteUpdateCount

public void incrementExecuteUpdateCount()

Deprecated.

Increments the number of times Statement.executeUpdate() has been called

Specified by:

incrementExecuteUpdateCount in interface ConnectionStats

getExecuteUpdateCount

public int getExecuteUpdateCount()

Deprecated.

Returns the number of times Statement.executeUpdate() has been called

incrementExecuteCount

public void incrementExecuteCount()

Deprecated.

Increments the number of times Statement.execute() has been called

Specified by:

incrementExecuteCount in interface ConnectionStats

getExecuteCount

public int getExecuteCount()

Deprecated.

Returns the number of times Statement.execute() has been called

incrementGetMoreResultsCount

public void incrementGetMoreResultsCount()

Deprecated.

Increments the number of times Statement.getMoreResults() has been called

Specified by:

incrementGetMoreResultsCount in interface ConnectionStats

getGetMoreResultsCount

public int getGetMoreResultsCount()

Deprecated.

Returns the number of times Statement.getMoreResults() has been called

incrementResultSetRowCount

public void incrementResultSetRowCount()

Deprecated.

Increments the number of times ResultSet.next() has been called

Specified by:

incrementResultSetRowCount in interface ConnectionStats

getResultSetRowCount

public int getResultSetRowCount()

Deprecated.

Returns the number of times ResultSet.next() has been called