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

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