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

Deiverson Silveira deiverson at solutioncms.com
Wed Jul 8 16:39:34 CEST 2009


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.

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

-- 
É o que você faz para as pessoas que você diz amar que realmente importa...

Deixe Deus falar ao seu coração, ouça sua voz... Ele pode realizar na sua
vida mais do você pode imaginar...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20090708/5d277d03/attachment.htm>


More information about the opencms-dev mailing list