C2 and postgres

Eric ... Thu, 12 Jul 2001 07:03:04 -0700

My previous message "C2 and postgres" was wrongly expressed
I reformulate it here:
------------------------------------------------
I succeeded in configuring Cocoon1 to use Postgresql but I do not succeed in doing so with Cocoon2.
Here are two xsp files.
They both aim at connecting to my postgres database, named "dtw".
The first one used to work perfectly well with Cocoon1.
The second one does not work with Cocoon2.

The only differences between both files is that:
1- the second one does not have the "<?cocoon-process type="xsp"?>" statement
2- I wrote xmlns:xsp="http://apache.org/xsp" instead of xmlns:xsp="http://www.apache.org/1999/XSP/Core"

Could you please tell me what's wrong in this second file, or do I have to modify other files (cocoon.xconf ...).
Thanks.

Eric Vernichon

Here is the the first xsp file:

-------------------------------------------------

<?xml version="1.0" encoding="ISO-8859-1"?>

<?cocoon-process type="xsp"?>

<xsp:page language="java"
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
>

<page>

<esql:connection>

     <esql:driver>org.postgresql.Driver</esql:driver>
     <esql:dburl>jdbc:postgresql://localhost:5432/dtw</esql:dburl>
     <esql:username>postgres</esql:username>
     <esql:password></esql:password>

<esql:execute-query>

<esql:query>
  SELECT enduser_id, enduser_lastname, enduser_firstname FROM enduser;
</esql:query>

<esql:results>
           <esql:row-results>
         <enduser>
     <enduser_id><esql:get-string column="enduser_id"/></enduser_id>
  <enduser_lastname><esql:get-string column="enduser_lastname"/></enduser_lastname>
  <enduser_firstname><esql:get-string column="enduser_firstname"/></enduser_firstname>
  </enduser>
           </esql:row-results>
        </esql:results>

</esql:execute-query>

</esql:connection>

</page>

</xsp:page>

-------------------------------------------------

Here is the second xsp file which fails under Cocoon2 :

------------------------------------------------

<?xml version="1.0"?>

<xsp:page language="java"
xmlns:xsp="http://apache.org/xsp"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
>
<page>