DBCP 기본 정보

잘 알아두면 좋은 것들..

http://commons.apache.org/dbcp/apidocs/org/apache/commons/dbcp/BasicDataSource.html

protected  boolean	closed
protected  List	connectionInitSqls            These SQL statements run once after a Connection is created.
protected  GenericObjectPool	connectionPool            The object pool that internally manages our connections.
protected  Properties	connectionProperties            The connection properties that will be sent to our JDBC driver when establishing new connections.
protected  DataSource	dataSource            The data source we will use to manage connections.
protected  boolean	defaultAutoCommit            The default auto-commit state of connections created by this pool.
protected  String	defaultCatalog            The default "catalog" of connections created by this pool.
protected  Boolean	defaultReadOnly            The default read-only state of connections created by this pool.
protected  int	defaultTransactionIsolation            The default TransactionIsolation state of connections created by this pool.
protected  ClassLoader	driverClassLoader            The class loader instance to use to load the JDBC driver.
protected  String	driverClassName            The fully qualified Java class name of the JDBC driver to be used.
protected  int	initialSize            The initial number of connections that are created when the pool is started.
protected  PrintWriter	logWriter            The PrintWriter to which log messages should be directed.
protected  int	maxActive            The maximum number of active connections that can be allocated from this pool at the same time, or negative for no limit.
protected  int	maxIdle            The maximum number of connections that can remain idle in the pool, without extra ones being released, or negative for no limit.
protected  int	maxOpenPreparedStatements            The maximum number of open statements that can be allocated from the statement pool at the same time, or non-positive for no limit.
protected  long	maxWait            The maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception, or <= 0 to wait indefinitely.
protected  long	minEvictableIdleTimeMillis            The minimum amount of time an object may sit idle in the pool before it is eligable for eviction by the idle object evictor (if any).
protected  int	minIdle            The minimum number of active connections that can remain idle in the pool, without extra ones being created, or 0 to create none.
protected  int	numTestsPerEvictionRun            The number of objects to examine during each run of the idle object evictor thread (if any).
protected  String	password            The connection password to be passed to our JDBC driver to establish a connection.
protected  boolean	poolPreparedStatements            Prepared statement pooling for this pool.
protected  boolean	testOnBorrow            The indication of whether objects will be validated before being borrowed from the pool.
protected  boolean	testOnReturn            The indication of whether objects will be validated before being returned to the pool.
protected  boolean	testWhileIdle            The indication of whether objects will be validated by the idle object evictor (if any).
protected  long	timeBetweenEvictionRunsMillis            The number of milliseconds to sleep between runs of the idle object evictor thread.
protected  String	url            The connection URL to be passed to our JDBC driver to establish a connection.
protected  String	username            The connection username to be passed to our JDBC driver to establish a connection.
protected  String	validationQuery            The SQL query that will be used to validate connections from this pool before returning them to the caller.
protected  int	validationQueryTimeout            Timeout in seconds before connection validation queries fail.