In the normal lock mode you can't have 2 different processes open the
same database. Disabling locking and accessing it from 2 different
processes will corrupt the database. There is an experimental serialized
lock mode which will allow it at the cost of performance. It is
experimental at the moment as far as I know, so I would make sure you
are using the latest version. I had quite a lot of trouble with it a few
months ago, but I know they have fixed a lot of things since then.
http://www.h2database.com/html/advanced.html?highlight=serialized&search=serialize#file_locking_serialized
You might want to consider using the TCP service which can accept
multiple connections to the same database. But it means you have to
start up the server rather than running in embedded mode.
There is also an AUTO SERVER, which will start up a server automatically
and then any other connections to the database connect to the running
server. This is a lot more stable than serialized lock mode, but can run
into issues with firewalls. Have a look around on the website
documentation and it will have all the options.
Hope this helps, Ryan
On 20/03/2010 4:54 AM, nickg wrote:
Lets suppose that we have two pcs with h2 embedded both of them
pointing in the same directory db files.
Is this error free for data view and data entry?
thank you
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
