check through the logs in WEB-INF/logs and the tomcat logs as well for errors reported in instantiating the connection at startup. Typically this problem has come down to one of the following: - permissions in mysql (is your user permitted to connect from localhost/ip?) - the driver not being declared in web.xml - using cocoon built with jdk1.2/1.3 with jdk1.4 or vice versa - something else that escapes me
Any of that help? Geoff Howard > -----Original Message----- > From: Austin Tashis [mailto:[EMAIL PROTECTED] > Sent: Sunday, June 01, 2003 9:31 AM > To: [EMAIL PROTECTED] > Subject: No valid JdbcConnection class available with MySQL > > > I'm just getting started with Cocoon and trying to get the database > connectivity part working with MySQL. I set up the database, set up the > configurations in web.xml and cocoon.conf 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. > > I have also checked to see if there is a JdbcConnection class in the > classpath, and found it to be in the same jar file as the > NoValidConnectionException class that is returning the error, so I > really can't see how the JdbcConnection class could be unavailable. > > 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. > -- > Austin > ==== > "Money isn't the most important thing in the world, but it's way ahead > of whatever's in third." > --Dick Messenger > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
