Kieran Maybe a stupid question, but are you sure the "org.gjt.mm.mysql.Driver" corresponds to the mysql driver jar you downloaded (it usually is supplied on the site where your sourced this) as I know there are a number of different drivers available.
Derek >>> [EMAIL PROTECTED] 28/07/2003 01:49:38 >>> It doesn't work from WEB-INF\lib either. I'm using a binary version. _____________________________________________ 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/> -----Original Message----- From: Geoff Howard [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 12:47 To: [EMAIL PROTECTED] Subject: Re: Cocoon and MySQL databases 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] 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] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Mailscanner thanks transtec Computers for their support. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
