JDBC - Type 3 Driver Last Updated : 03 Mar, 2021 Summarize Comments Improve Suggest changes Share Like Article Like Report A JDBC driver enables Java application to interact with a database from where we can fetch or store data. JDBC drivers are analogous to ODBC drivers. The JDBC classes are contained in the Java Package java.sql and javax.sql.JDBC helps to Connect to a data source, like a database.Send queries and update statements to the databaseRetrieve and process the results received from the database in answer to your query The Java.sql package that ships with JDK contain various classes with their behaviors defined and their actual implementations are done in third-party drivers. Third-party vendors implement the java.sql.Driver interface in their database driver. JDBC driver types are used to categorize the technology used to connect to the database. Type -1 Bridge driverType -2 Native APIType -3 Network ProtocolType -4 Native Protocol Type -3 Driver JDBC is also known as Network Protocol Driver as it uses an application server that converts JDBC calls directly or indirectly into the vendor-specific database protocol. This driver translates JDBC calls into the middleware vendor’s protocol, which is then converted to a database-specific protocol by the middleware server software that provides connectivity to many databases. Middleware is software that lies between an operating system and the applications running on it. Essentially functioning as a hidden translation layer, middleware enables communication and data management for distributed applications. While all middleware performs communication functions, the type a company chooses to use will depend on what service is being used and what type of information needs to be communicated. Advantages of Type-3 Driver It can be used when the user has multiple databases and want to use a single driver to connect all of them.No need to install driver code on the client machine as the Type-3 driver is based on the server.The back-end server component is optimized for the operating system on which the database is running.Gives better performance than Type 1 and Type-2 drivers. Disadvantages of Type-3 Driver When middleware runs on different machines Type-4 drivers can be more effective.It needs database-specific code on the middleware server. Comment More infoAdvertise with us Next Article JDBC New Features S sam_2200 Follow Improve Article Tags : Java Technical Scripter JDBC Practice Tags : Java Similar Reads JDBC Drivers Java Database Connectivity (JDBC) is an application programming interface (API) for the Java programming language that defines how a client can access and interact with any kind of tabular data, especially a relational database. JDBC Drivers uses JDBC APIs which was developed by Sun Microsystem, but 4 min read JDBC New Features JDBC stands for Java Database Connectivity. It is a crucial technology for Java developers and it facilitates the interaction between the Java applications and the databases. Now, JDBC 4.0 has evolved and introduced new features to improve performance, developer productivity, and security. JDBC has 6 min read Types of Statements in JDBC In Java, the Statement interface in JDBC (Java Database Connectivity) is used to create and execute SQL queries in Java applications. JDBC provides three types of statements to interact with the database:StatementPrepared StatementCallable Statement1. StatementA Statement object is used for general- 5 min read How to Install MongoDB Java Driver? The MongoDB Java driver allows Java applications to interact with MongoDB databases, providing a seamless way to perform database operations within our Java code. In this article, We will go through the steps to install the MongoDB Java driver and start integrating MongoDB into our Java projects.Fea 4 min read Spring - JDBC Template In this article, we will discuss the Spring JDBC Template and how to configure the JDBC Template to execute queries. Spring JDBC Template provides a fluent API that improves code simplicity and readability, and the JDBC Template is used to connect to the database and execute SQL Queries. What is JDB 7 min read JDBC Result Set Java Database Connectivity is Java-based technology and that provides a standard API for accessing databases in Java applications. The Key Component of Java Database Connectivity is the ResultSet. JDBC driver allows developers to read and manipulate data from the database. The JDBC ResultSet is Obje 8 min read Like