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 .
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
In the $Cocoon_Home/WEB-INF/ directory you will find the web.xml file. Open it and look for this rows
<init-param> <param-name>load-class</param-name> <param-value> <!-- For IBM WebSphere: com.ibm.servlet.classloader.Handler ..--> |
here you have to add the following line:
<!-- For Pervasive SQL: --> com.pervasive.jdbc.v2.Driver |
search for:
<datasources>
add into this element these lines:
<jdbc name="YourPoolName"> <pool-controller min="5" max="10"/> <dburl>jdbc:pervasive://loc:5432/DB_Name</dburl> <user>YourUsername</user> <password>YourPassword</password> </jdbc> |
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:transform> <map:serialize /> </map:match> |
Obviously you have to adapt this sample to fill your need.