Package edu.uiuc.ncsa.security.storage.sql.mysql

Class MySQLConnectionPool

java.lang.Object

edu.uiuc.ncsa.security.core.util.Pool<T>

edu.uiuc.ncsa.security.storage.sql.ConnectionPool

edu.uiuc.ncsa.security.storage.sql.mysql.MySQLConnectionPool

public class MySQLConnectionPool
extends ConnectionPool

A specific pool for working with MySQL. Since MySQL can accumulate stale connections (and not all database drivers implement an isValid method) specific machinery for testing for stale connections is included. Instantiate this as your pool when you are talking to a MySQL database.

This is now almost deprecated. improvements to the JDBC driver now do allow for testing against valid connections properly so the machinery that was here is no longer needed. This will be kept for a bit longer though will probably just be removed at some point.

Created by Jeff Gaynor
on Jun 21, 2011 at 3:18:31 PM

Field Summary

Fields inherited from class edu.uiuc.ncsa.security.storage.sql.ConnectionPool

alreadyShutdown, CONNECTION_TYPE_DEBRY, CONNECTION_TYPE_H2, CONNECTION_TYPE_MARIADB, CONNECTION_TYPE_MYSQL, CONNECTION_TYPE_POSTGRES, CONNECTION_TYPE_UNKNOWN, connectionParameters, uuid

Fields inherited from class edu.uiuc.ncsa.security.core.util.Pool

DEEP_DEBUG, INFINITE, inUse, maxSize, stack, totalCreated, totalDestroyed

Constructor Summary

Constructors

Constructor	Description
MySQLConnectionPool(SQLConnectionImpl connectionParameters)

Method Summary

Methods inherited from class edu.uiuc.ncsa.security.storage.sql.ConnectionPool

create, destroy, getCleanupInterval, getConnectionParameters, getIdelLifetime, getQueueInterval, getStackMap, getType, getUuid, isCleanupEnabled, isEnableQueue, isValid, pop, pop, push, setCleanupEnabled, setCleanupInterval, setConnectionParameters, setEnableQueue, setIdelLifetime, setQueueInterval, setStackMap, setType, setupDriverManager, shutdown

Methods inherited from class edu.uiuc.ncsa.security.core.util.Pool

doCreate, doDestroy, getMaxSize, getStack, setMaxSize, toString, trace

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLConnectionPool

public MySQLConnectionPool(SQLConnectionImpl connectionParameters)