Suny kk
2011-01-20 11:16:17 UTC
Hi,
I've facing "Too many connections" issue and following are my DBCP
settings...
#####################################
# DBCP Connection Pool Settings
#####################################
# The connection properties that will be sent to our JDBC driver when
# establishing new connections.
dbcp.connectionProperties=""
# The default auto-commit state of connections created by this pool.
# [Default: true]
dbcp.defaultAutoCommit=true
# The default read-only state of connections created by this pool. If not
set
# then the setReadOnly method will not be called.
#dbcp.defaultReadOnly=
# The default catalog of connections created by this pool.
#dbcp.defaultCatalog=
# The initial number of connections that are created when the pool is
started.
# [Default: 0]
dbcp.initialSize=10
# The maximum number of active connections that can be allocated
# from this pool at the same time, or negative for no limit. [Default: 8]
dbcp.maxActive=500
# The maximum number of connections that can remain idle in the pool,
# without extra ones being released, or negative for no limit. [Default: 8]
dbcp.maxIdle=8
# The minimum number of connections that can remain idle in the pool,
without
# extra ones being created, or zero to create none. [Default: 0]
dbcp.minIdle=0
# 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 -1 to wait indefinitely. [Default: -1]
dbcp.maxWait=30000
# The SQL query that will be used to validate connections from this pool
before
# returning them to the caller. If specified, this query MUST be an SQL
SELECT
# statement that returns at least one row.
dbcp.validationQuery=SELECT 1
# The indication of whether objects will be validated before being borrowed
# from the pool. If the object fails to validate, it will be dropped from
the
# pool, and we will attempt to borrow another. [Default: true]
#
# NOTE - for a true value to have any effect, the validationQuery parameter
# must be set to a non-null string.
dbcp.testOnBorrow=true
# The indication of whether objects will be validated before being returned
to
# the pool. [Default: false]
#
# NOTE - for a true value to have any effect, the validationQuery parameter
# must be set to a non-null string.
dbcp.testOnReturn=false
# The indication of whether objects will be validated by the idle object
# evictor (if any). If an object fails to validate, it will be dropped from
the
# pool. [Default: false]
#
# NOTE - for a true value to have any effect, the validationQuery parameter
# must be set to a non-null string.
dbcp.testWhileIdle=false
# The number of milliseconds to sleep between runs of the idle object
evictor
# thread. When non-positive, no idle object evictor thread will be run.
# [Default: -1]
dbcp.timeBetweenEvictionRunsMillis=-1
# The number of objects to examine during each run of the idle object
evictor
# thread (if any). [Default: 3]
dbcp.numTestsPerEvictionRun=3
# 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).
# [Default: 180000 (30 min)]
dbcp.minEvictableIdleTimeMillis=180000
# A Collection of SQL statements that will be used to initialize physical
# connections when they are first created. These statements are executed
# only once - when the configured connection factory creates the connection.
# [Default: null]
#dbcp.connectionInitSqls=
# Enable prepared statement pooling for this pool. [Default: false]
dbcp.poolPreparedStatements=true
# The maximum number of open statements that can be allocated from the
# statement pool at the same time, or zero for no limit. [Default: 0]
dbcp.maxOpenPreparedStatements=25
# Controls if the PoolGuard allows access to the underlying connection.
# [Default: false]
dbcp.accessToUnderlyingConnectionAllowed=false
# Flag to remove abandoned connections if they exceed the
# removeAbandonedTimout. If set to true a connection is considered abandoned
# and eligible for removal if it has been idle longer than the
# removeAbandonedTimeout. Setting this to true can recover db connections
from
# poorly written applications which fail to close a connection.
# [Default: false]
dbcp.removeAbandoned=false
# Timeout in seconds before an abandoned connection can be removed.
# [Default: 300]
dbcp.removeAbandonedTimeout=300
# Flag to log stack traces for application code which abandoned a Statement
or
# Connection. Logging of abandoned Statements and Connections adds overhead
for
# every Connection open or new Statement because a stack trace has to be
# generated. [Default: false]
dbcp.logAbandoned=false
I've facing "Too many connections" issue and following are my DBCP
settings...
#####################################
# DBCP Connection Pool Settings
#####################################
# The connection properties that will be sent to our JDBC driver when
# establishing new connections.
dbcp.connectionProperties=""
# The default auto-commit state of connections created by this pool.
# [Default: true]
dbcp.defaultAutoCommit=true
# The default read-only state of connections created by this pool. If not
set
# then the setReadOnly method will not be called.
#dbcp.defaultReadOnly=
# The default catalog of connections created by this pool.
#dbcp.defaultCatalog=
# The initial number of connections that are created when the pool is
started.
# [Default: 0]
dbcp.initialSize=10
# The maximum number of active connections that can be allocated
# from this pool at the same time, or negative for no limit. [Default: 8]
dbcp.maxActive=500
# The maximum number of connections that can remain idle in the pool,
# without extra ones being released, or negative for no limit. [Default: 8]
dbcp.maxIdle=8
# The minimum number of connections that can remain idle in the pool,
without
# extra ones being created, or zero to create none. [Default: 0]
dbcp.minIdle=0
# 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 -1 to wait indefinitely. [Default: -1]
dbcp.maxWait=30000
# The SQL query that will be used to validate connections from this pool
before
# returning them to the caller. If specified, this query MUST be an SQL
SELECT
# statement that returns at least one row.
dbcp.validationQuery=SELECT 1
# The indication of whether objects will be validated before being borrowed
# from the pool. If the object fails to validate, it will be dropped from
the
# pool, and we will attempt to borrow another. [Default: true]
#
# NOTE - for a true value to have any effect, the validationQuery parameter
# must be set to a non-null string.
dbcp.testOnBorrow=true
# The indication of whether objects will be validated before being returned
to
# the pool. [Default: false]
#
# NOTE - for a true value to have any effect, the validationQuery parameter
# must be set to a non-null string.
dbcp.testOnReturn=false
# The indication of whether objects will be validated by the idle object
# evictor (if any). If an object fails to validate, it will be dropped from
the
# pool. [Default: false]
#
# NOTE - for a true value to have any effect, the validationQuery parameter
# must be set to a non-null string.
dbcp.testWhileIdle=false
# The number of milliseconds to sleep between runs of the idle object
evictor
# thread. When non-positive, no idle object evictor thread will be run.
# [Default: -1]
dbcp.timeBetweenEvictionRunsMillis=-1
# The number of objects to examine during each run of the idle object
evictor
# thread (if any). [Default: 3]
dbcp.numTestsPerEvictionRun=3
# 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).
# [Default: 180000 (30 min)]
dbcp.minEvictableIdleTimeMillis=180000
# A Collection of SQL statements that will be used to initialize physical
# connections when they are first created. These statements are executed
# only once - when the configured connection factory creates the connection.
# [Default: null]
#dbcp.connectionInitSqls=
# Enable prepared statement pooling for this pool. [Default: false]
dbcp.poolPreparedStatements=true
# The maximum number of open statements that can be allocated from the
# statement pool at the same time, or zero for no limit. [Default: 0]
dbcp.maxOpenPreparedStatements=25
# Controls if the PoolGuard allows access to the underlying connection.
# [Default: false]
dbcp.accessToUnderlyingConnectionAllowed=false
# Flag to remove abandoned connections if they exceed the
# removeAbandonedTimout. If set to true a connection is considered abandoned
# and eligible for removal if it has been idle longer than the
# removeAbandonedTimeout. Setting this to true can recover db connections
from
# poorly written applications which fail to close a connection.
# [Default: false]
dbcp.removeAbandoned=false
# Timeout in seconds before an abandoned connection can be removed.
# [Default: 300]
dbcp.removeAbandonedTimeout=300
# Flag to log stack traces for application code which abandoned a Statement
or
# Connection. Logging of abandoned Statements and Connections adds overhead
for
# every Connection open or new Statement because a stack trace has to be
# generated. [Default: false]
dbcp.logAbandoned=false