Re: [libreoffice-users] Re: Connect Base to External HSQLDB

Hi :)
I think it's worth avoiding using the internal back-end.

Until very recently the internal one was an ancient and heavily
tweaked version of Hsqldb.  I think the devs have been working at
replacing it with a more straight-forward Firebird and hopefully that
will be updated in some sort of reasonably automatic way with an
opt-out clause.

The old internal Hsqldb one was a bit warped and the new Firebird one
is a bit new.

If you get a reasonably recent version of Hsqldb to use as an external
database then apparently it's extremely good and exceedingly fast, for
small databases (such as address-books) but when using the internal
tweaked version people have had some fairly serious problems.  It's
entirely written in Java apparently but even so it's allegedly quite
good.

Regards from
Tom :)







On 11 March 2014 22:41, jomali <jomali3945@gmail.com> wrote:
> Thanks, Alex, for the clarification. Since I have never used the internal
> hsqldb database, I was unaware that it kept its data in the .odb file. The
> last internal database I used was Adabas D in Staroffice. I quickly went to
> JDBC or ODBC connectors to other external datbase engines (e.g., MySQL).
> John
>
>
> On Tue, Mar 11, 2014 at 12:57 PM, Alex Thurgood <alex.thurgood@gmail.com>wrote:
>
> > On 11/03/2014 13:23, jomali wrote:
> >
> > Hi John,
> >
> > > I think your confusion lies in equating an .odb file with an Access
> > > database. The .odb file never contains the data. It is a sort of registry
> > > that points to wherever the data is. Thus, Base is the front end, a real
> > > database is the back end, and the .odb file serves as the intermediary
> > (to
> > > oversimplify).
> >
> > I agree with everything you have written, except that, by default, if
> > you use the wizard to create a "standard" (and I use that term very
> > loosely) ODB file, LO creates an ODB file which embeds its own
> > hsqldb-compatible data into the file and then uses the LO-shipped
> > hsqldb.jar to be the db engine. This is where it gets confusing for
> > people wanting to split out their data from their forms, queries,
> > reports, etc.
> >
> > Alex
> >
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted