javamysqljdbclibreoffice-base

LibreOffice: 'com.mysql.jdbc.driver' cannot be loaded

I am trying to connect LibreOffice Base with an MySQL database, in phpMyAdmin, with a JDBC-connection.

The first step is to select which database you want to select: Step 1

The second step is to select which connection: Step 2

The third step is to select your database: Step 3

When I press 'Klasse testen' ( Test Class ), I get the following error: 'com.mysql.jdbc.driver cannot be loaded'.

Does anyone know how to avoid this error?

Solution

  • You need to download and "register" the JDBC connector first. To do so:

    1. Go to http://dev.mysql.com/downloads/connector/j/ and download the ZIP archive with the JDBC connector ("Platform-Independent"); you may alternatively download the MSI installer; in this case, the jar file can be found in Program Files (x86)/MySQL/MySQL Connector J/ (assuming a Win 7 64bit system)

    2. Unzip the archive on your local PC (remember the path to its contents), or alternatively install the MSI file;

    3. In the extracted folder structure, there's a file "mysql-connector-java-5.0.8-bin.jar" (name depends on the exact version you've downloaded)

    4. Run LibreOffice (not Base, just LO);

    5. Open Menu Tools -> Options -> LibreOffice -> Advanced -> Class Path;

      enter image description here

    6. Click Add Archive;

      enter image description here

    7. Select the jar file from step 1-3 and hit OK. Now, the Class Pathdialog should look as follows:

      enter image description here

    That's it. Now, LO knows where to look for the MySQL JDBC Driver.