I saw this a couple weeks ago too (but got errors in english) and didn't get any response from the list.
Apparently the code that pings the database to see if it is available is sending invalid SQL.
From my traces to HSQLDB it is sending "SELECT 1". It turns out that MySQLaccepts this ilformed command and responds w/o error; which is maybe why it has gotten by?
I haven't looked for a solution...yet. Steve
From: Olivier Billard <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: ESQL / Excalibur Datasource bug ? Date: Tue, 28 Oct 2003 15:10:26 +0100
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Want to check if your PC is virus-infected? Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
