...In cocoon.xconf we added the parameters for the connection:
<datasources>
<jdbc name="vrgis">
<pool-controller max="10" min="5"/>
<dburl>jdbc:postgresql://192.168.9.2/vrgis</dburl>
<user>vrgis</user>
<password>sigrv</password>
</jdbc>
</datasources>
I'm not sure if this applies to your case, but
http://avalon.apache.org/excalibur/api/org/apache/avalon/excalibur/ datasource/JdbcDataSource.html
says that you need a connection-class attribute to use JDBC3 features.
Connection conn = datasource.getConnection();
For debugging, you could check what you got first:
Object obj = datasource.getConnection(); debug(obj.getClass().getName());
HTH -Bertrand
