[opencms-dev] Urgent: Error because IOException project in production... =(

Thu Jul 9 07:55:25 CEST 2009

Does it help if you enable property db.pool.default.testQuery in
opencms.properties?

That normally helps if there is a timeout set somewhere in the network
infrastructure.

Regards,

Olli

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Christian Steinert
Sent: 08 July 2009 22:59
To: The OpenCms mailing list
Subject: Re: [opencms-dev] Urgent: Error because IOException project in
production... =(

Deiverson Silveira wrote: 

Brothers,

got a serious problem and I can´t solve.

Put the site into production and when is a time of use, gives IOException
connection.

Maybe you have a problem, that sometimes, a database connection will die,
while it is kept in the pool. You can cause opencms to re-validate
connections before using them when they are taken out of the connection
pool.

There was a discussion about this a while ago, sadly I don't know the title
of that thread anymore.

Please try to search the list archives, or maybe somebody else can give
further information about this.

Regards
Christian

The site will have on average 10,000 hits per day, I am not able to do some
configuration in opencms.properties

JDK 1.5
JBoss 4.2.1
OpenCms 7.0.5
SqlServer 2005

Is a site for the government, and various aspects are being criticized for
using free software, due to this error, I know opencms is a great software,
but I am not getting set to stay stable in production, can someone help me ?
 Deiverson Silveira

My opencms.properties is:
#
# Configuration of the driver manager
############################################################################
#####
driver.vfs=db
driver.project=db
driver.user=db
driver.history=db

#
# Declaration of database pools
############################################################################
#####
db.pools=default
#
# Configuration of the default database pool
############################################################################
#####
# name of the JDBC driver
db.pool.default.jdbcDriver=net.sourceforge.jtds.jdbc.Driver
# URL of the JDBC driver
db.pool.default.jdbcUrl=jdbc:jtds:sqlserver://xxx:1433/portal
# optional parameters for the URL of the JDBC driver
db.pool.default.jdbcUrl.params=
# user name to connect to the database
db.pool.default.user=xxx
# password to connect to the database
db.pool.default.password=xxx
# the URL to make the JDBC DriverManager return connections from the DBCP
pool
db.pool.default.poolUrl=opencms:default
#modifiquei de 50 para 500
# the maximum number of objects that can be borrowed from the pool
db.pool.default.maxActive=50
# the maximum amount of time before throwing an exception when the pool is
exhausted
db.pool.default.maxWait=2000
# the minimum number of objects that will kept connected
db.pool.default.minIdle=3
#modifiquei de 10 para 100
# the maximum number of objects that can sit idled in the pool
db.pool.default.maxIdle=10
# action to take when the pool is exhausted {grow|block|fail}
db.pool.default.whenExhaustedAction=grow
# connections will be validated before they are borrowed from the pool
db.pool.default.testOnBorrow=false
# connections will be validated by evictor thread
db.pool.default.testWhileIdle=true
# number of milliseconds to sleep between runs of the evictor thread
# -1 means no idle connection evictor thread will be run
db.pool.default.timeBetweenEvictionRuns=3600000
# number of connections tested in a run of the evictor thread
db.pool.default.numTestsPerEvictionRun=3
# minimum amount of time in milliseconds a connection may be idle in the
pool before it is eligable for eviction
db.pool.default.minEvictableIdleTime=1800000
# the query to validate connections
#db.pool.default.testQuery=SELECT STRUCTURE_ID FROM CMS_OFFLINE_STRUCTURE
WHERE RESOURCE_PATH = '/'
db.pool.default.testQuery=
#modifiquei de 100 para 1000
# number of attempts to connect to the database during startup (default =
10)
db.pool.default.connects=100
# sleep time between two attempts to connect to the database during startup
in ms (default = 5000)
db.pool.default.wait=5000
#
# Configuration for statement pooling
############################################################################
#####
db.statements.default.pooling=true
#modifiquei 200 para 2000
db.statements.default.maxActive=200000
db.statements.default.maxWait=2000
#modifiquei de 100 para 1000
db.statements.default.maxIdle=100
db.statements.default.whenExhaustedAction=grow
#
# Configuration of the database driver manager
############################################################################
#####
db.name=mssql
db.vfs.driver=org.opencms.db.mssql.CmsVfsDriver
db.vfs.pool=opencms:default
db.vfs.sqlmanager=org.opencms.db.mssql.CmsSqlManager
db.project.driver=org.opencms.db.mssql.CmsProjectDriver
db.project.pool=opencms:default
db.project.sqlmanager=org.opencms.db.mssql.CmsSqlManager
db.user.driver=org.opencms.db.mssql.CmsUserDriver
db.user.pool=opencms:default
db.user.sqlmanager=org.opencms.db.mssql.CmsSqlManager
db.history.driver=org.opencms.db.mssql.CmsHistoryDriver
db.history.pool=opencms:default
db.history.sqlmanager=org.opencms.db.mssql.CmsSqlManager
db.cos.pool=opencms:default
#
# Ethernet address used for UUID generation
# Server name used for various messages
############################################################################
#####
server.ethernet.address=15:d4:e8:c1:c4:f8
server.name=OpenCmsServer
#
# Enable/Disable OpenCms Setup Wizard
# The wizard sets the flag to false after the setup.
# To use the wizard again, reset it manually to true.
# By setting no value, wizard can always be used.
############################################################################
#####
wizard.enabled=false
#
# Enable/Disable exception thrown during servlet initialization.
# If disabled there is no attempt to reinitialize the servlet, so the
servlet
# container has to be restarted, as required by some servlet containers that
# does not like servlets throwing exceptions during initialization.
############################################################################
#####
servlet.exception.enabled=true

  _____  

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20090709/b220b42a/attachment.htm>