Ask Your Question

How do I run Base in server mode? [closed]

asked 2017-01-27 04:12:12 +0200

tfallin gravatar image

updated 2020-08-02 17:37:57 +0200

Alex Kemp gravatar image

I have finally gotten my split database file working from a shared folder using the macro method. Now, how do I get it to run in server mode so multiple users can access the database? I have tried the following:

But I get this error: org.hsqldb.jdbcdriver could not be loaded.

Is it even possible to open my database in server mode from a shared folder?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-02 17:39:13.333615

1 Answer

Sort by » oldest newest most voted

answered 2017-01-27 11:46:36 +0200

Ratslinger gravatar image

HSQL can be run in server mode and Base can use it. Details can be found in the manual here. You would not be using a driver but rather a host location such as hsqldb:hsql://localhost/xdb with xdb being defined as a URL in sqltool.rc. It also requires starting/stopping the server.

This forum is for LibreOffice and not for DB server questions. You may better off getting specific answers to you question in this forum.

edit flag offensive delete link more


I do not understand where or how command lines work. Is there a step by step I can follow?

tfallin gravatar imagetfallin ( 2017-01-27 14:50:24 +0200 )edit

The "command line" is the basic interaction of the user with the computer. In the non-graphical days of computers, all tasks were completed through the command line such as running programs, moving files, creating directories & everything else. This is still heavily used by many and getting to a command prompt and using it is operating system dependent. Refer to your OS documentation.

Ratslinger gravatar imageRatslinger ( 2017-01-27 16:21:47 +0200 )edit

Im sorry but I understand CMD. What I don't understand is the following:

  1. the split database is stored on a shared folder from PC1

  2. I have two laptops that access the database, PC2 and PC3.

  3. How do I allow both PC2 and PC3 access the database and add or make changes to said database?

I've read the above link and I get the above error msg. I thank you in advance for your help.

tfallin gravatar imagetfallin ( 2017-01-27 19:10:04 +0200 )edit

Still not quite sure what you are looking for. Once the HSQL server is up and running, The Datasource URL is dependent upon the server. For example, mine is:

hsqldb:hsql://localhost/xdb;default_schema=true; shutdown=true;hsqldb.default_table_type=cached;get_column_name=false

where localhost is the server location (IP address or such) and xdb is the name I gave in sqltool.rc. Now you just need a copy of the .odb to connect to the database and nothing else.

Ratslinger gravatar imageRatslinger ( 2017-01-27 22:07:18 +0200 )edit

Maybe what is misunderstood, the entire "split folder" is not what is being shared. It is the "database" subfolder which is the database pointed to by the server connection. The .odb file then uses the Datasource URL to access the DB data.

Ratslinger gravatar imageRatslinger ( 2017-01-27 22:15:20 +0200 )edit

I believe I just figured out your question. You need to have a Class Path (Tools->Options->LibreOffice->Advanced) to the hsqldb.jar file. Care must be taken however. If you open an embedded .odb with the Class Path in place, it will cause problems and that .odb will no longer work without repairs.

Ratslinger gravatar imageRatslinger ( 2017-01-28 00:07:06 +0200 )edit

Is there anyway you might be able to call me for 10 min conversation. I guess I dont understand what you mean by the server. My company will not allow me to use the computer/server I have the share folder setup on to be used as a server for this database. I was under the impression that if I opened the split database with either PC2 or PC3, one would act as a server. if you could call me my number is 813-344-5926. I the can give you more detail about the database and its function. Thank you.

tfallin gravatar imagetfallin ( 2017-01-28 00:38:22 +0200 )edit

Any database (HSQL, MySQL, PostgreSQL, etc.) which allows multiple users to access the data needs to run in an environment where record locking and such will be provided. You don't want multiple changes to a record at the same time. To run in this environment, the database service needs to be up and running. It is totally separate from Base (which only allows one connection at a time). You can start & stop the server but it must be running to access the data for a multi-user environment.

Ratslinger gravatar imageRatslinger ( 2017-01-28 02:16:51 +0200 )edit

The instructions provided in your question also discusses the running of the server and starting/stopping it.

Ratslinger gravatar imageRatslinger ( 2017-01-28 02:26:53 +0200 )edit

Question Tools

1 follower


Asked: 2017-01-27 04:12:12 +0200

Seen: 1,854 times

Last updated: Jan 27 '17