[Solved] Real-Time Data Update/Refresh
[Solved] Real-Time Data Update/Refresh
Hey all,
So I created a split-database running in JDBC mode and using HSQL respectively for a new database here at work. I'm able to edit the data on multiple computers at the same time. However, the data doesn't refresh real-time for the other computers, unless they close out of the ODB file and open it back up. To make it easier to visualize, let me give you a scenario:
I'm entering data into a form on Computer A, while Computer B is viewing the form as well. When I'm completed entering data on Computer A, I save the form and refresh. However, Computer B doesn't see that new data, unless Computer B closes out of OpenOffice and opens it back up. Even if Computer B refreshes the form, it still doesn't update. I want Computer B to see the updated data in real-time.
I need to be able to incorporate real-time data update for project management (ie. showing the status of a client sample, what samples are in the queue, etc.)
Any help would be greatly appreciated! Thank you!
So I created a split-database running in JDBC mode and using HSQL respectively for a new database here at work. I'm able to edit the data on multiple computers at the same time. However, the data doesn't refresh real-time for the other computers, unless they close out of the ODB file and open it back up. To make it easier to visualize, let me give you a scenario:
I'm entering data into a form on Computer A, while Computer B is viewing the form as well. When I'm completed entering data on Computer A, I save the form and refresh. However, Computer B doesn't see that new data, unless Computer B closes out of OpenOffice and opens it back up. Even if Computer B refreshes the form, it still doesn't update. I want Computer B to see the updated data in real-time.
I need to be able to incorporate real-time data update for project management (ie. showing the status of a client sample, what samples are in the queue, etc.)
Any help would be greatly appreciated! Thank you!
Last edited by DeMiNiX on Fri Sep 18, 2015 9:04 pm, edited 1 time in total.
OpenOffice 4.1.1, Windows 7 Home Premium 64-bit
Re: Real-Time Data Update/Refresh
There is a refresh button on a toolbar for every form, table, view and query.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Real-Time Data Update/Refresh
DeMiNiX:
Welcome to the OpenOffice / LibreOffice Base forum.
¿ Can you please help me, help you to find the solution to your described problem ?
Please follow these steps for me:
¿ What I want to confirm, are you running your HSQL database back-end as a single user or as a server ?
Sliderule
Welcome to the OpenOffice / LibreOffice Base forum.
¿ Can you please help me, help you to find the solution to your described problem ?
Please follow these steps for me:
- Start your OpenOffice / LibreOffice Base file ( *.odb )
- From the Menu: Edit -> Database -> Properties
- Please report back here, what is entered, under Datasource URL:
- Below, is an example of what I have entered, when using the database as a single user, and the name of my HSQL database files are bldtest :
Code: Select all
hsqldb:file:C:\Users\User_Name\Documents\HSQL\data\bldtest;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false
- Below, is an example of what I have entered, when using the database as a Server ( multiple user ), and the name of my HSQL database files are bldtest :
Code: Select all
hsqldb:hsql://localhost/bldtest;default_schema=true
Code: Select all
org.hsqldb.jdbcDriver
Sliderule
Re: Real-Time Data Update/Refresh
Thank you for the quick reply! As I was reading your description of the differences between HSQL single-user and HSQL Server, I realized I wasn't running a server. So I went through the process of creating the .BAT files, ran it on Computer A, and all is good.... until I try Computer B.Sliderule wrote:DeMiNiX:
Welcome to the OpenOffice / LibreOffice Base forum.
¿ Can you please help me, help you to find the solution to your described problem ?
Computer B is having some trouble connecting to the server. Let me read to you the "destination URL" description for mydb.server.odb:
Code: Select all
hsqldb:hsql://localhost/;default_schema=true;get_column_name=false
NOW, back to Computer B: I tried doing the following things;
- copying mydb.server.odb onto Computer B, and changing localhost to the IP of computer A (no luck, I am prompted "socket creation error"
- opening the same mydb.server.odb that Computer A is running (no luck, socket creation error)[/list]
Now, with all that being said, I'm running the SERVER on Computer B, with all of the database and server files located on a shared network drive.
Is there anything special about running a network off of a shared network drive, instead of a shared network machine? What would you suggest I do from here?
Thanks a lot for your help!
OpenOffice 4.1.1, Windows 7 Home Premium 64-bit
Re: Real-Time Data Update/Refresh
You said / asked:
What I would suggest, is, review the HSQL documentation.
I am assuming, you are running HSQL Version 2.3.3 ( or at least, one of the 2.3 versions ) rather than, HSQL 1.8.0.10 . . . a very old version ( with the hsqldb.jar file included in the OpenOffice download ).
HSQL documentation:
Explanation: Please be sure to have ( create ) an additional BAT file to shut down the running HSQL server, if you have not done that already.
Sliderule
Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.
I do not know the answer for that question, since, I am running it ( the database back-end, HSQL ) on one machine, as a Server, but, allowing multiple programs get at the HSQL data concurrently.Is there anything special about running a network off of a shared network drive, instead of a shared network machine? What would you suggest I do from here?
What I would suggest, is, review the HSQL documentation.
I am assuming, you are running HSQL Version 2.3.3 ( or at least, one of the 2.3 versions ) rather than, HSQL 1.8.0.10 . . . a very old version ( with the hsqldb.jar file included in the OpenOffice download ).
HSQL documentation:
- I prefer, the PDF file . . . name of . . . guide.pdf
- If you want to get to HSQL documentation online, HTML, http://www.hsqldb.org/doc/2.0/guide/
check out: http://www.hsqldb.org/doc/2.0/guide/run ... sql_server
Look at- Example 1.2. Java code to connect to the local http Server
- Example 1.3. Java code to connect to the local secure SSL hsql and http Servers
Explanation: Please be sure to have ( create ) an additional BAT file to shut down the running HSQL server, if you have not done that already.
Sliderule
Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.
Re: Real-Time Data Update/Refresh
One additional note, the example below, is what I use to START my HSQL Server:
Notice above, the parameter, --dbname
Per HSQL documentation:
Sliderule
Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.
Code: Select all
@java -classpath "C:\Program Files (x86)\HSQL-20\lib\hsqldb.jar" org.hsqldb.server.Server --database.0 file:bldtest --dbname.0 bldtest xdb
Per HSQL documentation:
Note the use of the words . . . public name (alias) above.Chapter 14: [url]http://www.hsqldb.org/doc/2.0/guide/listeners-chapt.html#lsc_hsql_server[/url] wrote:Listeners
As described in the Running and Using HyperSQL chapter, network listeners (servers) provide connectivity to catalogs from different JVM processes. The HyperSQL listeners support both ipv4 and ipv6 network addressing.
HyperSQL Server
This is the preferred way of running a database server and the fastest one. This mode uses the proprietary hsql: communications protocol. The following example of the command for starting the server starts the server with one (default) database with files named "mydb.*" and the public name (alias) of "xdb".
Code: Select all
java -cp ../lib/hsqldb.jar org.hsqldb.server.Server --database.0 file:mydb --dbname.0 xdb
Sliderule
Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.
Re: Real-Time Data Update/Refresh
And this is my start.bat:
the --props file looks like this:
I get the same "no socket" error when the server.address entry is missing or plain wrong.
And this is the server.acl referenced in the last line:
It allows connections from the localhost 127.0.0.1, from 192.168.15.??? and 192.168.0.***
Code: Select all
CD "C:\Program Files (x86)\hsqldb\lib"
java.exe -cp hsqldb.jar org.hsqldb.server.Server --props D:\Daten\hsqldbdata\server.properties
pause
Code: Select all
server.database.0=file:D:/Daten/hsqldbdata/db0/chargen;ifexists=true
server.dbname.0=Charges
server.database.1=file:D:/Daten/hsqldbdata/db1/bema_goz;ifexists=true
server.dbname.1=TEST
server.database.2=file:D:/Daten/hsqldbdata/db2/Kassenbuch;ifexists=true
server.dbname.2=CashRegister
server.database.3=file:D:/Daten/hsqldbdata/db3/journal;ifexists=true
server.dbname.3=Journal
server.address=192.168.15.1
server.acl=D:/Daten/hsqldbdata/acl.txt
And this is the server.acl referenced in the last line:
Code: Select all
allow 127.0.0.1
allow 192.168.15.0/24
allow 192.168.0.0/24
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Real-Time Data Update/Refresh
That was it. That did the trick. I needed to add those commands in my properties file, and create the acl file that allowed the connections. I am now able to simultaneously enter data from multiple users, and the data will show (once everyone refreshes their page, but I'll add an auto-refresh script).Villeroy wrote:And this is my start.bat:the --props file looks like this:Code: Select all
CD "C:\Program Files (x86)\hsqldb\lib" java.exe -cp hsqldb.jar org.hsqldb.server.Server --props D:\Daten\hsqldbdata\server.properties pause
I get the same "no socket" error when the server.address entry is missing or plain wrong.Code: Select all
server.database.0=file:D:/Daten/hsqldbdata/db0/chargen;ifexists=true server.dbname.0=Charges server.database.1=file:D:/Daten/hsqldbdata/db1/bema_goz;ifexists=true server.dbname.1=TEST server.database.2=file:D:/Daten/hsqldbdata/db2/Kassenbuch;ifexists=true server.dbname.2=CashRegister server.database.3=file:D:/Daten/hsqldbdata/db3/journal;ifexists=true server.dbname.3=Journal server.address=192.168.15.1 server.acl=D:/Daten/hsqldbdata/acl.txt
And this is the server.acl referenced in the last line:It allows connections from the localhost 127.0.0.1, from 192.168.15.??? and 192.168.0.***Code: Select all
allow 127.0.0.1 allow 192.168.15.0/24 allow 192.168.0.0/24
Thank you so much Villeroy and Sliderule for your help! You two are awesome! I couldn't have done it without you!
OpenOffice 4.1.1, Windows 7 Home Premium 64-bit