[opencms-dev] CmsDbSqlException?

Dong, Roland Roland_Dong at parade.com
Wed Jun 7 17:57:31 CEST 2006


Jon,

Thanks for your reply.  We use Oracle. I don't think we have altered
anyting in opencms.properties.  

I noticed the following configuration:

# the maximum number of objects that can be borrowed from the pool
db.pool.default.maxActive=25

# the maximum amount of time before throwing an exception when the pool
is exhausted
db.pool.default.maxWait=2000

# the maximum number of objects that can sit idled in the pool
db.pool.default.maxIdle=10


And statement pooling:

# Configuration for statement pooling
########################################################################
#########
db.statements.default.pooling=true
db.statements.default.maxActive=200
db.statements.default.maxWait=2000
db.statements.default.maxIdle=100
db.statements.default.whenExhaustedAction=block

So you think it si connection pooling problems.  Change maxActive?

Thanks so much.

Roland



More information about the opencms-dev mailing list