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!

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

Alex Keh-Oracle

These two errors have different root causes.

The first error is indicative that you are trying to use 64-bit .NET with 32-bit ODP.NET or vice-versa. The bitness of .NET FW and ODP.NET have to match. Once they do, you will no longer see this error.

The second error is due to using a version mismatch between Oracle Client and ODP.NET. For example, your Oracle Client may be version 12.2, but ODP.NET is version 11.2. This can occur inadvertently when you have multiple Oracle Clients installed on a machine. ODP.NET, like any other DLL, will look for its dependent Oracle Client DLLs. The first ones ODP.NET finds, it will use, but those versions may not match ODP.NET's version. To fix this problem, use the DllPath setting in your .NET config file. Set the value to the bin directory from which your ODP.NET should look for its dependent Oracle Client DLLs.

1 - 1
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
5,567 views