Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 11776

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
I agree. Here's the link:
subject: Cocoon: No valid JdbcConnection class available
It's not a secret anymore!