Skip to Main Content

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.

Driver class not found

790669Aug 10 2010 — edited Aug 17 2010
I just migrated from SQL Developer Version 1.5.1 to Version 2.1.1.64. I'm getting Driver class not found error when i try to connect SQL Server Database. It works fine with my old version.
All my oracle DB connections are working fine but its not working with non oracle db.

Here are my problems
1. I don't see the SQLServer tab in the connect wiz of 2.1 whereas i see this in 1.5
2. Imported all my connections to 2.1. When i right click and connect i get this error "Driver Class not found"
3.When i do a test connection with 2.1 it throws a different error. Error: Invalid connection information specified. Verify the URL format for the specified driver.
Here is the URL in the custom box. In the advanced connection type option
jdbc:jtds:sqlserver://xyz:1433;databaseName=zzz:1433/

Can somebody help on this issue. Pl let me know if you need more info.
This post has been answered by 561237 on Aug 13 2010
Jump to Answer

Comments

561237
The no SQLServer tab in the connection properties sounds like you have not registered the necessary third party jdbc driver in 2.1 yet. Do you have anything listed in Tools > Preferences > Database > Third Party JDBC Drivers?

I would guess that this will be empty in 2.1 (or maybe referring to an invalid location) but list a valid file in 1.5. It should just be a matter of registering the same file in 2.1 as you have in 1.5.

theFurryOne
-K-
BTW, you did install 2.1.1 in a new, clean directory (as clearly stated in the release notes and on download), didn't you? If you overwrite a previous version, you'll get unexpected behaviour.

Regards,
K.
790669
Hi,
Thanks for your response.

Tools > Preferences > Database > Third Party JDBC Drivers is empty in both the versions.
790669
Hi, Thanks for your response.
I did install in a clean new directory.
561237
Answer
So that probably means with your 1.5 install you have an extension (Tools > Preferences > Extensions) for the SQL Server JTDS or Migrations for SQL Server, which is an alternative to the specific SQL Server jdbc driver option which I have used.

For your 2.1 install, you can either download jtds jar (from http://jtds.sourceforge.net) and register it as a third party jdbc driver (this is what I have done) or use Check for Updates to download JTDS JDBC Driver for Microsoft SQL Server.

theFurryOne
Marked as Answer by 790669 · Sep 27 2020
790669
Thanks, the problem got resolved. i just went to the (Tools > Preferences > Extensions) and followed the "check for updates" wizard to download the JTDS. After the install i could now see the SQL Server tab coming up and i could now connect to the SQL server DB.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 14 2010
Added on Aug 10 2010
6 comments
7,756 views