[libreoffice-users] Re: Connecting to HSQLDB with Base

Am 13.04.2012 15:50, Dan Lewis wrote:
> On Fri, 2012-04-13 at 09:38 -0400, Dan Lewis wrote:
> > I have hsqldb installed and running. But I don't find the
> > information that I need to connect Base to it. I have read I can use
> > either ODBC  or JDBC to do this. JDBC requires: Data source URL  jdbc::
> > and JDBC driver class. What belongs in these two boxes?
> >       If ODBC can be used, what goes in the "Name of the ODBC data source
> > on your system? (I don't even know what they are asking for.)
> >
> > --Dan
>
>      Added question: What goes in /tools/options/LibreOffice>Java>Driver>
> Class path?

On my system that is:
1) /usr/local/lib/hsqldb/lib/hsqldb.jar
2a) hsqldb:hsql://192.168.0.2/chargen;default_schema=true
2b) > 
hsqldb:file:/home/andreas/hsqldb_databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false 


2a) connects to a HSQL server, where a configuration file controls which 
database directory is served under which alias name.

2b) connects to a local development version of the database (cached mode 
analog to the embedded thing). 
/home/andreas/hsqldb_databases/Praxis/hsqldbdata/db0/ contains the 3 
database files chargen.script, chargen.data, chargen.properties.

/usr/local/lib/hsqldb/index.html is the entry point to the excellent 
documentation (313 pages of PDF).


--
For unsubscribe instructions e-mail to: users+help@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