Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error "Driver class not found" when accessing MySQL: Solution? How to specify new java driver?

pstein-JavaNetSep 19 2018 — edited Sep 22 2018

I retieved an older backup from end of 2016 from my archive disk with SQL Developer v4.1.5 to access local MySQL Database v5.7.22 on 64bit Win 7 with installed 32 bit Java v1.8.0_181. MySQL and Java was NOT part of this backup archive file.

When I started this older SQL Developer I got an error popup:

"An error was encountered performing the requested operation:

Driver class not found

Verify your Driver location"

So I guess SQL Developer missed a newer MySQL java jdbc driver which matches the (meanwhile installed newer Java or MySQL).

Due to some reasons I don't want to use SQL Developer v18.2 yet.

So I must fix it for SQL developer v4.1.5

How do I get a newer, corresponding java driver for Java v1.8.0_181 and MySQL v5.7.22 and specify it in SQL Developer v4.1.5?

Peter
This post has been answered by B.Delmée on Sep 19 2018
Jump to Answer

Comments

thatJeffSmith-Oracle

We don't handle the MySQL driver, you do.

In the preferences, on the third party drivers page. Point to the driver you want to use.

1 person found this helpful
B.Delmée
Answer

One adds JDBC JAR drivers to sqldeveloper via the "tools/preferences/database/Third party JDBC drivers" dialog.

If you had one previously working, checking its path would tell you where to get it from your backup.

Marked as Answer by pstein-JavaNet · Sep 27 2020
1 person found this helpful
pstein-JavaNet

Ok, thank you.

Meanwhile I download the MySQL JDBC connectors for Java. Which of the two possible *.jar files to I have to Add in SQL Developer:

mysql-connector-java-5.1.47.jar

or

mysql-connector-java-5.1.47-bin.jar

What are the differences?

Peter

cormaco

I found this in the Release Notes:

https://dev.mysql.com/doc/relnotes/connector-j/5.1/en/news-5-1-46.html

The bundle for Connector/J 5.1 delivered by Oracle now contains an additional jar package with the name mysql-connector-java-5.1.ver.jar (mysql-connector-java-commercial-5.1.ver.jar for commercial bundles). It is identical with the other jar package with the original package named mysql-connector-java-5.1.ver-bin.jar (mysql-connector-java-commercial-5.1.ver-bin.jar for commercial bundles), except for its more Maven-friendly file name. (Bug #27231383)
1 person found this helpful
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 18 2018
Added on Sep 19 2018
#sql-developer
4 comments
4,900 views