Ask Your Question

HSQLDB instance in multi-user mode

asked 2017-09-17 11:02:59 +0200

koolninja gravatar image

updated 2017-09-17 11:04:22 +0200

In HSQLDB instance in multi-user mode is same .odb file used for accessing database from different computer in network or different multi .odb file used for multi users.

thanks ...

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-09-17 15:06:31 +0200

Ratslinger gravatar image

It appears you are saying HSQLDB is running in server mode. There is no different .odb for a user. There is, however, a different connection string (Datasource URL). This string for a user on the same computer as the server might be localhost and for someone on a different computer would need the additional information of the server name or IP address on the network.

There may also be some confusion on the term server. If you are setting up a network, the machine to be connected to must be set up as a server so others may access it. HSQLDB would reside on the server and operate in its' own server mode meaning multiple users can simultaneously access the data.

Do not confuse a network server with a database server. They are not the same. For a network server, search the internet for specifics using the OS you have. Each is different and requires different software.

edit flag offensive delete link more


I needed information about multi-user start database in server mode, all users used same .odb of server database computer. suppose three users A, B AND C treat A database start in server mode. A has k.odb, B has k1.odb and C has k2.odb to access database through Datasource URL or use only one k.odb for A, B and C through sharing in networking to access database.

koolninja gravatar imagekoolninja ( 2017-09-18 07:07:00 +0200 )edit

When you start the HSQLDB in server mode on the network server it is available for multi user access. Users should not be starting/stopping the DB server. I mention this here because your comment is unclear.

Whoever is using what xxx.odb is not the concern. That is a procedural decision. The only concern with the xxx.odb (as stated in my answer) for a user is that it contains the proper URL for the connection to the DB.

Ratslinger gravatar imageRatslinger ( 2017-09-18 16:43:04 +0200 )edit

@koolninja You may be interested in this post on HSQLDB in server mode - Attempting multi-user server mode.

Ratslinger gravatar imageRatslinger ( 2018-02-11 23:36:16 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-17 11:02:59 +0200

Seen: 641 times

Last updated: Sep 17 '17