[Solved]Servermode locking and DBeaver

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

[Solved]Servermode locking and DBeaver

Post 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
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
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: servermode locking and DBeaver

Post 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.
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
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: servermode locking and DBeaver

Post by gkick »

Thank you
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Post Reply