cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Feldman, Leonid" <leonid.feld...@comverse-in.com>
Subject need help with sql procesor
Date Thu, 16 Mar 2000 17:54:32 GMT

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

Mime
View raw message