cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Olivier Billard <obill...@rennes.jouve.fr>
Subject [SOLVED] ESQL / Excalibur Datasource bug ?
Date Tue, 28 Oct 2003 16:12:01 GMT
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message