cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Bachta" <>
Subject RE: esql:query problem
Date Wed, 25 Jun 2003 16:50:57 GMT

That was it, thank you for the help. All of you that helped thank you.

Tim Bachta

-----Original Message-----
From: Christian Haul [] 
Sent: Wednesday, June 25, 2003 10:56 AM
Subject: Re: esql:query problem

On 25.Jun.2003 -- 10:48 AM, Tim Bachta wrote:
> Well I tried that and no error, the only problem is I get no results
> either.  I was looking at the example that I am working from

Maybe you need to add the needs-query attribute. Some drivers don't
like it if a CallableStatement is just execute()'ed and your java code
uses executeQuery(). So, try

    <esql:call needs-query="true">{call rptLocationDeviations(

      <esql:parameter direction="in"
       <esql:parameter direction="in"
       <esql:parameter direction="in"
       <test><esql:get-string column="1"/></test>

> port
> And it uses the call-results tag as well as the use-results tag.  I
> guess this may be bad documentation?  I don't know I just wish I could
> get this to work.  Thanks again for the help it is really appreciated.

This topic is difficult because each and every driver bahaves
differently in this respect. But documentation is indeed slim. Please
feel free to add to

C h r i s t i a n       H a u l
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

To unsubscribe, e-mail:
For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message