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.