commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chino Aureus <chino.aur...@gmail.com>
Subject Maintaining number of connections
Date Thu, 24 Sep 2009 07:37:40 GMT
Hi,

I have this settings below.  I wish to maintain the number of connections in
case all connections are idle.  However,
what happens was dbcp evicts all connections and creates new ones.   I there
way to maintain the connections without reconnecting when idle ?

Also, I wish that dbcp will reconnect a connect in case of timeout or
SQLException while maintaining the desired number of connections which in
case below is 10:

db.datasource.driverClassName=oracle.jdbc.OracleDriver
db.datasource.url=jdbc:oracle:thin:@10.1.1.1:1521:db2
db.datasource.username=user
db.datasource.password=pass
db.datasource.initialSize=10
db.datasource.maxActive=10
db.datasource.maxIdle=10
db.datasource.minIdle=10
db.datasource.maxWait=1000
db.datasource.numTestsPerEvictionRun=10
db.datasource.maxOpenPreparedStatements=0
db.datasource.poolPreparedStatements=true
db.datasource.validationQuery=SELECT 1 from DUAL
db.datasource.testOnBorrow=true
db.datasource.testOnReturn=false
db.datasource.testWhileIdle=true
db.datasource.timeBetweenEvictionRunsMillis=10000
db.datasource.numTestsPerEvictionRun=10
db.datasource.minEvictableIdleTimeMillis=25000


Thanks,
:)

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message