--- In Firebird-Java@yahoogroups.com, Mark Rotteveel <mark@...> wrote:

>
> On 17-12-2011 9:53, certfb wrote:
> >
> >
> > --- In Firebird-Java@yahoogroups.com, Roman Rokytskyy<roman@> wrote:
> >>
> >>>> There appears to be a separate driver plugin in Jaybird for
> >>>> OpenOffice,
> >>>> because OpenOffice (apparently) does some things wrong with
> >>>> statements
> >>>> and/or resultsets. This is however a variant of the pure-java driver
> >>>> and
> >>>> won't work with embedded.
> >>>>
> >>>> I - unfortunately - think you are out of luck here.
> >>>
> >>> I am going to investigate this further, because a quick search does
> >>> not
> >>> turn up posts that other drivers have problems with this.
> >>
> >> The issue is in autocommit mode - OO opens a result set and while
> >> looping in the result set it tries to execute the statement. According
> >> to the JDBC specs the result set has to be closed, which our driver
> >> does. That is where OO crashes with SQLException.
> >>
> >> The plugin provides workaround for this and it should work with all
> >> driver types.
> >>
> >> Roman
> >>
> >
> > Thank you for your time.
> >
> > I managed to get some limited success by copying all the embedded files to the OpenOffice program directory and appending the "?defaultHoldable" option to the connection string (although I have to admit I don't know what that does). This way I could insert new records, but not view them in table mode - only in a view or query.
> >
> > There used to be an option to insert 'oo' in the connection string...
> >
> > jdbc:firebirdsql:oo:localhost:c:/database/employee.fdb?defaultHoldable
> >
> > ...but I am not sure if this still exists and in any case it I don't think it can be combined with :embedded: which is a pity.
> >
> > Unfortunately though copying all the embedded files to the OpenOffice program directory stopped the internal HSQL db from working so I have had to remove them for now.
>
> the :oo option still exists, but it uses the pure-java driver, so you
> would not be able to use embedded.
>
> The defaultHoldable option sets the default ResultSet holdability to
> HOLD_CURSORS_OVER_COMMIT, which means that the resultset is not closed
> at commit.
> --
> Mark Rotteveel
>

Thank you for the insight.


Mike