Results 1 to 6 of 6

Thread: Conneccting libreOffice to MySQL database

  1. #1

    Default Conneccting libreOffice to MySQL database

    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. #2
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,264
    Blog Entries
    2

    Default Re: Conneccting libreOffice to MySQL database

    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/packag...reoffice+mysql

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  3. #3

    Default Re: Conneccting libreOffice to MySQL database

    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. #4
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,264
    Blog Entries
    2

    Default Re: Conneccting libreOffice to MySQL database

    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
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  5. #5

    Default Re: Conneccting libreOffice to MySQL database

    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. #6

    Default Re: Conneccting libreOffice to MySQL database

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •