wood burning stoves 2.0*
The moose likes JDBC and the fly likes Cocoon: No valid JdbcConnection class available Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Cocoon: No valid JdbcConnection class available" Watch "Cocoon: No valid JdbcConnection class available" New topic

Cocoon: No valid JdbcConnection class available

Austin Tashis

Joined: May 23, 2003
Posts: 19
I'm just getting started with Cocoon and trying to get the database connectivity part working with MySQL. I set up the database for the personnel example, set up the configurations and installed the MySQL driver, but when I try to run it I get the following error:
org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not get the datasource org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid JdbcConnection class available
I do have the driver in the WEB-INF/lib folder. I've tried two different versions (mm.mysql-2.0.12-bin.jar and mysql-connector-java-3.0.6-stable-bin.jar), both of which work with other Tomcat webapps on the same machine.
Here's the really weird thing: if I enter the wrong password in the datasource description in cocoon.xconf, I get an "Invalid authorization specification" error instead. It seems to me that in order to get this type of error, cocoon must be talking to the database, but that would be impossible if it had no valid JdbcConnection class, right? Or am I misunderstanding how these things work?
I'm running this on Mac OS X, 10.2.6, JDK 1.4.1, MySQL 4.0.12, Cocoon 2.0.4, Tomcat 4.1.18, Apache 1.3.27.
Andrew Monkhouse
author and jackaroo
Marshal Commander

Joined: Mar 28, 2003
Posts: 11404

Please check your private messages regarding an important administrative matter.

The Sun Certified Java Developer Exam with J2SE 5: paper version from Amazon, PDF from Apress, Online reference: Books 24x7 Personal blog
It is sorta covered in the JavaRanch Style Guide.
subject: Cocoon: No valid JdbcConnection class available
Similar Threads
unable to connect to mysql database from JSP
accesing a database
problem with mysql connecton!
Can't find JDBC driver for project in MyEclipse
How Tomcat Works: connection pooling in tomcat