Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.