cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@dvs1.informatik.tu-darmstadt.de>
Subject Re: esql:query problem
Date Wed, 25 Jun 2003 15:56:18 GMT
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:execute-query>
    <esql:call needs-query="true">{call rptLocationDeviations(
      <esql:parameter direction="in"type="Int"><xsp:expr>number</xsp:expr></esql:parameter>,

      <esql:parameter direction="in" type="String"><xsp:expr>room</xsp:expr></esql:parameter>,
       <esql:parameter direction="in" type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,
       <esql:parameter direction="in" type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}
    </esql:call>
   <esql:results>
     <esql:row-results>
       <test><esql:get-string column="1"/></test>
     </esql:row-results>
    </esql:results>
  </esql:execute-query>

> http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup
> 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 http://wiki.cocoondev.org

	Chris.
-- 
C h r i s t i a n       H a u l
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message