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]>

Reply via email to