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

[Christian Steinert]

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