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.
Tables not seen when moved to server mode
Tables not seen when moved to server mode
Open Office 3.4.1 - Windows XP
Re: Tables not seen when moved to server mode
Some things to check:
(1) Make sure the paths in the batch files are valid: Start_HSQLDB_Server.bat and Stop_HSQLDB_Server.bat
http://forum.openoffice.org/en/forum/vi ... 85#p257585
http://wiki.openoffice.org/wiki/FAQ_%28Base%29#HSQLDB
...
(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
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
- For instance, I also have Java 7 installed at:
- 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
http://forum.openoffice.org/en/forum/vi ... 85#p257585
http://wiki.openoffice.org/wiki/FAQ_%28Base%29#HSQLDB
...
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Re: Tables not seen when moved to server mode
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.
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.
Open Office 3.4.1 - Windows XP
Re: Tables not seen when moved to server mode
Everything looks great!Selvi wrote:...opened sucessfully in 297 ms.
...Startup sequence completed in 344 ms.
...HSQLDB server 1.8.0 is online
Yes. So make sure you place your existing data files (mydb.*) in the same folder with Start_HSQLDB_Server.bat.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.
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.
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria