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-name>load-class</param-name> > <param-value> > oracle.jdbc.driver.OracleDriver > </param-value> > </init-param> > > 2) > > <datasources> > <jdbc name="MyConnectionName"> > <pool-controller min="5" max="10"/> > <dburl>jdbc:oracle:thin:@localhost:1521:mydatabase</dburl> > <user>mylogin</user> > <password>myPassword</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:driver>oracle.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]>
