the server is up, and all other requests work well...
It seems to come from the getAutoCommit() fonction of the ESQL Helper, or a ping request not Oracle compliant in the excalibur datasource...
On 28/10/2003 15:22, Canavaggio Guillaume ZFF PA-K wrote:
apparemment le serveur de base de donn�es ne r�pond pas apparently the database server is not responding
-----Urspr�ngliche Nachricht-----
Von: Olivier Billard [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 28. Oktober 2003 15:10
An: [EMAIL PROTECTED]
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 !
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
