Re: PostgreSQL and Cocoon

[defe]

Kirk Storer wrote:

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>

did you forget to <map:serialize/> just here?

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

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]