How to Install a JDBC driver in Oracle SQL Developer?

JDBC driver is a software component. By using it java applications will be able to work up with a database or server. It is basically an application programming interface. JDBC is basically a bridge that interacts between all java applications & databases. It basically updates changes in the database. It is an important connection between them. As Oracle SQL Developer is a database, so with working with that everyone needs a JDBC driver installed on it. The installation process is very easy.

Features:

• It is the bridge between Java applications & Database connections.
• It is an application programming interface.
• It sends queries & updates statements to the database.
• It is a client-side adapter that converts a java program to a protocol.

Installing a JDBC driver in Oracle SQL Developer

Step 1: Browse to the website using any browser you like and then click on jtds.

Step 2: Then download the preferable version. There are different versions available for different types of operating systems. For my system, I will download the 1.2 version. If you have a new model you can easily download the latest version. There will be no trouble and no change in installation if you do so. 

Step 3: After clicking on the desired version it is advisable to download only the dist version, not any other one.

Step 4: After downloading open your Oracle SQL Developer. Then move to Tools and then preferences.

Step 5: There you need to click on Database, then SQL Formatter, and then Third-party JDBC driver. Next, you have to click on Add entry.

Step 6: Then you have to search for DRIVERS, then JDBC, then jtds version (for me it is jtds-1.2). Then you have to click on .jar file (for me it is jtds-1.2.jar). Then click on Select.

Step 7: Then press OK to complete the process.

Step 8: Then click on the plus(+) symbol.

Step 9: A new window will open in front of you and if you found that all details are mentioned there then you have successfully done your job.

Hence, your installation is successful.