Split Database - RFC

[hmadhi]

Having looked at various links on how to create a split database and having experimented with them, I am proposing in this post a simpler method and would like your comments, concerns , guidance and questions.

I am using Ubuntu 16.04 LibreOffice 5.1.3

(Unfortunately I cannot upload pictures as I do not have enough points)

These are the steps

1. Tools → Options → LibreOffice->Advanced->Class Path->Add Archive …
   Eg.

/usr/lib/libreoffice/program/classes/hsqldb.jar

2. Start with Database wizard - “Connect To Existing Database”->“JDBC”

3. “Set up a connection to a JDBC database”
   Enter the following:

   Database URL:

    hsqldb:file:////path/to/Project/mydb;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false
   

JDBC Class Driver:

org.hsqldb.jdbcDriver

4. “Setup User Authentication” … Username = SA

5. “Decide How To Proceed After Saving The Database”

6. “Save Database” → Choose a location eg ~/Project/

The following hsqldb files will be created in ~/Project

mydb.properties
mydb.script
mydb.log

7. Proceed to create a table eg “Test” Columns ID and add some data

8. The following additional hsqldb file will be created in the ~/Projects directory

mydb.data

I would like to hear from the community … any concerns, comments ?
Have I missed something important?

[Ratslinger]

Portability is gone. Hsqldb.jar needs to stay with .odb file.

[hmadhi]

As long as the Class Path is setup correctly I don’t see/understand why this is an issue. Maybe copy the hsqldb.jar file to the directory holding the the odb file and change the class path as appropriate?

[Ratslinger]

You should not have to set a class path on every machine just to move the split DB. Existing procedures work just fine and don’t require this. I fail to see the reasoning behind a new procedure.

[Ratslinger]

I believe the key item here is your original statement “…I am proposing in this post a simpler method…” The method most use contains six simple steps and no long entry of data strings. So how is the stated method “simpler”?

[jayArr]

I support Ratslinger’s response.

and

If it aint broke - don’t fix it!