Your esql syntax doesn't look right. Look at the esql.xml sample in the
samples/sql directory.
-Christopher
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Problem with my query
Hi,
I am using Cocoon 1.8.2, and I am trying to run this query, but I don't
see any result
My code here :
<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<xsp:page
language="java"
xmlns:esql="http://www.apache.org/1999/SQL/v2";
xmlns:xsp="http://www.apache.org/1999/XSP/Core";
xmlns:request="http://www.apache.org/1999/XSP/Request";
>
<page title="SQL Search Results">
<esql:execute-query>
<esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
<esql:dburl>jdbc:oracle:thin:@MyIP:MyPort:cta</esql:dburl>
<esql:username>userID</esql:username>
<esql:password>Password</esql:password>
<esql:doc-element>empleados</esql:doc-element>
<esql:row-element>registro</esql:row-element>
<esql:query>select * from employee
</esql:query>
</esql:execute-query>
</page>
</xsp:page>
What I got is:
oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@MyIP:MyPort:cta userID
Password empleados registro select * from employee
Could you help me ??
Thanks
Gustavo
---------------------------------------------------------------------
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]>
