We had the same problem (not with MySQL). Problem is that the excalibur-datasource-vm12-20021121.jar distributed with Cocoon2 does not contain the Jdbc3Connection class, which it should. Download the correct version from http://jakarta.apache.org/builds/jakarta-avalon/release/excalibur/ If you can't find the specific jar, let me know, I have a working version here so I can mail it to you directly.
Regards, Geert >>> [EMAIL PROTECTED] 07/28/03 01:47pm >>> What happens if you put the mysql jar in WEB-INF\lib? Also, is this a binary version of 2.0.4 or did you build from source? Geoff Kieran Kirwan wrote: > I'm using Apache Tomcat 4.0 and Cocoon 2.0.4. > I've got a MySQL database called 'abc' which contains a table 'TroubleTickets'. > I can view this using mySQL.exe and it appears to be fine. > > ... however I can't seem to access this from Cocoon. I'm following the steps in > 'Cocoon Developers Handbook' as follows. > > 1 Place mysql-connector-java-3.0.8-stable-bin.jar in C:\Program Files\Apache > Tomcat 4.0\common\lib > 2 Preload JDBC driver > 3 Define connection pool > 4 Create ESQL query > 5 Sitemap Entry > > > The key inputs i'm using are as follows. > > 2 Preload JDBC driver (web.xml) > <init-param> > <param-name>load-class</param-name> > <param-value> > org.gjt.mm.mysql.Driver > </param-value> > </init-param> > > > 2 Define connection pool (cocooon.xconf) > <jdbc name="abc" logger="core.datasources.abc"> > <pool-controller min="5" max="10"/> > <auto-commit>false</auto-commit> > <dburl>jdbc:mysql://localhost/abc</dburl> > <user>root</user> > <password/> > </jdbc> > > > 3 Create ESQL query (tickets.xsp) > > <?xml version="1.0" encoding="ISO-8859-1"?> > <xsp:page language="java" xmlns:xsp="http://apache.org/xsp"; > xmlns:esql="http://apache.org/cocoon/SQL/v2";> > <page> > <content> > <esql:connection> > <esql:pool>abc</esql:pool> > <esql:execute-query> > <esql:query> > select * from TroubleTickets > </esql:query> > <esql:results> > <tickets> > <esql:row-results> > <ticket> > <esql:get-columns/> > </ticket> > </esql:row-results> > </tickets> > </esql:results> > </esql:execute-query> > </esql:connection> > </content> > </page> > </xsp:page> > > > 4 Sitemap Entry > <map:match pattern="tickets"> > <map:generate type="serverpages" src="tickets.xsp"/> > <map:serialize type="xml"/> > </map:match> > > > > I'm getting an error in core.log as follows: > > DEBUG (2003-07-28) 12:07.41:467 [core.datasources.abc] > (/cocoon/traffic-xml/ticketsXML) HttpProcessor[8080][4]/JdbcConnectionFactory: > Exception in JdbcConnectionFactory.newInstance: > java.lang.ClassNotFoundException: > org.apache.avalon.excalibur.datasource.Jdbc3Connection > > Am I doing something silly? Or is this a Cocoon bug? > I also found this link: > http://archives.real-time.com/pipermail/cocoon-devel/2003-June/015269.html > > > Thanks for you help, > > Kieran > > _____________________________________________ > Kieran Kirwan > Executive Transportation Planner > Transportation Modelling Department > > Dublin Transportation Office > Hainault House, > 69/71 St. Stephen's Green, > Dublin 2, > Ireland. > Tel: +353 (0)1 4778113 > Fax: +353 (0) 1 478 5935 > website: www.dto.ie <http://www.dto.ie/> > > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > Mail Marshal for the presence of computer viruses. > > --------------------------------------------------------------------- > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
