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 …
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.
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.
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.
@koolninja You may be interested in this post on HSQLDB in server mode - Attempting multi-user server mode.