Take a look at the mm.mysql jar. The jar I downloaded for mm.mysql had all the files under another directory - so until I unzipped the files and copied them into the tomcat classes folder - I got the same error you are reporting.
marty ----- Original Message ----- From: Mauricio Souza Lima <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 18, 2001 8:36 AM Subject: Re: C2 MYSQL woes > See the logs, they will help you with info about the problem, it still > cant solve, send the part that the problem happens in the log. > > > > Sharat Koya wrote: > > > > Hi, I have been trying for the past few days to setup MySQL with C2 in > > order to use ESQL in my application. Unfortunately I can't get past the > > configuration problems. > > > > I have installed MySQL and C2 on my WinXP machine. Do I need to setup a > > driver for tomcat so that C2 can access MySQL on local host or can I get > > away with just declaring it in my ESQL code. If I don't need to setup > > the driver I tried the following code but C2 keeps returning the error > > Resource Not Found (404). > > Any help would be much appreciated. > > > > Thanks > > Sharat Koya > > > > <?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> > > > > <title>A Database Driven XSP Page</title> > > > > <content> > > > > <esql:connection> > > <esql:driver>org.gjt.mm.mysql.Driver</esql:driver> > > > > <esql:dburl>jdbc:mysql://localhost:3306/eclipse</esql:dburl> > > <esql:execute-query> > > <esql:query>select * from planet_data</esql:query> > > <esql:results> > > <esql:row-results> > > </esql:row-results> > > </esql:results> > > <esql:no-results> > > <section>Record not found</section> > > </esql:no-results> > > <esql:error-results> > > <section>Database error: <esql:get-message/> > > </section> > > </esql:error-results> > > </esql:execute-query> > > </esql:connection> > > > > </content> > > </page> > > </xsp:page> > > > > --------------------------------------------------------------------- > > Please check that your question has not already been answered in the > > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > > For additional commands, e-mail: <[EMAIL PROTECTED]> > > -- > Mauricio Souza Lima > Rational Consulting > [EMAIL PROTECTED] > Rua Helena, 140 / cj. 82 > São Paulo - SP - Brazil > Fone / Direct: +55 11 3842-7138 > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
