Connection to postgreSQL

This document explains the specific aspect of connecting Cocoon to a Pervasive SQL Database.
For a general explanation on database connection please refer to the official documentation.

Downloading the jdbc drivers

The jdbc drivers are shipped with the normal Installation Setup. They can be found here: <install-dir>\Bin.
Drop the pvjdbc2.jar file either in $COCOON_HOME/web-inf/lib or $TOMCAT_HOME/common/lib/. I did not need to bother about the pvjdbc2x.jar

Setting Web.xml

In the $Cocoon_Home/WEB-INF/ directory you will find the web.xml file. Open it and look for this rows

 For IBM WebSphere: ..-->

here you have to add the following line:

<!--  For Pervasive SQL:   --> 

Setting cocoon.xconf

search for: <datasources> add into this element these lines:

  <jdbc name="YourPoolName">
    <pool-controller min="5" max="10"/>

Setting sitemap.xmap

When you want to use the connection you just call the jdbc name inside the pipeline in this way:

<map:match pattern="sqlquery">
  <map:generate src="sql/sqlquery.xml"/>
  <map:transform type="sql">
    <map:parameter name="use-connection" value="YourPoolName"/>
    <map:parameter name="show-nr-of-rows" value="true" />
    <map:parameter name="clob-encoding" value="UTF-8" />
  <map:serialize />

Obviously you have to adapt this sample to fill your need.


* Thanks for the Template (adopted from the author of "PostgreSQL")


* I'm getting an XML error when serializing to XML. The result-row-element has twice the same attribute. I'm not sure whether this is due to the driver, but I assume it's due to some other mistake. HTML et al. works fine.

PervasiveSQL (last edited 2009-09-20 23:41:41 by localhost)