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]
