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

Le 04/03/2014 13:53, Mark LaPierre a écrit :

Hi Mark,
> I just now noticed that you have "hsqldb:file:<path to the.odb>" in the
> Datasource URL area.  How is a Base, i.e. .odb, file used as the data
> source when the data is stored in a standalone HSQLDB database?  The
> data is not stored in an .odb file but rather is managed by the
> standalone HSQLDB database.

The ODB file uses a JDBC connector driver included in the hsqldb
package, i.e. it merely references the actual database and uses JDBC to
access it. Any and all forms, queries, reports, macros, etc, are stored
within the ODB file, even if the actual data from the hsqldb is stored
in a separate directory pointed to by the URL. Also stored in the
separate directory is the db initialisation/creation script file and any
data backup and user/pwd configuration.

This is what we mean by a "split" hsqldb database.

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