com.dpslink.base.jdbc

Class JDBCPoolManager

java.lang.Object

com.dpslink.base.jdbc.JDBCPoolManager

All Implemented Interfaces:

java.io.Serializable

public class JDBCPoolManager
extends java.lang.Object
implements java.io.Serializable

The manager for JDBC connection pool(s). Provides the interface used by an application to obtain connections from a pool and to return connections to a pool.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
private static boolean	cvActive A flag indicating if the pools are currently active.
private static java.util.Hashtable<java.lang.String,JDBCConnectionPool>	cvPools The connection pools for the JDBCPoolManager.
private static long	serialVersionUID The class' serialization version id.

Constructor Summary

Constructors

Constructor and Description
JDBCPoolManager()

Method Summary

Modifier and Type	Method and Description
private static void	createPools() Creates the JDBCConnectionPool objects.
static void	freeConnection(JDBCConnectionInfo cninf) Returns a JDBC connection info object back to an assumed pool.
static void	freeConnection(java.lang.String name, JDBCConnectionInfo cninf) Returns a JDBC connection info object back to the specified pool.
static JDBCConnectionInfo	getConnection() Retrieves a JDBC connection info object from an assumed pool.
static JDBCConnectionInfo	getConnection(java.lang.String name) Retrieves a JDBC connection info object from the specified pool.
static java.lang.String	getConnectionConsumers(java.lang.String name) Returns a sorted list of the connection consumers associated with the connections currently in-use, suitable for display on a web page (list is delimited by <br>).
static java.lang.String	getConnectionStats(java.lang.String name) Returns a string containing information on total number of connections, number of checked out connections, and number of available ones.
static boolean	hasPools() Answers if any JDBC connection pools are configured.
static boolean	isActive() Answers if the set of JDBC connection pools being managed is active.
static boolean	isDB2e(java.lang.String name) Answers if a connection pool uses an IBM DB2 Everyplace database.
static boolean	isDB2i(java.lang.String name) Answers if a connection pool uses an IBM DB2 System i (AS/400) database.
static boolean	isDB2w(java.lang.String name) Answers if a connection pool uses an IBM DB2 Windows database.
static boolean	isDerby(java.lang.String name) Answers if a connection pool uses an Apache Derby (IBM Cloudscape) database.
private static void	loadDrivers() Loads and registers the JDBC drivers.
static void	restart() Allows the pool to process connections normally.
static void	stopAll() Shuts down the JDBC connection pools and forces the pool to to refuse further connections until restarted.

Methods inherited from class java.lang.Object

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

Field Detail

serialVersionUID

private static final long serialVersionUID

The class' serialization version id.

See Also:

Constant Field Values

cvPools

private static java.util.Hashtable<java.lang.String,JDBCConnectionPool> cvPools

The connection pools for the JDBCPoolManager.

cvActive

private static boolean cvActive

A flag indicating if the pools are currently active. If not active, no connections are allowed.

Constructor Detail

JDBCPoolManager

public JDBCPoolManager()

Method Detail

loadDrivers

private static void loadDrivers()

Loads and registers the JDBC drivers.

createPools

private static void createPools()

Creates the JDBCConnectionPool objects.

freeConnection

public static void freeConnection(JDBCConnectionInfo cninf)

Returns a JDBC connection info object back to an assumed pool. The assumed pool is the first pool in the set of pools. This method is intended as a convenience shortcut when there is only one pool in the set.

Parameters:

cninf - (JDBCConnectionInfo) The connection info object to return.

freeConnection

public static void freeConnection(java.lang.String name,
                                  JDBCConnectionInfo cninf)

Returns a JDBC connection info object back to the specified pool.

Parameters:

name - (String) A connection pool name.

cninf - (JDBCConnectionInfo) The connection info object to return.

getConnection

public static JDBCConnectionInfo getConnection()

Retrieves a JDBC connection info object from an assumed pool. The assumed pool is the first pool in the set of pools. This method is intended as a convenience shortcut when there is only one pool in the set.

Returns:

JDBCConnectionInfo - A connection info object from the pool.

getConnection

public static JDBCConnectionInfo getConnection(java.lang.String name)

Retrieves a JDBC connection info object from the specified pool.

Parameters:

name - (String) A connection pool name.

Returns:

JDBCConnectionInfo - A connection info object from the pool.

getConnectionConsumers

public static java.lang.String getConnectionConsumers(java.lang.String name)

Returns a sorted list of the connection consumers associated with the connections currently in-use, suitable for display on a web page (list is delimited by <br>).

Parameters:

name - (String) A connection pool name.

Returns:

String - The connection consumers for the connections currently being used.

getConnectionStats

public static java.lang.String getConnectionStats(java.lang.String name)

Returns a string containing information on total number of connections, number of checked out connections, and number of available ones.

Parameters:

name - (String) A connection pool name.

Returns:

String - The current connection statistics.

hasPools

public static boolean hasPools()

Answers if any JDBC connection pools are configured.

Returns:

boolean - true if pools are configured, otherwise false.

isActive

public static boolean isActive()

Answers if the set of JDBC connection pools being managed is active.

Returns:

boolean - true if the set of pools is active, otherwise false.

isDB2e

public static boolean isDB2e(java.lang.String name)

Answers if a connection pool uses an IBM DB2 Everyplace database.

Parameters:

name - (String) A connection pool name.

Returns:

boolean - true if this is a DB2 Everyplace database, otherwise false.

isDB2i

public static boolean isDB2i(java.lang.String name)

Answers if a connection pool uses an IBM DB2 System i (AS/400) database.

Parameters:

name - (String) A connection pool name.

Returns:

boolean - true if this is a DB2 System i database, otherwise false.

isDB2w

public static boolean isDB2w(java.lang.String name)

Answers if a connection pool uses an IBM DB2 Windows database.

Parameters:

name - (String) A connection pool name.

Returns:

boolean - true if this is a DB2 Windows database, otherwise false.

isDerby

public static boolean isDerby(java.lang.String name)

Answers if a connection pool uses an Apache Derby (IBM Cloudscape) database.

Parameters:

name - (String) A connection pool name.

Returns:

boolean - true if this is an Apache Derby database, otherwise false.

restart

public static void restart()

Allows the pool to process connections normally. Usually called after a stopAll().

stopAll

public static void stopAll()

Shuts down the JDBC connection pools and forces the pool to to refuse further connections until restarted.