Hi Joe, Everything you show for the cocoon.xconf and web.xml is the same as what I'm using except for the ?autoReconnect=true which looks ok. Run a table of contents on the mysql-connector-java-3.0.8-stable-bin.jar? (verifies the com.mysql.jdbc.Driver or org.gjt.mm.mysql.Driver to be used)
Geoff is right about the jdk versions being an issue about the time of 2.0.4. > When you add the excalibur-datasource-1.1.1.jar to the WEB-INF/lib what > other changes do you have to make? Or do I even need to have that jar since > I went back to J2SDK1.3? > Your probably right that you don't need excalibur-datasource-1.1.1.jar if your using jdk1.3 but I have not verified it. ----- Original Message ----- From: "Joe Williams" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 10:53 AM Subject: Re: NEWBIE: Cannot connect to MySQL db > I am running Cocoon 2.0.4, Tomcat 4.1.18, and Apache 2 on Red Hat 8.0, and > attempting to connect to a MySQL 4.0 database. > > 1. I dropped the current MySQL connector > (mysql-connector-java-3.0.8-stable-bin.jar) into $COCOON_HOME/WEB-INF/lib > > 2. Then added this to $COCOON_HOME/WEB-INF/web.xml: > > <!-- For MySQL Driver: --> > com.mysql.jdbc.Driver > (I also tried "org.gjt.mm.mysql.Driver") > > 3. Then added the following to $COCOON_HOME/WEB-INF/cocoon.xconf in the > <datasources> > > <jdbc name="YourPoolName"> > <pool-controller min="5" max="10"/> > > <dburl>jdbc:mysql://localhost:3306/YourDatabaseName?autoReconnect=true</dbur > l> > <user>YourUsername</user> > <password>YourPassword</password> > </jdbc> > > where the user and password are for a valid MySQL user. > > 4. I got the following in $COCOON_HOME/WEB-INF/logs/error.log > > "Could not get the datasource > org.apache.avalon.excalibur.datasource.NoValidConnectionException No valid > JdbcConnection class available at > org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance > (JdbcConnectionFactory.java:185)" > > 5. After reading a number of posts on the mailing list archive, I added the > following to $COCOON_HOME/WEB-INF/lib > > excalibur-datasource-1.1.1.jar > > I also uninstalled J2SDK1.4 and installed J2SDK1.3 (And, yes, it works.) > > 7. Now I get the following in $COCOON_HOME/WEB-INF/logs/error.log > > "org.apache.cocoon.ProcessingException: Exception in > ServerPagesGenerator.generate(): java.lang.RuntimeException: Could not get > the datasource java.sql.SQLException: No suitable driver > > When you add the excalibur-datasource-1.1.1.jar to the WEB-INF/lib what > other changes do you have to make? Or do I even need to have that jar since > I went back to J2SDK1.3? > > Can anyone with a similar setup (Tomcat 4, Cocoon 2.0.4, MySQL 4.0) send a > snippet from your web.xml and cocoon.xconf? > > Any boneheaded newbie mistakes you can think of, no matter how stupid you > think they are? > > I just don't get it. > > > --------------------------------------------------------------------- > 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]
