[opencms-dev] problem with pool (OpenCMS 7.0.3 + JBoss 4 + Oracle 9 )

[Chirouze Olivier]

Hi,
 
Don't know if this will help but for Oracle, I figured out a few things you should notice:

. max cursor => has to be at least 500 (default Oracle value is 50!!)

. same thing for user tablespace

User tablespace should be set to 1Gbyte.

 
Olivier


________________________________

	From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Chema
	Sent: 19 December 2008 10:49
	To: opencms-dev at opencms.org
	Subject: [opencms-dev] problem with pool (OpenCMS 7.0.3 + JBoss 4 + Oracle 9 )
	
	
	Hi Everyone,
	I have a problem on Opencms. I installed Opencms 7.0.3 + JBoss 4 on the Ubuntu 7 server with Oracle 9.
	I have stressed OpenCMS until it comes out this error, and does not release connections, until it locks JBoss.
	
	Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: .
	  at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1897)
	  at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6323)
	  at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5730)
	  at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:3953)
	  ... 34 more
	Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error: Timeout waiting for idle object
	  at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:184)
	  at java.sql.DriverManager.getConnection(DriverManager.java:525)
	  at java.sql.DriverManager.getConnection(DriverManager.java:193)
	  at org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:104)
	  at org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:231)
	  at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1880)
	  ... 37 more
	Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
	  at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)
	  at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
	  ... 42 more
	15:22:54,754 WARN [CmsDriverManager] An SQL error occurred when executing the following query: .
	org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: .
	
	    Thanks for any help, 
	
	
	
	
________________________________

	Organiza y edita tus fotos con Windows Live Galería fotográfica <http://download.live.com/>