RE: avalon.excalibur ping of oracle fails

[neil]

In cocoon.xconf, the oradb attribute in 
select 1 from dual
  
If you don't specify  it defaults to "select 1", which seems to be OK for 
everything
except Oracle.

-Original Message-
From: neil [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 10 September 2002 3:23 PM
To: Cocoon-Users (E-mail)
Subject: 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
  

  http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

avalon.excalibur ping of oracle fails

[neil]

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
  

  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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>