Ask Your Question
1

Split Database - RFC [closed]

asked 2016-05-29 10:42:21 +0200

hmadhi gravatar image

updated 2016-05-30 21:22:28 +0200

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
  1. "Setup User Authentication" ... Username = SA

  2. "Decide How To Proceed After Saving The Database"

  3. "Save Database" -> Choose a location eg ~/Project/

The following hsqldb files will be created in ~/Project

mydb.properties
mydb.script
mydb.log
  1. Proceed to create a table eg "Test" Columns ID and add some data

  2. 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?

edit retag flag offensive reopen merge delete

Closed for the following reason not a real question by Ratslinger
close date 2016-06-19 16:10:49.269541

Comments

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

Ratslinger gravatar imageRatslinger ( 2016-05-29 22:05:15 +0200 )edit

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?

hmadhi gravatar imagehmadhi ( 2016-05-30 21:10:25 +0200 )edit

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 gravatar imageRatslinger ( 2016-05-30 21:34:51 +0200 )edit

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"?

Ratslinger gravatar imageRatslinger ( 2016-05-30 22:01:33 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2016-06-18 17:44:03 +0200

jay Arr gravatar image

I support Ratslinger's response.

and

If it aint broke - don't fix it!

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2016-05-29 10:42:21 +0200

Seen: 340 times

Last updated: Jun 18 '16