Apache OpenOffice Community Forum

I have been reading various post on setting up database, forms...and client server mode for the past 1 month and managed to create a simple database for our project need.

I could create few tables, forms in the embedded mode.
I learnt to migrate this embedded to split file by specifying the Database URL with file option.
hsqldb:file:\\users\public\database\mydb\mydb;default_schema=true

my aim is to have a split file database and run this in server mode to accomodate multi users .


I am using OpenOffice 3.4.1
I have folder mydb with the following files. mydb.backup, mydb.data, mydb.properties, mydb.script, mydb.server.odb and Start_HSQLDB_Server.bat and Stop_HSQLDB_Server.bat

Database URL is hsqldb:hsql://<IP address>/;default_schema=true and JDBC driver class is org.hsqldb.jdbcDriver.

My start_HSQLDB_Server,bat looks like
@echo off
set javapath=C:\Program Files\Java\jre6\bin\Java.exe
set jarpath=C:\Program Files\openoffice.org 3\basis\program\classes\hsqldb.jar
"%javapath%" -cp "%jarpath%" org.hsqldb.Server -database.0 file:mydb

When I open mydb.server.odb, the tables are not appearing.

Is my configuration correct?
what am missing? Please help me with pointers.

I googled alot and ended up in various post...and looks like am following all the steps...but still the tables are not appearing.

Please advice.

Some things to check:

(1) Make sure the paths in the batch files are valid: Start_HSQLDB_Server.bat and Stop_HSQLDB_Server.bat

• Is your Java path correct in:
  set javapath=C:\Program Files\Java\jre6\bin\Java.exe
  
  • For instance, I also have Java 7 installed at:
    C:\Program Files (x86)\Java\jre7\bin\Java.exe
  Is your "class path" to hsqldb.jar correct in:
  set jarpath=C:\Program Files\openoffice.org 3\basis\program\classes\hsqldb.jar
  
  • For instance, I now run AOO 3.4.1 so my "class path" to hsqldb.jar (HSQLDB version 1.8.0.10) is:
    C:\Program Files (x86)\OpenOffice.org 3.4\Basis\program\classes\hsqldb.jar
    
    My LibO "class path" is:
    C:\Program Files (x86)\LibreOffice 3.5\program\classes\hsqldb.jar

(2) mydb.server.odb contains the following data-source URL:

• hsqldb:hsql://localhost/;default_schema=true;get_column_name=false
  
  This works when running the .odb on the database host (server) but you'll ultimately need the computer name or static IP address of the host/server on your LAN for client .odb access. The data-source URL will become something like:
  hsqldb:hsql://MY-COMPUTER/;default_schema=true;get_column_name=false
  hsqldb:hsql://192.168.1.112/;default_schema=true;get_column_name=false

References:
http://forum.openoffice.org/en/forum/vi ... 85#p257585
http://wiki.openoffice.org/wiki/FAQ_%28Base%29#HSQLDB
...

Thank you DACM for the quick reply.

I rechecked
- Java Path..corrected it to point to Release 7.
- Class path - details are correct.

Still no luck. ;-(


1) I created a new table (sample) to check where the tables are getting saved.... I dont get a hint of where this saved.
Looks like the current setup is embedded database file.

2) However, When I opened the odb file using Zip, I dont see the database folder. This would mean that the database is sitting outside of this odb file.


3) When I ran the Serever startup file, I see the following..
ver.properties]
[Server@12c7568]: Initiating startup sequence...
[Server@12c7568]: Server socket opened successfully in 47 ms.
[Server@12c7568]: Database [index=0, id=0, db=file:mydb, alias=] opened sucessfully in 297 ms.
[Server@12c7568]: Startup sequence completed in 344 ms.
[Server@12c7568]: 2013-07-16 10:08:51.375 HSQLDB server 1.8.0 is online
[Server@12c7568]: To close normally, connect and execute SHUTDOWN SQL
[Server@12c7568]: From command line, use [Ctrl]+[C] to abort abruptly

Database file: mydb opened successfully. Does this mean that it is loading mydb.data file which is lying in the same folder where this startup file is found?
mydb.data is 24KB in size.

Thank you.

Selvi wrote:...opened sucessfully in 297 ms.
...Startup sequence completed in 344 ms.
...HSQLDB server 1.8.0 is online

Everything looks great!

Selvi wrote:Still no luck. ;-(

Does this mean that it is loading mydb.data file which is lying in the same folder where this startup file is found?
mydb.data is 24KB in size.

Yes. So make sure you place your existing data files (mydb.*) in the same folder with Start_HSQLDB_Server.bat.
Based on the data-source URL from your file-mode .odb, your data files should be located at: C:\users\public\database\mydb\
Move Start_HSQLDB_Server.bat and Stop_HSQLDB_Server.bat to that folder and your tables should be available.

P.S. Make sure you make the same correction to the Java path in your Stop_HSQLDB_Server.bat file.