<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Deiverson Silveira wrote:
<blockquote
cite="mid:7bdbbd4e0907080739l580304f4ve06a1d41049fa59@mail.gmail.com"
type="cite">
<pre wrap="">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.
</pre>
</blockquote>
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.<br>
<br>
There was a discussion about this a while ago, sadly I don't know the
title of that thread anymore.<br>
<br>
Please try to search the list archives, or maybe somebody else can give
further information about this.<br>
<br>
Regards<br>
Christian<br>
<blockquote
cite="mid:7bdbbd4e0907080739l580304f4ve06a1d41049fa59@mail.gmail.com"
type="cite">
<pre wrap="">
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
</pre>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
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
<a class="moz-txt-link-freetext" href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</a></pre>
</blockquote>
<br>
</body>
</html>