4 Types of JDBC Drivers CRB Tech Reviews will discuss about JDBC Driver which is a software component that enables java program to interact with the data source. There are 4 kinds of JDBC drivers:
1.
JDBC-ODBC link driver
2.
Native-API driver (partially java driver)
3.
Network Technique driver (fully java driver)
4.
Thin driver (fully java driver)
1) JDBC-ODBC link driver The JDBC-ODBC link driver uses ODBC driver to connect to the data source. The JDBC-ODBC link driver transforms JDBC method phone calls into the ODBC operate phone calls. This is now discouraged because of slim driver. Advantages: •
Easy to use.
•
Can be easily connected to any data source.
Disadvantages: •
Performance degraded because JDBC method call is converted into the ODBC operate phone calls.
•
The ODBC driver needs to be set up on the consumer device.
2) Native-API driver The Local API driver uses the client-side libraries of the data source. The motorist transforms JDBC method phone calls into native phone calls of the data source API. It is not published entirely in java. Advantage: •
Performance upgraded than JDBC-ODBC link driver.
Disadvantage: •
The Local driver needs to be set up on the each customer device.
•
The Source customer collection needs to be set up on customer device.
3) Network Protocol driver The Network Protocol driver uses middleware (application server) that transforms JDBC phone calls straight or indirectly into the vendor-specific data source protocol. It is completely published in java. Advantage: •
No customer part collection is needed because of program server that can perform many tasks like auditing, load balancing, logging etc.
Disadvantages: •
Network support is needed on customer device.
•
Requires database-specific programming to be done in the center level.
•
Maintenance of Network Protocol driver becomes costly because it needs database-specific programming to be done in the center level.
4) Thin driver The slim driver transforms JDBC phone calls straight into the vendor-specific data source protocol. That is why it is known as slim driver. It is completely published in Java language. Advantage: •
Better efficiency than all other motorists.
•
No software is needed at customer part or server part.
Disadvantage: •
Drivers depend on the Database.
Thus our CRB Tech Reviews end here.