[SOLVED] Is the H2 automatic mixed mode the correct way to access a database on a network share from different clients?

Is the H2 automatic mixed mode the correct way to access a database on a network share from different clients?

I have the same scenario as this one: H2 Database multiple connections. It's the classic "Microsoft Access database on network share" approach.

I have an application that should be installed on several clients within a LAN. During the installation, the user is asked to provide the database location on a network share.

I would like to avoid a separate database server/service installation. In the simplest case, the user just installs the application on 2 computers, both having access to a common network share (can be located on a 3rd computer/server).

Now it seems to me that the automatic mixed mode is what I am looking for, but I am not quite sure. I am mainly looking for confirmation of my understanding, since it isn't explicitly stated in the docs.

So, is the AUTO_SERVER mode the correct (intended/best) way to connect to an H2 database located on a network share from multiple clients running on different machines within the same LAN?

Or have I got this totally wrong and is this something I should not try at all?

Thanks for your time.

Solution