Subject Re: [Firebird-Java] Using Jaybird with OpenOffice
Author William L. Thomson Jr.

On Tue, 2006-03-28 at 19:46 -0800, Dan Wilson wrote:
> The result set is closed.
> Clicking on "More" gives additional information:
> SQL Status: HY000
> The result set is closed

I ran into this as well, at the same time I was having issues with
nested result sets. However I think it was problems in my code. Since I
ran into that issue. I have done several nested result set queries as
part of data pumping between databases.

Have yet to run into it again. However I am pretty sure I can replicate
the above in OO, on Linux. I want to say it's more 1.5 related than
Jaybird 2.x. Since I do not believe I ran into those problems until I
started using 1.5. However my system vm is still 1.4 on gentoo. I think
OO uses that, which complete goes against the 1.5 thing.

Sorry for not providing a test case for when I ran into it in my own
code. I could not easily reproduce, and I could not easily rip out just
those aspects to provide test case. Large db and app :)

However if I can help with debugging the OO issue. I will, just let me
know onlist or off. Thanks

> If I attempt to design a form or a query, OpenOffice is able to show
> me all of the fields within each table, so clearly, OpenOffice is
> talking to Firebird. What would prevent it from accessing the data
> within each table?

Not sure, but I have seen it before as well.

William L. Thomson Jr.
Obsidian-Studios, Inc.