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

On Fri, 2012-04-13 at 16:35 +0200, Andreas Säger wrote:
    Trying again because nothing seems to make much sense to me. This
time I need a reply that is made inline rather than a bottom post.
Otherwise, what answer goes with what question becomes very unclear. I'm
leaving some space between questions for the answers. Drag and drop the
answers from below if they differ from what I have put in parentheses.
Somewhere among all the words about HSQLDB there is instructions that
are step by step. 
     I already have the HSQLDB Guide in PDF format. I have searched
through the index.html file, but could not find what I needed to know.
Neither did LO Help explain what was needed (OOo Help was not better).
The more I look at the documentation, the more confused I get.

     Setting the root and personal passwords for HSQLDB. (Nothing is
clear about how to do this.)

     Connecting to HSQLDB using JDBC:
         Data source URL  jdbc::  
         (Perhaps /usr/local/lib/hsqldb/lib/hsqldb.jar?)


         JDBC driver class
         

    
         Tools > Options > Java > Class path


     Connecting to HSQLDB using JDBC:


--Dan


> 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