Ask Your Question
0

LO base 'Driver com.mysql.jdbc.Driver could not be loaded'

asked 2020-01-13 13:51:04 +0200

Clockman gravatar image

I am attempting to make a direct connection to an exisitng MySQL database on my own PC. The error 'Driver com.mysql.jdbc.Driver could not be loaded' occurs after I have supplied the password for the SQL server.

I am using Windows 10 professional 64 bit LO 6.2.8.2 64 bit MySQL (community) 8.0.18 This works OK. Java 8 update 231 64 bit Java works fine within the LO base help system.

Any ideas which could lead to a solution will be greatly appreciated. Chris

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-01-14 12:53:28 +0200

Clockman gravatar image

Sorted it but don't know why I neede to do this. As a test I decided to set up an ODBC connection, fine. I then tried Java, this failed with the same error. After much trawling arounf the internet I found and downloaded from Oracle a .zip file containing, amongst other things, msql-connector-java-8.0.19.jar. In LO tools -> options -> advanced a screen with Java Options ticked and the name of my current jre appears. On this screen click 'Add Path' then navigate to or create C:\ProgramFiles\MySQL\Connector.J.8.0.19 and put the .jar files in it. Click OK a few times. A Java connection now works. Returning to the direct connection this also works. Remaining question: Why does a direct connection require the Java connector?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-01-13 13:51:04 +0200

Seen: 319 times

Last updated: Jan 14