Apache OpenOffice (AOO) Bugzilla – Issue 128035
Can't use AOO with MariaDB and JDBC
Last modified: 2020-04-04 16:19:52 UTC
I use AOO as a client for several databases. Most of them were originally created with MySQL. Now I use Mariadb on my Debian machines. There is no MySQL JDBC Driver available. I get the message: "Can't load com.mysql.jdbc.Driver" For using Mariadb there is an own JDBC Driver. The name of the driver class is org.mariadb.jdbc.Driver. I found hardcoded entries: main/connectivity/qa/complex/connectivity/JdbcLongVarCharTest.java 67 prop[0] = new PropertyValue("JavaDriverClass", 0, "com.mysql.jdbc.Driver", PropertyState.DIRECT_VALUE); main/connectivity/source/drivers/mysql/YDriver.cxx 183 ,makeAny(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.mysql.jdbc.Driver"))) 234 ::rtl::OUString sDriverClass(RTL_CONSTASCII_USTRINGPARAM("com.mysql.jdbc.Driver")); 354 ,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.mysql.jdbc.Driver")) main/connectivity/source/drivers/mysql/mysql.xcu 41 <value>com.mysql.jdbc.Driver</value> I think it is necessary to be able to use both entries.
You can probably use the generic "JDBC" driver type and enter that class name there, but let's leave this bug open for adding native MariaDB support too.
for documentation under Linux the class path is: /usr/share/java/mariadb-java-client.jar The data source URL is: jdbc:mysql://<server name>/<database name> If you want to edit data you must add "?useHostsInPrivileges=false"
Is this still open?
AtOmXpLuS : Everything in AtOmXpLuS.CoM
I have no problem to connect a MariaDB I use this extension to have a native MySQL driver: https://extensions.openoffice.org/fr/project/mysql-driver-apache-openoffice Maybe this could be integrated?