org.javaWebGen.data
Class OldJDBCConnectionPool

java.lang.Object
  org.javaWebGen.util.ObjectPool
      org.javaWebGen.data.OldJDBCConnectionPool

public class OldJDBCConnectionPool
extends ObjectPool

Very Simple Database(JDBC) connction pool for keeping a pool of open database connections. This will work with any JDBC driver. Even the JDBC-ODBC Bridge. Does not require a datasource from the container

Version:

$Revision: 1.2 $

Field Summary

java.lang.String	DEFAULT_CONNECTION_SIZE
java.lang.String	DEFAULT_MAX_RETRIES
java.lang.String	DEFAULT_TIMEOUT

Constructor Summary

OldJDBCConnectionPool(PropertiesReader reader, java.lang.String defaultDriver)

OldJDBCConnectionPool(java.lang.String driver, java.lang.String dsn, java.lang.String usr, java.lang.String pwd)

Method Summary

void	close(java.sql.Connection con) return open database connection to pool
protected java.lang.Object	create() Creates a new Database connection
protected void	expire(java.lang.Object o) close database connection
java.sql.Connection	getConnection() get open database connection
protected boolean	validate(java.lang.Object o) validate to connection is still open

Methods inherited from class org.javaWebGen.util.ObjectPool

checkIn, checkOut, cleanUp, setPoolSize, setRecyleTime

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_MAX_RETRIES

public final java.lang.String DEFAULT_MAX_RETRIES

See Also:

Constant Field Values

DEFAULT_TIMEOUT

public final java.lang.String DEFAULT_TIMEOUT

See Also:

Constant Field Values

DEFAULT_CONNECTION_SIZE

public final java.lang.String DEFAULT_CONNECTION_SIZE

See Also:

Constant Field Values

Constructor Detail

OldJDBCConnectionPool

public OldJDBCConnectionPool(java.lang.String driver,
                             java.lang.String dsn,
                             java.lang.String usr,
                             java.lang.String pwd)

Parameters:

driver -

dsn -

usr -

pwd -

OldJDBCConnectionPool

public OldJDBCConnectionPool(PropertiesReader reader,
                             java.lang.String defaultDriver)

Parameters:

reader -

defaultDriver - default driver name

Method Detail

create

protected java.lang.Object create()
                           throws java.sql.SQLException

Creates a new Database connection

Specified by:

create in class ObjectPool

Returns:

new connection

Throws:

java.sql.SQLException

validate

protected boolean validate(java.lang.Object o)

validate to connection is still open

Specified by:

validate in class ObjectPool

Parameters:

o - the object to check

expire

protected void expire(java.lang.Object o)

close database connection

Specified by:

expire in class ObjectPool

Parameters:

o - the object to check

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

get open database connection

Returns:

database connection

Throws:

java.sql.SQLException

close

public void close(java.sql.Connection con)

return open database connection to pool

Parameters:

con - db connection