JDBC Type 3 Driver(Net Protocol driver)
In Type 3 driver, a three-tier approach is used to accessing databases. The JDBC clients use standard network sockets to communicate with an middleware application server. The socket information is then translated by the middleware application server into the call format required by the DBMS, and forwarded to the database server.
This kind of driver is extremely flexible, since it requires no code installed on the client and a single driver can actually provide access to multiple databases.
You can think of the application server as a JDBC "proxy," meaning that it makes calls for the client application. As a result, you need some knowledge of the application server's configuration in order to effectively use this driver type.
Your application server might use a Type 1, 2, or 4 driver to communicate with the database, understanding the nuances will prove helpful.
- Serves as a pure java driver and are auto downloadable.
- Does not require native libraries on the client machine.
- Allows a single driver to access multiple databases.
- Configures the database details in the middleware server, instead of providing these details to the client.
- Follows 3-tier architecture hence it allows to access the database between the networks and manage the database resources accurately.
- Provides slow communication due to the increased number of network calls.
- Too cost as compared to other drivers.
Java Training | Python Training | Machine Learning with Python Training | Deep Learning with Python Training | Data Science with Python Training | Projects
SILAN Technology, BBSR Call to: 9439202111 | 9658317757 | 0674-2361252