Return-Path: <Werner.Guttmann@msdw.com>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 94975 invoked from network); 5 Jan 2001 16:00:02 -0000
Received: from pivsbh1.ms.com (199.89.64.103)
  by h31.sny.collab.net with SMTP; 5 Jan 2001 16:00:02 -0000
Received: (from uucp@localhost)
        by pivsbh1.ms.com (8.9.3/fw v1.30) id KAA19985
        for <cocoon-users@xml.apache.org>;
 Fri, 5 Jan 2001 10:59:44 -0500 (EST)
Received: from localhost(127.0.0.1) by pivsbh1 via smap (4.1)
	id sma.9787103641.019011; Fri, 5 Jan 01 10:59:24 -0500
Received: (from uucp@localhost)
	by pivsbh1.ms.com (8.9.3/8.9.3(vs)) id KAA18913
	for <cocoon-users@xml.apache.org>; Fri, 5 Jan 2001 10:59:24 -0500 (EST)
X-Authentication-Warning: pivsbh1.ms.com: Processed from queue
 /var/spool/mqueue-vs
X-Authentication-Warning: pivsbh1.ms.com: Processed by uucp with -C
 /etc/mail/sendmail.vs.cf
Received: from hasmh1.ms.com(138.20.197.23) by pivsbh1 via smap (4.1)
	id sma.9787103501.018072; Fri, 5 Jan 01 10:59:10 -0500
Received: from msdw.com (cw017617.morgan.com [138.20.218.52])
        by hasmh1.morgan.com (8.8.5/imap+ldap v2.4) with ESMTP id PAA05018
        for <cocoon-users@xml.apache.org>; Fri, 5 Jan 2001 15:59:10 GMT
Message-ID: <3A55EEA1.90D0532D@msdw.com>
Date: Fri, 05 Jan 2001 15:56:17 +0000
From: Werner Guttmann <Werner.Guttmann@msdw.com>
Reply-To: Werner.Guttmann@msdw.com
Organization: Morgan Stanley Dean Witter & Co.
X-Mailer: Mozilla 4.75 [en]C-CCK-MCD MS4.75 V20001029.1  (WinNT; U)
X-Accept-Language: en,ja
MIME-Version: 1.0
To: cocoon-users@xml.apache.org
Subject: Re: Cocoon 1.8 and ESQL
References: <Pine.LNX.4.30.0101041828020.14024-100000@localhost.localdomain>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

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