What are the different types of JDBC drivers are used in the JAVA technology? What do we need to do install the drivers for the JDBC, and where should we download the same?
What are the different types of JDBC drivers are used in the JAVA technology? What do we need to do install the drivers for the JDBC, and where should we download the same?
Following are the JDBC driver that each time for the installation they required...Type 1 driver translates all JDBC calls into ODBC calls and sends them to the ODBC driver. 1. A JDBC-ODBC bridge Type 2 drivers convert JDBC calls into database-specific calls i.e. this driver is specific to a particular database. 2. A native-API partly Java technology-enabled driver database requests are passed through the network to the middle-tier server. 3. A net-protocol fully Java technology-enabled driver The Type 4 uses java networking libraries to communicate directly with the database server. 4. A native-protocol fully Java technology-enabled driver
A JDBC-ODBC bridge provides JDBC API access via one or more ODBC drivers. The JDBC DriverManager class defines objects which can connect Java applications to a JDBC driver. Note that some ODBC native code and in many cases native database client code must be loaded on each client machine that uses this type of driver.
The JDBC API defines the Java interfaces and classes that programmers use to connect to databases and send queries. The JDBC-ODBC Bridge allows access to almost any database, since the database's ODBC drivers are already available. A JDBC driver implements these interfaces and classes for a particular DBMS vendor. A native-protocol fully Java technology-enabled driver converts JDBC technology calls into the network protocol used by DBMSs directly. This allows a direct call from the client machine to the DBMS server and is a practical solution for Intranet access.
Bookmarks