db connection pool
Hello ! I have trying to work with Cocoon 2 db connections pool Cocoon2 2.0.2-dev JDK 1.4 Oracle8i 1) init-param param-nameload-class/param-name param-value oracle.jdbc.driver.OracleDriver /param-value /init-param 2) datasources jdbc name=MyConnectionName pool-controller min=5 max=10/ dburljdbc:oracle:thin:@localhost:1521:mydatabase/dburl usermylogin/user passwordmyPassword/password /jdbc /datasources After loading Cocoon, database connections are initiated, but in log I see this : DEBUG (2002-03-15) 09:31.33:956 [core.oracle] (Unknown-URI) Unknown-thread/LogKitLogger: factory created class was null so a new instance could not be created. org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid Jdbc Connection class available at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance (JdbcConnectionFactory.java:183) at org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.j ava:82) at org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(Ha rdResourceLimitingPool.java:95) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(Jd bcConnectionPool.java:74) at org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool. java:126) at org.apache.avalon.excalibur.pool.HardResourceLimitingPool.internalGrow(H ardResourceLimitingPool.java:104) at org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResou rceLimitingPool.java:91) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnec tionPool.java:195) at java.lang.Thread.run(Thread.java:536) FATAL_E (2002-03-15) 09:31.33:956 [core.oracle] (Unknown-URI) Unknown-thread/LogKitLogger: Excalibur could not create any connections. Examine your settings to make sure they are correct. Make sure you can connect with the same settings on your machine. But connections are present in database. The settings are correct, because I can acces database from xsp ... esql:connection esql:driveroracle.jdbc.driver.OracleDriver/esql:driver And so on. Can anybody help me, please ? With respect, Sozonnik Andrew. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: db connection pool
Moved back to JDK 1.3.1 - all works fine. With respect, Sozonnik Andrew. -Original Message- From: Sozonnik Andrew [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 12:36 PM To: [EMAIL PROTECTED] Subject: db connection pool Hello ! I have trying to work with Cocoon 2 db connections pool Cocoon2 2.0.2-dev JDK 1.4 Oracle8i 1) init-param param-nameload-class/param-name param-value oracle.jdbc.driver.OracleDriver /param-value /init-param 2) datasources jdbc name=MyConnectionName pool-controller min=5 max=10/ dburljdbc:oracle:thin:@localhost:1521:mydatabase/dburl usermylogin/user passwordmyPassword/password /jdbc /datasources After loading Cocoon, database connections are initiated, but in log I see this : DEBUG (2002-03-15) 09:31.33:956 [core.oracle] (Unknown-URI) Unknown-thread/LogKitLogger: factory created class was null so a new instance could not be created. org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid Jdbc Connection class available at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance (JdbcConnectionFactory.java:183) at org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.j ava:82) at org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(Ha rdResourceLimitingPool.java:95) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(Jd bcConnectionPool.java:74) at org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool. java:126) at org.apache.avalon.excalibur.pool.HardResourceLimitingPool.internalGrow(H ardResourceLimitingPool.java:104) at org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResou rceLimitingPool.java:91) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnec tionPool.java:195) at java.lang.Thread.run(Thread.java:536) FATAL_E (2002-03-15) 09:31.33:956 [core.oracle] (Unknown-URI) Unknown-thread/LogKitLogger: Excalibur could not create any connections. Examine your settings to make sure they are correct. Make sure you can connect with the same settings on your machine. But connections are present in database. The settings are correct, because I can acces database from xsp ... esql:connection esql:driveroracle.jdbc.driver.OracleDriver/esql:driver And so on. Can anybody help me, please ? With respect, Sozonnik Andrew. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: db connection pool
Sozonnik Andrew wrote: Moved back to JDK 1.3.1 - all works fine. In JDK 1.4, the classes for JDBC access were changed. As a result, the DB connection code *must* be compiled with a JDK 1.4 compiler. I have tested the database connection code under JDK 1.4, though I admit that I did not test it against the Oracle database. It is *possible* that the Oracle driver does not work under JDK 1.4, though if you used the old style ESQL values and got things working I suspect it is the fact that the pooling code needed to be recompiled. With respect, Sozonnik Andrew. -Original Message- From: Sozonnik Andrew [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 12:36 PM To: [EMAIL PROTECTED] Subject: db connection pool Hello ! I have trying to work with Cocoon 2 db connections pool Cocoon2 2.0.2-dev JDK 1.4 Oracle8i 1) init-param param-nameload-class/param-name param-value oracle.jdbc.driver.OracleDriver /param-value /init-param 2) datasources jdbc name=MyConnectionName pool-controller min=5 max=10/ dburljdbc:oracle:thin:@localhost:1521:mydatabase/dburl usermylogin/user passwordmyPassword/password /jdbc /datasources After loading Cocoon, database connections are initiated, but in log I see this : DEBUG (2002-03-15) 09:31.33:956 [core.oracle] (Unknown-URI) Unknown-thread/LogKitLogger: factory created class was null so a new instance could not be created. org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid Jdbc Connection class available at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance (JdbcConnectionFactory.java:183) at org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.j ava:82) at org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(Ha rdResourceLimitingPool.java:95) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(Jd bcConnectionPool.java:74) at org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool. java:126) at org.apache.avalon.excalibur.pool.HardResourceLimitingPool.internalGrow(H ardResourceLimitingPool.java:104) at org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResou rceLimitingPool.java:91) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnec tionPool.java:195) at java.lang.Thread.run(Thread.java:536) FATAL_E (2002-03-15) 09:31.33:956 [core.oracle] (Unknown-URI) Unknown-thread/LogKitLogger: Excalibur could not create any connections. Examine your settings to make sure they are correct. Make sure you can connect with the same settings on your machine. But connections are present in database. The settings are correct, because I can acces database from xsp ... esql:connection esql:driveroracle.jdbc.driver.OracleDriver/esql:driver And so on. Can anybody help me, please ? With respect, Sozonnik Andrew. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]