Conneccting libreOffice to MySQL database

English Applications
1

I have trouble connecting libreOffice to the mysql database.
I did as follows:

  1. Select database: Conect to an exiting database (MySQL)
  2. Set up MySQL connection (JDBC)
  3. Set up JDBC conection
    Database Name: (newric)
    Server; (192.168.0.2)
    Post number: (3306)
    MySQL.JDBC driver class: (com.mysql.jdbc.Driver)

After this Test Class shows an error message:
The JDBC driver could not be loaded.

I have also downloaded and tested “mysql-connector-java”, but
the result is the same: ‘could not be loaded’.

Did I do anything wrong, or is some software missing?

Any information to this effect would be highly appreciated.

I have also tried unixODBC, but with similar result.

Thanks for any help

2

You should try using the libreoffice native mysql connector before alternate options…

Looks like it’s in the libreoffice 6.0 repo, you can find it in the “Experimental” link on the following page
https://software.opensuse.org/package/libreoffice-base-drivers-mysql?search_term=libreoffice+mysql

TSU

3

Hello,
I use the connection as well and it worked fine until the latest updates of libreoffice after version 6.0.5.2
Meanwhile libreoffice has the version 6.1.5.2-30.3.x86_64, but the package libreoffice-base-drivers-mysql still has 6.0.5.2-24.2.

Has development of the driver been stopped?
Is there an alternative method to make the connection?

Greetings
Wega

4

I don’t know if any breakage is intentional or expected.
If it’s truly broken, recommend you roll back to the previous package…
And submit a bug report with details to https://bugzilla.opensuse.org.

Yes, there is an alternative…
But I doubt any alternative should be preferred over using the native connector especially if an older version is known to work.
On the MySQL Support site, there are guides (actually little more than suggestions) to set up either a jdbc or an odbc connector.

TSU

5

Hello,
thanks for the hint, there is already a bug entry concerning that problem https://bugzilla.opensuse.org/show_bug.cgi?id=1119104.
I hope, that the problem will be fixed.
Greetings
Wega

6

Hello,

I learned that LibreOffice contains an implemented MySQL driver since version 6.2. I updated to LibreOffice Version 6.2.2.2 and it works. Seems that libreoffice-base-drivers-mysql has become obsolete.

Greetings
Wega