ESQL / Excalibur Datasource bug ?

[Olivier Billard <ob...@rennes.jouve.fr>]

Hi all !

I've got the following error on the core.log, from several code portions :
datasource.getConnection and with the use of the esql stylesheet like here :

DEBUG   (2003-10-28) 15:01.49:355   [core.datasources.coperia-test] (/portal) 
PoolThread-4/AbstractJdbcConnection: Pinging database after 12297ms of inactivity.
DEBUG   (2003-10-28) 15:01.49:355   [core.datasources.coperia-test] (/portal) 
PoolThread-4/AbstractJdbcConnection: Ping of connection failed.
java.sql.SQLException: ORA-00923: Mot-clé FROM absent à l'emplacement prévu
(from french : "keyword FROM expected")
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
   at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
   at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
   at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
   at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
   at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
   at 
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
   at 
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
   at 
org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.isClosed(AbstractJdbcConnection.java:235)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:324)
   at 
org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.invoke(AbstractJdbcConnection.java:357)
   at $Proxy2.isClosed(Unknown Source)
   at 
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.validatePoolable(ResourceLimitingJdbcConnectionPool.java:159)
   at 
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:141)
	at 
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:222)
	at 
org.apache.cocoon.components.language.markup.xsp.Cocoon2EsqlConnection.getConnection(Cocoon2EsqlConnection.java:99)
	at 
org.apache.cocoon.components.language.markup.xsp.AbstractEsqlConnection.getAutoCommit(AbstractEsqlConnection.java:116)
	at 
org.apache.cocoon.www.resources.formulaires.getTypes_xsp.generate(org.apache.cocoon.www.resources.formulaires.getTypes_xsp:351)
   at 
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:260)


I'm using Oracle.
Is this a known excalibur datasource bug, or anything else ?

Thanks for your answers !

-- 
Olivier BILLARD



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org