I have installed LibreOffice 7.6 hoping to use Base as a front end to my mariadb databases. I can manipulate the databases with dBeaver but cannot connect with Base. The class driver org.mariadb.jdbc.Driver tests OK (according to Base) and when I finish all and test the connection I get “the connection could not be established” I’m not sure what more I can do. I’m using mariadb-java-client-3.3.2.jar located at /usr/share/java. I’m running Debian 12. Any suggestions would be appreciated!
Try with this driver:
sudo apt install libreoffice-sdbc-mysql
That did it, thank you so much! I never would have figured that out.
With your JDBC driver:
Tools>Options … Advanced, [Class Path…] , add your mariadb-java-client-3.3.2.jar and restart the office.
menu:File>New>Database…
[X] COnnect to existing db
Type: JDBC
Specify host, port and “com.mysql.jdbc.Driver” as driver class.
ODBC, where you set up the connection with a 3rd-party tool, is another option.
Should be “org.mariadb.jdbc.Driver” for the original JDBC driver, as posted…
Seems @csm1 could connect to JDBC, but couldn’t connect to the database. So something in connection string might be wrong.
I did this before posting and still couldn’t make the connection.