You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by neil <nb...@aisoftware.com.au> on 2002/09/10 07:23:25 UTC
avalon.excalibur ping of oracle fails
Hi,
Has anyone using oracle already solved this one?
Although my app works OK, I'm getting debug messages (shown below) indicating that the database "ping" fails
so cocoon is dicarding the connection and creating a new one.
I guess its going slower than it could due to this.
I do have
<datasources>
<jdbc ...>
<pool-controller oradb="true" ...
in my cocoon.xconf, but this doesn't seem to be finding its way into org.apache.avalon.excalibur.datasource.AbstractJdbcConnection
where it executes the query
to ping the database (a different query for oracle than for other rdbms's).
My cocoon is a snapshot of the cocoon_2_0_3_branch taken on 2002-08-16 and
has WEB-INF/lib/avalon-excalibur-vm14-20020705.jar.
The avalon-excalibur src can be examined here:
http://cvs.apache.org/viewcvs.cgi/jakarta-avalon-excalibur/datasource/src/java/org/apache/avalon/excalibur/datasource/AbstractJdbcCo
nnection.java?rev=1.16&content-type=text/vnd.viewcvs-markup
DEBUG (2002-09-10) 13:54.51:787 [core.datasources.webtest_ora] (/cocoon/pinnacle/assetDetail.xsp)
HttpProcessor[8080][1]/ResourceLimitingPool: Got a org.apache.avalon.excalibur.datasource.Jdbc3Connection from the pool.
DEBUG (2002-09-10) 13:54.51:787 [core.datasources.webtest_ora] (/cocoon/pinnacle/assetDetail.xsp)
HttpProcessor[8080][1]/AbstractJdbcConnection: Pinging database after 6910ms of inactivity.
DEBUG (2002-09-10) 13:54.51:837 [core.datasources.webtest_ora] (/cocoon/pinnacle/assetDetail.xsp)
HttpProcessor[8080][1]/AbstractJdbcConnection: Ping of connection failed.
java.sql.SQLException: ORA-00923: FROM keyword not found where expected
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314)
at org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.isClosed(AbstractJdbcConnection.java:154)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.validatePoolable(ResourceLimitingJdbcConnectionPool.java:1
08)
at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:99)
at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:174)
at
org.apache.cocoon.www.file_.C_.jakarta_tomcat_4_0_4_LE_jdk14.webapps.cocoon.pinnacle.oracle.locationAction_xsp.generate(C:\jakarta-t
omcat-4.0.4-LE-jdk14\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/file_/C_/jakarta_tomcat_4_0_4_LE_jdk14/weba
pps/cocoon/pinnacle/oracle\locationAction_xsp.java:335)
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>