[Solved]Servermode locking and DBeaver

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

[Solved]Servermode locking and DBeaver

Postby gkick » Sun Feb 02, 2020 3:10 am

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

Re: servermode locking and DBeaver

Postby Villeroy » Sun Feb 02, 2020 3:24 am

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

Re: servermode locking and DBeaver

Postby gkick » Sun Feb 02, 2020 2:36 pm

Thank you
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
gkick
 
Posts: 295
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 0 guests