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

Thu Jul 9 11:58:32 CEST 2009

Oh, and you'd need to set db.pool.default.testOnBorrow to true.

Good luck.

  _____  

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Jonathan Woods
Sent: 09 July 2009 10:50
To: 'The OpenCms mailing list'
Subject: Re: [opencms-dev] Urgent: Error because IOException projectin
production... =(

The discussion Christian mentions may be this:

http://lists.opencms.org/pipermail/opencms-dev/2009q1/031561.html

in which you're recommended to comment back in (remove the comment from) the
populated db.pool.default.testQuery property, and comment out the empty
version.  Unfortunately, this means having access to opencms.properties...

Jon

  _____  

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/b2537f8e/attachment.htm>