On 01.Oct.2002 -- 12:03 PM, fcbc wrote:
> Hello Christian,
>
> ???????, 1 ??????? 2002 ?., you wrote:
>
> CH> Please see your MS docs whether your call will return a ResultSet
> CH> or not. The syntax depends on that, see Apache Cocoon docs for
> CH> details.
>
> I changed code in compliance with MS docs and JDBC driver syntax and
> now script fails with error:
> org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate():
> java.lang.RuntimeException: Error getting clob data: ResultSet is closed
Please try to use <esql:results> instead of <esql:call-results>.
If that doesn't help, and your SP *does* use out parameters, you need
to declare them according to jdbc, using <esql:parameter
direction="out" type="whatever"/> tags in <esql:call>.
Please try to search the mailing list archives, I'm quite sure there
have been others that use MSSQL SPs with ESQL.
BTW most likely you don't need the "needs-query='true'".
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
