need help with sql procesor

["Feldman, Leonid" <le...@comverse-in.com>]

Hello.

I am having trouble getting SQL processor to work.

Cocoon 1.7
Tomcat 3.1 beta
Windows NT 4 workstation
jdk 1.2.2 ( sun )

In the following code test1 is a valid dsn 
( connected to MS SQL server 7 )

----- begin database-page.xml ----------

<?xml version="1.0"?>

<?cocoon-process type="sql"?>
<?cocoon-format type="text/xml"?>

<page>

 <connectiondefs>
  <connection name="foo_connection">
   <driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
   <dburl>jdbc:odbc:test1</dburl>
   <username>sa</username>
   <password></password>
  </connection>
 </connectiondefs> 
 
 <query connection="foo_connection">
  select subs_name from subs
 </query>
 
</page>

------ end database-page.xml ---------

subs and subs_name are valid names.
and subs has at least 12 rows.
I get the following results:

---- begin results -----

  <?xml version="1.0" encoding="UTF-8" ?> 

- <page>
- <ROWSET>
  <ROW ID="0" /> 
  <ROW ID="1" /> 
  <ROW ID="2" /> 
  <ROW ID="3" /> 
  <ROW ID="4" /> 
  <ROW ID="5" /> 
  <ROW ID="6" /> 
  <ROW ID="7" /> 
  <ROW ID="8" /> 
  <ROW ID="9" /> 
  <ROW ID="10" /> 
  </ROWSET>
  </page>
- <!--  This page was served in 791 milliseconds by Cocoon 1.7 
  --> 

------ end results ------------

Re: need help with sql procesor

[Donald Ball <ba...@webslingerZ.com>]

This is one I haven't seen before. What type is the subs_name column?

- donald

On Thu, 16 Mar 2000, Feldman, Leonid wrote:

> 
> Hello.
> 
> I am having trouble getting SQL processor to work.
> 
> Cocoon 1.7
> Tomcat 3.1 beta
> Windows NT 4 workstation
> jdk 1.2.2 ( sun )
> 
> In the following code test1 is a valid dsn 
> ( connected to MS SQL server 7 )
> 
> ----- begin database-page.xml ----------
> 
> <?xml version="1.0"?>
> 
> <?cocoon-process type="sql"?>
> <?cocoon-format type="text/xml"?>
> 
> <page>
> 
>  <connectiondefs>
>   <connection name="foo_connection">
>    <driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
>    <dburl>jdbc:odbc:test1</dburl>
>    <username>sa</username>
>    <password></password>
>   </connection>
>  </connectiondefs> 
>  
>  <query connection="foo_connection">
>   select subs_name from subs
>  </query>
>  
> </page>
> 
> ------ end database-page.xml ---------
> 
> subs and subs_name are valid names.
> and subs has at least 12 rows.
> I get the following results:
> 
> ---- begin results -----
> 
>   <?xml version="1.0" encoding="UTF-8" ?> 
> 
> - <page>
> - <ROWSET>
>   <ROW ID="0" /> 
>   <ROW ID="1" /> 
>   <ROW ID="2" /> 
>   <ROW ID="3" /> 
>   <ROW ID="4" /> 
>   <ROW ID="5" /> 
>   <ROW ID="6" /> 
>   <ROW ID="7" /> 
>   <ROW ID="8" /> 
>   <ROW ID="9" /> 
>   <ROW ID="10" /> 
>   </ROWSET>
>   </page>
> - <!--  This page was served in 791 milliseconds by Cocoon 1.7 
>   --> 
> 
> ------ end results ------------
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>