cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Olivier Billard <obill...@rennes.jouve.fr>
Subject Re: AW: ESQL / Excalibur Datasource bug ?
Date Tue, 28 Oct 2003 14:42:27 GMT
Thanks, again Guillaume, but this seems to come from deeeeeper inside :)
I just call datasource.getConnection() or just use the esql stylesheet. In this last case,

  the getAutoCommit() cause this error.


On 28/10/2003 15:30, Canavaggio Guillaume ZFF PA-K wrote:

> your request in SQL needs reformulating
> votre requête SQL a besoin d'être reformulée
> 
> -----Ursprüngliche Nachricht-----
> Von: Olivier Billard [mailto:obillard@rennes.jouve.fr] 
> Gesendet: Dienstag, 28. Oktober 2003 15:10
> An: users@cocoon.apache.org
> Betreff: ESQL / Excalibur Datasource bug ?
> 
> 
> 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(OraclePreparedState
> ment.java:608)
>    at 
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
> ent.java:536)
>    at 
> org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.isClosed(Abstr
> actJdbcConnection.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(Abstrac
> tJdbcConnection.java:357)
>    at $Proxy2.isClosed(Unknown Source)
>    at 
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.va
> lidatePoolable(ResourceLimitingJdbcConnectionPool.java:159)
>    at 
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(Validated
> ResourceLimitingPool.java:141)
> 	at 
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getCon
> nection(ResourceLimitingJdbcDataSource.java:222)
> 	at 
> org.apache.cocoon.components.language.markup.xsp.Cocoon2EsqlConnection.getCo
> nnection(Cocoon2EsqlConnection.java:99)
> 	at 
> org.apache.cocoon.components.language.markup.xsp.AbstractEsqlConnection.getA
> utoCommit(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(ServerPagesGenera
> tor.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


Mime
View raw message