I am having the exact same problem but using a remote mariadb server.
Connect to an existing database: MySQL/MariaDB
Connect using JDBC
Database & Server: Same as use in DBeaver
Port: 3306, Driver class: org.mariadb.jdbc.Driver, Tests good.
User name & password, same as used in DBeaver.
ERROR: "The connection could not be established.”
I’m using a Mac (M1) running OS 15.1.1, LO version 24.8.2.1 (AARCH 64), latest version of Java and MariaDB drivers.
I have been trying all sorts of things: making sure I have the latest versions, uninstalling & reinstalling Java, … I have been messing with this for many hours and don’t see what I am doing wrong. It appears that the connector is loading OK but not interfacing with the DB properly. Please note that the same settings in DBeaver and PHPAdmin work fine. Any suggestions?