ClassCastException with esql

["Johnston, Nigel" <Ni...@gs.com>]

I'm getting the following exception using Esql & Cocoon 1.8. The logicsheet
definition is in cocoon.properties and it makes no difference whether I use
<esql:pool> or specify the driver directly. Any help would be greatly
appreciated.

java.lang.ClassCastException:
_opt._home._johnstn._Java._jakarta_tomcat_4_0_m5._webapps._ROOT._samples._sq
l._test
              at
org.apache.cocoon.processor.xsp.language.java.XSPJavaProcessor.load(XSPJavaP
rocessor.java:163)
              at
org.apache.cocoon.processor.xsp.XSPProcessor.loadPage(XSPProcessor.java:509)
              at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:359)
              at org.apache.cocoon.Engine.handle(Engine.java:359)
              at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
              at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
              at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:208)
              at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:251)
              at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:977)
              at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:196)
              at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:977)
              at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2038)
              at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161
)
              at
org.apache.catalina.valves.ValveBase.invokeNext(ValveBase.java:242)
              at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:414)
              at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:975)
              at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:159)
              at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:977)
              at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
811)
              at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:890)
              at java.lang.Thread.run(Thread.java:484)

The XML is:

<?xml version="1.0"?>

<?cocoon-process type="xsp"?>

<?xml-stylesheet href="oes.xsl" type="text/xsl"?>

<xsp:page
    language="java"
    xmlns:esql="http://apache.org/cocoon/SQL/v2"
    xmlns:xsp="http://www.apache.org/1999/XSP/Core"
    xmlns:context="http://www.apache.org/1999/XSP/Context"
>

<page>
<oes>
<report_type>Test</report_type>

<esql:connection>
  <esql:driver>com.sybase.jdbc2.jdbc.SybDriver</esql:driver>
<!--  <esql:dburl>jdbc:sybase:Tds:sybaseserver:5555/sybdb</esql:dburl>
  <esql:username>user</esql:username>
  <esql:password>pswd</esql:password> -->

  <esql:pool>default</esql:pool>

  <esql:execute-query>
  <esql:query>select * from aTable</esql:query>
  <esql:results>
  <esql:row-results>
      <account>
          <account_num><esql:get-string column="account_num"/></account_num>
          <account_name><esql:get-string
column="account_name"/></account_name>
      </account>
  </esql:row-results>
  </esql:results>
  <esql:no-results>
      <no_account>Account not found</no_account>
  </esql:no-results>
  </esql:execute-query>
</esql:connection>

</oes>
</page>
</xsp:page>

Re: ClassCastException with esql

[Donald Ball <ba...@webslingerZ.com>]

On Wed, 17 Jan 2001, Johnston, Nigel wrote:

> I'm getting the following exception using Esql & Cocoon 1.8. The logicsheet
> definition is in cocoon.properties and it makes no difference whether I use
> <esql:pool> or specify the driver directly. Any help would be greatly
> appreciated.

it would help if you attached the page, the generated java source code,
and the stack trace you're getting. furthermore, you claim to be using
esql from cocoon-1.8, but your sample page is using the latest esql
schema. can i assume you checked it out of cvs?

- donald