cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric ..." <ry...@hotmail.com>
Subject C2 and postgres
Date Thu, 12 Jul 2001 13:49:50 GMT
<html><DIV>My previous message "C2 and postgres" was wrongly expressed<BR>I
reformulate it here:<BR>------------------------------------------------<BR>I
succeeded in configuring Cocoon1 to use Postgresql but I do not succeed in doing so with Cocoon2.<BR>Here
are two xsp files.<BR>They both aim at connecting to my postgres database, named "dtw".<BR>The
first one used to work perfectly well with Cocoon1.<BR>The second one does not work
with Cocoon2.</DIV>
<DIV>The only differences between both files is that:<BR>1- the second one does
not have the "&lt;?cocoon-process type="xsp"?&gt;" statement<BR>2- I wrote xmlns:xsp="<A
href="http://apache.org/xsp">http://apache.org/xsp</A>" instead of xmlns:xsp="<A
href="http://www.apache.org/1999/XSP/Core">http://www.apache.org/1999/XSP/Core</A>"</DIV>
<DIV>Could you please tell me what's wrong in this second file, or do I have to modify
other files (cocoon.xconf ...).<BR>Thanks.<BR>&nbsp;<BR>Eric Vernichon</DIV>
<DIV><BR>Here is the the first xsp file:<BR>&nbsp;<BR>-------------------------------------------------</DIV>
<DIV>&lt;?xml version="1.0" encoding="ISO-8859-1"?&gt;</DIV>
<DIV>&lt;?cocoon-process type="xsp"?&gt;</DIV>
<DIV>&lt;xsp:page language="java"<BR>&nbsp; xmlns:xsp="<A href="http://www.apache.org/1999/XSP/Core">http://www.apache.org/1999/XSP/Core</A>"<BR>&nbsp;
xmlns:esql="<A href="http://apache.org/cocoon/SQL/v2">http://apache.org/cocoon/SQL/v2</A>"<BR>&gt;</DIV>
<DIV>&lt;page&gt;</DIV>
<DIV>&lt;esql:connection&gt;</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; &lt;esql:driver&gt;org.postgresql.Driver&lt;/esql:driver&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:dburl&gt;jdbc:postgresql://localhost:5432/dtw&lt;/esql:dburl&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:username&gt;postgres&lt;/esql:username&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:password&gt;&lt;/esql:password&gt;</DIV>
<DIV>&lt;esql:execute-query&gt;<BR>&nbsp;<BR>&nbsp;&lt;esql:query&gt;<BR>&nbsp;
&nbsp;&nbsp;SELECT enduser_id, enduser_lastname, enduser_firstname FROM enduser;<BR>&nbsp;&lt;/esql:query&gt;<BR>&nbsp;<BR>&nbsp;&lt;esql:results&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; &lt;esql:row-results&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&lt;enduser&gt;<BR>&nbsp;&nbsp; &nbsp;&nbsp;&lt;enduser_id&gt;&lt;esql:get-string
column="enduser_id"/&gt;&lt;/enduser_id&gt;<BR>&nbsp;&nbsp;&lt;enduser_lastname&gt;&lt;esql:get-string
column="enduser_lastname"/&gt;&lt;/enduser_lastname&gt;<BR>&nbsp;&nbsp;&lt;enduser_firstname&gt;&lt;esql:get-string
column="enduser_firstname"/&gt;&lt;/enduser_firstname&gt;<BR>&nbsp;&nbsp;&lt;/enduser&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; &lt;/esql:row-results&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/esql:results&gt;</DIV>
<DIV>&lt;/esql:execute-query&gt;</DIV>
<DIV>&lt;/esql:connection&gt;</DIV>
<DIV>&lt;/page&gt;</DIV>
<DIV>&lt;/xsp:page&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</DIV>
<DIV>-------------------------------------------------</DIV>
<DIV>Here is the second xsp file which fails under Cocoon2 :</DIV>
<DIV>------------------------------------------------<BR>&nbsp;<BR>&lt;?xml
version="1.0"?&gt;<BR>&nbsp;<BR>&lt;xsp:page language="java"<BR>&nbsp;
xmlns:xsp="<A href="http://apache.org/xsp">http://apache.org/xsp</A>"<BR>&nbsp;
xmlns:esql="<A href="http://apache.org/cocoon/SQL/v2">http://apache.org/cocoon/SQL/v2</A>"<BR>&gt;<BR>&lt;page&gt;</DIV>
<DIV>&lt;esql:connection&gt;</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; &lt;esql:driver&gt;org.postgresql.Driver&lt;/esql:driver&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:dburl&gt;jdbc:postgresql://localhost:5432/dtw&lt;/esql:dburl&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:username&gt;postgres&lt;/esql:username&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;
&lt;esql:password&gt;&lt;/esql:password&gt;</DIV>
<DIV><BR>&lt;esql:execute-query&gt;<BR>&nbsp;<BR>&nbsp;&lt;esql:query&gt;<BR>&nbsp;
&nbsp;&nbsp;SELECT enduser_id, enduser_lastname, enduser_firstname FROM enduser;<BR>&nbsp;&lt;/esql:query&gt;<BR>&nbsp;<BR>&nbsp;&lt;esql:results&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; &lt;esql:row-results&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&lt;enduser&gt;<BR>&nbsp;&nbsp; &nbsp;&nbsp;&lt;enduser_id&gt;&lt;esql:get-string
column="enduser_id"/&gt;&lt;/enduser_id&gt;<BR>&nbsp;&nbsp;&lt;enduser_lastname&gt;&lt;esql:get-string
column="enduser_lastname"/&gt;&lt;/enduser_lastname&gt;<BR>&nbsp;&nbsp;&lt;enduser_firstname&gt;&lt;esql:get-string
column="enduser_firstname"/&gt;&lt;/enduser_firstname&gt;<BR>&nbsp;&nbsp;&lt;/enduser&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; &lt;/esql:row-results&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/esql:results&gt;</DIV>
<DIV>&lt;/esql:execute-query&gt;</DIV>
<DIV>&lt;/esql:connection&gt;</DIV>
<DIV>&lt;/page&gt;</DIV>
<DIV>&lt;/xsp:page&gt;<BR>&nbsp;<BR></DIV><br clear=all><hr>Get
Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a>.<br></p></html>

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message