|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Can't use AOO with MariaDB and JDBC | ||
|---|---|---|---|
| Product: | Base | Reporter: | Mechtilde <mechtilde> |
| Component: | code | Assignee: | AOO issues mailing list <issues> |
| Status: | CONFIRMED --- | QA Contact: | |
| Severity: | Blocker | ||
| Priority: | P2 | CC: | damjan, oooforum, petko |
| Version: | 4.2.0-dev | ||
| Target Milestone: | 4.2.0 | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | DEFECT | Latest Confirmation in: | --- |
| Developer Difficulty: | Medium | ||
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? (In reply to Mechtilde from comment #0) > I think it is necessary to be able to use both entries. But use both HOW? Should we allow the use of either driver for either database? Or should we add a "MariaDB" driver that is for MariaDB? |
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.