JDBCConnectionPool (ATG Java API)

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

All Implemented Interfaces:

atg.core.logging.Logging, atg.core.logging.TraceLogging, 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:
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

Nested Classes
Modifier and Type	Class and Description
`class`	`JDBCConnectionPool.SQLLogging` Deprecated. A utility class which builds a separate logging interface for SQL logging to have access to.

Field Summary

Fields
Modifier and Type	Field and Description
`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

Constructors
Constructor and Description

JDBCConnectionPool()
Deprecated.

Constructs an uninitialized JDBCConnectionPool.

Constructors
Constructor and Description
`JDBCConnectionPool()` Deprecated. Constructs an uninitialized JDBCConnectionPool.

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`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, dumpCheckOutLocationsOfOpenResources, 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, isDumpCheckOutLocationsOfOpenResources, isEnabled, isWarnOnNestedCheckouts, populateSlot, pruneFreeResources, reclaimResource, resetMaxConcurrentResourcesPerThread, resetMaxConcurrentThreads, resetMaxSimultaneousResourcesOut, setBlocking, setCheckoutBlockTime, setCreationTimeLimit, setDebugConnections, setDumpCheckOutLocationsOfOpenResources, 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, toString

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, 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

Class JDBCConnectionPool

Nested Class Summary

Field Summary

Fields inherited from class atg.service.resourcepool.ResourcePool

Fields inherited from class atg.nucleus.GenericService

Fields inherited from interface atg.service.resourcepool.ResourcePoolResourceKeys

Fields inherited from interface atg.nucleus.logging.TraceApplicationLogging

Fields inherited from interface atg.nucleus.logging.ApplicationLogging

Constructor Summary

Method Summary

Methods inherited from class atg.service.resourcepool.ResourcePool

Methods inherited from class atg.nucleus.GenericService

Methods inherited from class atg.nucleus.logging.VariableArgumentApplicationLoggingImpl

Methods inherited from class java.lang.Object

Field Detail

CLASS_VERSION

mDriver

mURL

mServer

mDatabase

mUser

mPassword

Constructor Detail

JDBCConnectionPool

Method Detail

isLoggingSQLInfo

setLoggingSQLInfo

isLoggingSQLWarning

setLoggingSQLWarning

isLoggingSQLError

setLoggingSQLError

isLoggingSQLDebug

setLoggingSQLDebug

setDriver

setURL

setServer

setDatabase

setUser

setPassword

setAdditionalConnectionProperties

getDriver

getURL

getServer

getDatabase

getUser

getPassword

getAdditionalConnectionProperties

getAutoCommit

setAutoCommit

getReadOnly

setReadOnly

getInitializingSQL

setInitializingSQL

getMaxFieldSize

setMaxFieldSize

getMaxRows

setMaxRows

getQueryTimeout

setQueryTimeout

isGeneratingMonitoredConnections

getNeedsSeparateUserInfo

getPoolURL

getPoolTransURL

setNeedsSeparateUserInfo

setGeneratingMonitoredConnections

doStartService

doStopService

addConnectionPoolShutdownListener

removeConnectionPoolShutdownListener

fireShutdownEvent

createResource

destroyResource

verifyResourceValidity

checkOut

checkIn

incrementErrorCount

getErrorCount

incrementCommitCount

getCommitCount

incrementRollbackCount