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