Subject Re: [Firebird-Java] JayBird and
Author Eron Lloyd
On 8/10/06, Roman Rokytskyy <rrokytskyy@...> wrote:
> > Yeah, I always use the official builds (more up-to-date). This morning I
> > tried running OOo as root, and was sucessfully able to see the tables.
> > This obviously suggests a permissions issue somewhere, as mentioned in
> > that Java thread I posted.
> Please check the permissions for the database file itself. This very often
> causes problems to me.
> > A new quirk, however, is that when I attempt to edit a table I get a
> > "Result Set Closed" error, so I can only see the View objects. Perhaps
> > this is an ownership issue of the empolyee.fdb file. Maybe I'll bring this
> > up on the firebird users list.
> No, this has nothing to do with permissions. I have already built a small
> fix into the driver (a parameter called defaultHoldable=true), but it fixes
> not everything. I have already found the issue(s) - Base deviates from the
> JDBC specification significantly when it comes to handling the multiple
> result sets. Also I have another version of the driver which fixes the
> issues (and works for me quite ok), I will release it as a plugin to our
> driver soon.

So perhaps this is a OOo issue after all. I'll have to report this to
the openoffice-dba team and push for more QA with Firdbird
connectivity. In the meantime, is there a specific version of JayBird
I should use (snapshot)?

Thanks for the help,