Thanks for your replys, I will try to make a short
article about my problem.


--- Roman Rokytskyy <rrokytskyy@...> wrote:

>
> > I have resolved the problem. I updated the jdbc
> > jaybird driver from 1.5.0 to 1.5.4 and also added
> the
> > following line before executing the statement:
> >
> >
>

((FirebirdCallableStatement)cs).setSelectableProcedure(true);

>
> Yes, that's another way to do this, but it is
> Firebird-specific.
>
> The story for this parameter:
>
> As I wrote in my previous post, the only chance to
> get result set from
> selectable procedure is to use SELECT * FROM syntax.
> When selectable
> procedure is executed via EXECUTE PROCEDURE, only
> first row is fetched.
>
> JayBird supports escaped syntax for callable
> statements: {call ...} or
> {?=call ...}. We parse the procedure call, and
> convert it into the
> Firebird-specific syntax. By default it is converted
> into EXECUTE PROCEDURE
> call. However, there is no chance to get information
> whether this procedure
> is selectable or not. So, in order to be able to use
> SELECT * FROM syntax
> instead of EXECUTE PROCEDURE, application must give
> us a hint.
>
> Can you prepare a small article that we can post in
> into our Wiki?
> Unfortunately I have no time to do this myself.
>
> Roman
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> $9.95 domain names from Yahoo!. Register anything.
>

http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM

>

--------------------------------------------------------------------~->

>
>
>
> Yahoo! Groups Links
>
>
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
>
>
>

__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250