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
[Solved]Servermode locking and DBeaver
[Solved]Servermode locking and DBeaver
Last edited by gkick on Fri Feb 14, 2020 3:23 am, edited 1 time in total.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Re: servermode locking and DBeaver
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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice