Gustavo,
have you already added something like this in cocoon.xconf (under the
datasources tag) ?
<jdbc name="oracle">
<pool-controller min="5" max="10" oradb="true"/>
<dburl>jdbc:oracle:thin:@localhost:1521:ORA81</dburl>
<user>login</user>
<password>password</password>
</jdbc>
Remember to re-start Tomcat afterwards any change to cocoon.xconf !
Best regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
+39 (0)744 59 85 1 Office
+39 0335 681 02 12 Mobile
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Gustavo Mejia [mailto:[EMAIL PROTECTED]]
> Sent: mercoledė 13 giugno 2001 16.16
> To: [EMAIL PROTECTED]
> Subject: Problem with my query
> Importance: High
>
>
> 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]>
>
---------------------------------------------------------------------
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]>
