Page 1 of 1

[Solved]Servermode locking and DBeaver

PostPosted: Sun Feb 02, 2020 3:10 am
by gkick
Hi,

Never managed to get server mode running, but in case I do sometime in the future I was wondering how HSQL works if 2 or more users use the same table. Does HSQL invoke table or record locking ?
Also does anyone use DBeaver ? I can connect to PG, but not to HSQL. Apparently Beaver supports HSQL Embedded and Server, but a split db is neither.

Thanks

DBeaver works fine with HSQL in Server Mode, Standalone db using embedded driver throw up some Lock Error

Re: servermode locking and DBeaver

PostPosted: Sun Feb 02, 2020 3:24 am
by Villeroy
HSQL invokes row locking. I can edit the same table but different records from 2 clients. I run HSQL on Windows with a simple start script.

Re: servermode locking and DBeaver

PostPosted: Sun Feb 02, 2020 2:36 pm
by gkick
Thank you