Can you tell me how to configure the database driver in Cocoon2 in order to connect to my postgres database named "dtw". The following first XSP code is working perfectly well under Cocoon1 :
<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<?xml-stylesheet type="text/xsl" href="step1.xsl"?>
<?cocoon-process type="xslt"?>
<xsp:page language="java"
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
>
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
>
<page>
<!-- Recuperation of the member's image paths corresponding to one of his websites
so that we put into the svg the link of the images that have already been stored in the database -->
so that we put into the svg the link of the images that have already been stored in the database -->
<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:dburl>jdbc:postgresql://localhost:5432/dtw</esql:dburl>
<esql:username>postgres</esql:username>
<esql:password></esql:password>
<esql:execute-query>
<esql:query>
SELECT url_name,urlextension_name,url_path,imagepath_relativepath,imagepath_filename,fileextension_name FROM url,urlextension,imagepath,fileextension WHERE (url.url_id = '1' AND urlextension_name='com') ;
</esql:query>
<esql:results>
<esql:row-results>
<images>
<url_name><esql:get-string column="url_name"/></url_name>
<urlextension_name><esql:get-string column="urlextension_name"/></urlextension_name>
<url_path><esql:get-string column="url_path"/></url_path>
<imagepath_relativepath><esql:get-string column="imagepath_relativepath"/></imagepath_relativepath>
<imagepath_filename><esql:get-string column="imagepath_filename"/></imagepath_filename>
<fileextension_name><esql:get-string column="fileextension_name"/></fileextension_name>
</images>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
<rastermap_path>c:\plan.gif</rastermap_path>
</page>
</xsp:page>
The following code failed under Cocoon2 :
<?xml version="1.0"?>
<xsp:page language="java"
xmlns:xsp="http://apache.org/xsp"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
>
xmlns:xsp="http://apache.org/xsp"
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: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>
Could you please tell me what's wrong, and what files do i need to change (cocoon.xconf ...).
Thanks.
Eric Vernichon
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting.
