Problem : ---------
When pinging an Oracle database, the excalibur datasource cause the following error : ORA-00923: FROM keyword not found where expected
Resolution :
-------
[1] : The default ping query of the excalibur datasource is "SELECT 1", which is not valid in the Oracle SQL. It must be overriden in the cocoon.xconf :
<pool-controller min="5" max="10" keep-alive="true">
<keep-alive>SELECT 0 FROM DUAL</keep-alive>
</pool-controller>
[1]:http://avalon.apache.org/api/org/apache/avalon/excalibur/datasource/ResourceLimitingJdbcDataSource.html
-- Olivier BILLARD
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
