Cocoon 1.8 and ESQL

[Tako Molanus <mo...@yahoo.com>]

Hi there,


I installed the newest version of cocoon 1.8 from the
Dev Snapshots ection (xml-cocoon_20010104051429.tar.gz
) today and everything seems to work just fine except
the ESQL taglib. 
Although it worked fine up to now (the last time I
installed cocoon was appr. two months ago), now I get
the following error message every time I call an XML
file using ESQL:


java.lang.NullPointerException 
at
._Apache._cocoon_1_8._cocoon_1_8._PeopleFinder._ophalen_medewerkers.populateDocument(_ophalen_medewerkers.java:456)

Any of you got any idea on what's wrong?


Thanks in advance


Tako Molanus

__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/

Re: Cocoon 1.8 and ESQL

[Werner Guttmann <We...@msdw.com>]

Donald,

I've had the same problem as Tako (after downloading the build as he did), and I went back to the esql.xml file from the
sample folder.

Here's what I am trying to get executed:

<?xml version="1.0"?>

<?cocoon-process type="xsp"?>
<?xml-logicsheet href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>
<?xml-stylesheet href="../xsl/opr-page.html.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>

<esql:connection>
  <esql:driver>com.sybase.jdbc2.jdbc.SybDriver</esql:driver>
  <esql:dburl>jdbc:sybase:Tds:pisdb3:7044/spider</esql:dburl>
  <esql:username>spideradm</esql:username>
  <esql:password>spideradm</esql:password>
  <esql:execute-query>
    <esql:query>select * from SPPoller</esql:query>
    <esql:results>
      <esql:row-results>
        <exchange>
          <id><esql:get-string column="exg"/></id>
          <site><esql:get-string column="site"/></site>
        </exchange>
      </esql:row-results>
    </esql:results>
  </esql:execute-query>
</esql:connection>

</page>

</xsp:page>

Btw, I've been using Cocoon for a couple of months now, but this is about the first time I am trying to use the esql
logicsheet. The code above is derived mainly by looking at the sample provided.

Regards
Werner

Donald Ball wrote:

> On Thu, 4 Jan 2001, Tako Molanus wrote:
>
> > Hi there,
> >
> >
> > I installed the newest version of cocoon 1.8 from the
> > Dev Snapshots ection (xml-cocoon_20010104051429.tar.gz
> > ) today and everything seems to work just fine except
> > the ESQL taglib.
> > Although it worked fine up to now (the last time I
> > installed cocoon was appr. two months ago), now I get
> > the following error message every time I call an XML
> > file using ESQL:
> >
> >
> > java.lang.NullPointerException
> > at
> > ._Apache._cocoon_1_8._cocoon_1_8._PeopleFinder._ophalen_medewerkers.populateDocument(_ophalen_medewerkers.java:456)
> >
> > Any of you got any idea on what's wrong?
>
> you're probably using the old esql schema. i updated it after 1.8 was
> released in an incompatible fashion. check out the sample in samples/sql
> to see what's changed.
>
> - donald
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org

Re: Cocoon 1.8 and ESQL

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

On Thu, 4 Jan 2001, Tako Molanus wrote:

> Hi there,
>
>
> I installed the newest version of cocoon 1.8 from the
> Dev Snapshots ection (xml-cocoon_20010104051429.tar.gz
> ) today and everything seems to work just fine except
> the ESQL taglib.
> Although it worked fine up to now (the last time I
> installed cocoon was appr. two months ago), now I get
> the following error message every time I call an XML
> file using ESQL:
>
>
> java.lang.NullPointerException
> at
> ._Apache._cocoon_1_8._cocoon_1_8._PeopleFinder._ophalen_medewerkers.populateDocument(_ophalen_medewerkers.java:456)
>
> Any of you got any idea on what's wrong?

you're probably using the old esql schema. i updated it after 1.8 was
released in an incompatible fashion. check out the sample in samples/sql
to see what's changed.

- donald