I connect daily to a MySQL database (Mariadb10) located on a network server from
the LO-Base front-end on my desktop. The connection type is
MySQL(JDBC). However, today, the
driver class com.mysql.jdbc.Driver could not be loaded
There seems to be no way to make the connection, although I am not aware of having changed anything (except maybe an update from the OpenSUSE repository early this week)
I can access the database via my browser using phpMyAdmin, so, I assume, there is
nothing wrong with the database schemata themselves.
What must I do to get the database connection working again? Note: If I were to create another .odb with a different connection, e.g. ‘direct’, I would lose all macros, queries, forms, reports stored in the currently inaccessible .odb schemata
Version: 18.104.22.168 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
For the moment, I have discovered that the name of the file referred to in the Class Path (or the actual file name) had been changed - not by me, but possibly during the course of recent repository updates.
All works as before. I would not have noticed it without your inputs, especially the ‘recipe’ above. so many thanks for the tips!
For the moment, I won’t experiment with the mariadb connectors until I have made sure that Plan Bs are in place.
Yes, that package contains the MySQL Connector but, “hnimmo” is using the MariaDB –
The question is, will the MySQL Connector be reliable enough when used with a MariaDB instance or, will the MariaDB Connector .jar file have to be downloaded from the MariaDB site?
«There ain’t no openSUSE package containing the MariaDB connectors … »
I’ll ask at the conference either later today or tomorrow …
Yes, that’s what we figured out at the Conference this afternoon –
Java – owned by Oracle.
MySQL – owned by Oracle.
The MySQL Java class for the JDBC driver Connector is, at the end of the day a Java class and, it may well, therefore, function with MariaDB which also understands MySQL but, the reliability may well not be as good as that for the case that, the MariaDB Connector Java Class is used …