You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Alexandre Odoni <al...@ebs.com.br> on 2000/09/14 15:54:43 UTC
HELP !!!
hello.
i'm using cocoon on my work and it rules !!
now, i have a problem when i try to retrieve some data from my database.
i'm using a ODBC connection and it returns only this :
select razao from afvcadastro
my xml file is this :
<?xml version="1.0"?>
<?cocoon-process type="sql"?>
<?cocoon-format type="text/xml"?>
<page>
<connectiondefs>
<connection name="AFV">
<driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
<dburl>jdbc:odbc:"AFV"</dburl>
<username>sa</username>
<password>ebs</password>
</connection>
</connectiondefs>
<query connection="AFV">select razao from afvcadastro</query>
</page>
what am i doing wrong ???
Re: HELP !!!
Posted by Alexandre Odoni <al...@ebs.com.br>.
Sorry, but it still doesn´t work.
Anybody else knows what am i doing wrong ???
The SQL simply dooesn´t work !
It allways returns the query !!!
----- Original Message -----
From: "Gabi Brysch" <br...@inxnet.de>
To: <co...@xml.apache.org>
Sent: Thursday, September 14, 2000 11:13 AM
Subject: AW: HELP !!!
> hi,
>
> i don't have much experiences with cocoon and that's just a sample program
> but it works...
> i tried it on an win2000 platform/apache/tomcat/cocoon1.7.4.
>
> maybe the syntax might help you .. i think you have forgotten the
> <sql:execute-query> tags,
> and you don't use the namespace sql ..
>
> look through that ... just a little help :-)
>
> <xsp:page language="java"
> xmlns:xsp="http://www.apache.org/1999/XSP/Core"
> xmlns:sql="http://www.apache.org/1999/SQL">
> <page title="All Northwind Customers">
> <sql:execute-query>
> <sql:driver>sun.jdbc.odbc.JdbcOdbcDriver</sql:driver>
> <sql:dburl>jdbc:odbc:Northwind</sql:dburl>
> <sql:query>select * from Kunden where Position LIKE
> 'Vertriebsmitarbeiterin'</sql:query>
> <sql:username></sql:username>
> <sql:password></sql:password>
> <sql:null-indicator>yes</sql:null-indicator>
> <sql:doc-element>ERGEBNIS-LISTE</sql:doc-element>
> <sql:row-element>ZEILE</sql:row-element>
> </sql:execute-query>
> </page>
> </xsp:page>
>
> --------------------------------------------------------------------------
--
> ------------
> -----Ursprüngliche Nachricht-----
> Von: Alexandre Odoni [mailto:alexandre@ebs.com.br]
> Gesendet: Thursday, September 14, 2000 3:55 PM
> An: cocoon-users@xml.apache.org
> Betreff: HELP !!!
>
>
> hello.
> i'm using cocoon on my work and it rules !!
> now, i have a problem when i try to retrieve some data from my database.
> i'm using a ODBC connection and it returns only this :
>
> select razao from afvcadastro
>
> my xml file is this :
>
> <?xml version="1.0"?>
>
> <?cocoon-process type="sql"?>
> <?cocoon-format type="text/xml"?>
>
> <page>
>
> <connectiondefs>
> <connection name="AFV">
> <driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
> <dburl>jdbc:odbc:"AFV"</dburl>
> <username>sa</username>
> <password>ebs</password>
> </connection>
> </connectiondefs>
>
> <query connection="AFV">select razao from afvcadastro</query>
>
> </page>
>
> what am i doing wrong ???
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
AW: HELP !!!
Posted by Gabi Brysch <br...@inxnet.de>.
hi,
i don't have much experiences with cocoon and that's just a sample program
but it works...
i tried it on an win2000 platform/apache/tomcat/cocoon1.7.4.
maybe the syntax might help you .. i think you have forgotten the
<sql:execute-query> tags,
and you don't use the namespace sql ..
look through that ... just a little help :-)
<xsp:page language="java"
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
xmlns:sql="http://www.apache.org/1999/SQL">
<page title="All Northwind Customers">
<sql:execute-query>
<sql:driver>sun.jdbc.odbc.JdbcOdbcDriver</sql:driver>
<sql:dburl>jdbc:odbc:Northwind</sql:dburl>
<sql:query>select * from Kunden where Position LIKE
'Vertriebsmitarbeiterin'</sql:query>
<sql:username></sql:username>
<sql:password></sql:password>
<sql:null-indicator>yes</sql:null-indicator>
<sql:doc-element>ERGEBNIS-LISTE</sql:doc-element>
<sql:row-element>ZEILE</sql:row-element>
</sql:execute-query>
</page>
</xsp:page>
----------------------------------------------------------------------------
------------
-----Ursprüngliche Nachricht-----
Von: Alexandre Odoni [mailto:alexandre@ebs.com.br]
Gesendet: Thursday, September 14, 2000 3:55 PM
An: cocoon-users@xml.apache.org
Betreff: HELP !!!
hello.
i'm using cocoon on my work and it rules !!
now, i have a problem when i try to retrieve some data from my database.
i'm using a ODBC connection and it returns only this :
select razao from afvcadastro
my xml file is this :
<?xml version="1.0"?>
<?cocoon-process type="sql"?>
<?cocoon-format type="text/xml"?>
<page>
<connectiondefs>
<connection name="AFV">
<driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
<dburl>jdbc:odbc:"AFV"</dburl>
<username>sa</username>
<password>ebs</password>
</connection>
</connectiondefs>
<query connection="AFV">select razao from afvcadastro</query>
</page>
what am i doing wrong ???
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org