org.cementj.pool
Class DatabaseConnectionPool

java.lang.Object
  java.lang.Thread
      org.cementj.pool.AbstractResourcePool
          org.cementj.pool.DatabaseConnectionPool

All Implemented Interfaces:

java.lang.Runnable, ResourcePool

public class DatabaseConnectionPool
extends AbstractResourcePool

This is an implementation of a ResourcePool for JDBC database connections.

Required properties are the following:

conn.test.sql -- Test SQL select statement

conn.driver -- JDBC Driver name used to create connections.

conn.connect -- Connection string used to create connections.

conn.user -- Database userid.

conn.password -- Database password.

Copyright: Delta Vortex Technologies, 2003.

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Thread

java.lang.Thread.State, java.lang.Thread.UncaughtExceptionHandler

Field Summary

Fields inherited from class org.cementj.pool.AbstractResourcePool

DEFAULT_POOL_SIZE, DEFAULT_SLEEP_TIME

Fields inherited from class java.lang.Thread

MAX_PRIORITY, MIN_PRIORITY, NORM_PRIORITY

Constructor Summary

DatabaseConnectionPool(java.lang.String poolName, java.util.Properties creationProps)

DatabaseConnectionPool(java.lang.String poolName, java.util.Properties creationProps, int poolSize)

DatabaseConnectionPool(java.lang.String poolName, java.util.Properties creationProps, int poolSize, long sleepIntervalInMillis)

Method Summary

Resource	createResource(java.util.Properties props) Creates a new PooledConnection for the pool.
java.sql.Connection	getPooledConnection() Gets a Pooled Connection from the Resouce Pool.

Methods inherited from class org.cementj.pool.AbstractResourcePool

closeAll, getCreationProperties, getPool, getPoolName, getPoolSize, getResource, getSleepTimeInMillis, initPool, logStatus, logStatus, recycleResource, run, setCreationProperties, setPoolSize, setSleepTimeInMillis

Methods inherited from class java.lang.Thread

activeCount, checkAccess, countStackFrames, currentThread, destroy, dumpStack, enumerate, getAllStackTraces, getContextClassLoader, getDefaultUncaughtExceptionHandler, getId, getName, getPriority, getStackTrace, getState, getThreadGroup, getUncaughtExceptionHandler, holdsLock, interrupt, interrupted, isAlive, isDaemon, isInterrupted, join, join, join, resume, setContextClassLoader, setDaemon, setDefaultUncaughtExceptionHandler, setName, setPriority, setUncaughtExceptionHandler, sleep, sleep, start, stop, stop, suspend, toString, yield

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseConnectionPool

public DatabaseConnectionPool(java.lang.String poolName,
                              java.util.Properties creationProps)
                       throws ResourceException

Throws:

ResourceException

DatabaseConnectionPool

public DatabaseConnectionPool(java.lang.String poolName,
                              java.util.Properties creationProps,
                              int poolSize)
                       throws ResourceException

Throws:

ResourceException

DatabaseConnectionPool

public DatabaseConnectionPool(java.lang.String poolName,
                              java.util.Properties creationProps,
                              int poolSize,
                              long sleepIntervalInMillis)
                       throws ResourceException

Throws:

ResourceException

Method Detail

createResource

public Resource createResource(java.util.Properties props)
                        throws ResourceException

Creates a new PooledConnection for the pool. This is required.

Specified by:

createResource in interface ResourcePool

Specified by:

createResource in class AbstractResourcePool

Throws:

ResourceException

getPooledConnection

public java.sql.Connection getPooledConnection()
                                        throws ResourceException

Gets a Pooled Connection from the Resouce Pool. This method is unnecessary as the calling class could do the same thing. This just makes it easier on the calling class as it doesn't have to do as much in the way of casting.

Throws:

ResourceException