Some further info:

I've found a workaround to what seems like a bug. I discovered that my
stored procedure was crapping out on the 1200th row every time, even if
I changed the data in the db - so it wasn't some particular data causing
the problem.

My stored procedure returns a result set - it gets some of the rows
itself, but also calls another stored procedure and passes it's returned
result set on through to the original calling user, ie:

procedure
BEGIN
for execute ... DO
BEGIN
SUSPEND;
call_other sp;
SUSPEND;
END
END

That form works up until the 1200th row, as I said. If I inline the
other sp into this procedure, then there is no 1200 row limit. ie

procedure
BEGIN
for execute ... DO
BEGIN
SUSPEND;
for execute .... DO
BEGIN
SUSPEND;
END
END
END

This works fine. Sadly, it means I have to duplicate the same stored
procedure code in a bunch of places.

-Mike Stover

On Mon, 2006-02-13 at 14:35 -0500, Michael Stover wrote:
> Can anyone tell me what the following error code is trying to tell me:
>
> org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544364. request
> synchronization error
>
> I'm using firebird 1.5 on Linux (Classic server) through the jaybird
> jdbc driver. I'm calling select * from my_stored_procedure(int). It
> returns a large number of rows and columns (couple thousand rows,
> roughly 30 columns). It has been working fine but for one parameter
> value I pass it, and then it gives the above error. Any clue what's
> going on?
>
> -Mike Stover
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> Computer technical
> support
> Compaq computer
> technical support
> Compaq technical
> support
> Hewlett packard
> technical support
> Microsoft technical
> support
>
>
> ______________________________________________________________________
> YAHOO! GROUPS LINKS
>
> 1. Visit your group "firebird-support" on the web.
>
> 2. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> 3. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ______________________________________________________________________
>