cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kirk Storer <backsst...@yahoo.com>
Subject Re: PostgreSQL and Cocoon
Date Tue, 29 Jun 2004 18:23:32 GMT
All I am getting is a page not found error.
Here is exactly what I have done:

I have varified that posgres is accessable of tcp/ip

Put the postgres jar in tomcathome/common/lib

Added to web.xml under the commented out websphere
entry:
org.postgresql.Driver

Added inside of <datasources> in cocoon.xconf:
  <jdbc name="test">
    <pool-controller min="5" max="10"/>
   
<dburl>jdbc:postgresql://localhost:5432/test</dburl>
    <user>user</user>
    <password>password</password>
  </jdbc>

Added to sitemap.xml:
             <map:match pattern="*.htm">
               <map:generate src="sql.xml"/>
               <map:transform type="sql">
                   <map:parameter
name="use-connection" value="test"/>
                   <map:parameter
name="show-nr-of-rows" value="true"/> 
                   <map:parameter name="clob-encoding"
value="UTF-8"/> 
               </map:transform>
             </map:match>

Created sql.xml: (tried with and without sql:
prefixes)
<execute-query
xmlns:sql="http://apache.org/cocoon/SQL/2.0">
  <query>
    SELECT * FROM tablename
  </query>
</execute-query>

Any help is welcomed.

Thanks,
kirk



		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

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


Mime
View raw message