Subject Re: [Firebird-Java] JayBird and
Author Roman Rokytskyy
> 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.