I really appreciate all the advice and comments given here. I will check out the Actual Technologies version, but it too, does not sound solid. I need a reliable solution that I can count on working for years of updates and such. I don’t want to worry about fixing connectors. LibreOffice has evolved into a wonderful application suite but is not yet ready as a solid, reliable database client, at least not for my applications.
The comments and advice here has helped me a lot. Thanks.
You can’t blame that entirely on LO. Apple has severely restricted the possibility for apps:
Sorry, I’m not blaming anyone and apologize if I gave any other impression. What I meant is that the combination of Apple’s OS, MariaDB, and using LO as a DB client, is not reliable enough yet for my needs. Maybe it is a shared standards issue, I don’t know. It is outside my capabilities to solve at this time. I need to find a plan B.
Replace LO with some other frontend and the result will be the same.
You may be right, but as I mentioned DBeaver works perfectly as a client using MariaDB’s Java connector, so there is hope.
All I am pointing out is that LO works perfectly for about 60 seconds (as far as I can tell) using the same connector and settings as DBeaver on the same platform. So apparently DBeaver figured out how to solve this and for whatever reason, LO has not yet done so, or I am still missing something.
DBeaver appears to have a way to autoreconnect using the latest Java connector revision (that does not have that option) to maintain the connection, and a popup to reconnect if the connection is eventually dropped. Whatever they did, it works well.
Running a test server on my Ubuntu 20.4 laptop, I can not confirm your issue.
/usr/share/java/mariadb-java-client-2.5.3.jar
org.mariadb.jdbc.Driver
localhost on port 3306
Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 4; OS: Linux 5.15; UI render: Skia/Raster; VCL: x11
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
I honestly don’t have this problem on my local network, connecting to a mysql server from macOS with LibreOffice using either the mysql JDBC connector (downloaded) or the native mysql connector included in LibreOffice.
I’ve experienced the dropout problem connecting to a mysql instance over the WAN, but never on the LAN, unless there were network issues on the LAN itself.
The server I am trying to use is not on a LAN but is a hosted web service. The users sharing the data are not on site and work from home. I work from home as well.
Thanks.