Better performance than Type 1 since no jdbc to odbc translation is needed Disadvantage: It depends on the number of databases the middleware has been configured to support. JDBC allows a developer to write applications that is database independent. This returns us vendor specific error code which can be useful in case the driver itself has some errors. Oracle will have oracle native api. For instance in the above scenario we get a disconnect error and we would like our program to connect to some other server. Java is a trademark of Sun Microsystems, Inc.

Uploader: Maushakar
Date Added: 1 September 2004
File Size: 21.35 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 12110
Price: Free* [*Free Regsitration Required]

Type 3 drivers are the right choice for three-tiered approach and they can only be implemented with three-tier architecture. Basically there are four steps to connect to database using JDBC Same is highlighted in the above figure: By using this site, you agree to the Terms disadvabtage Use and Ndbc Policy.

The same client-side JDBC driver may be used for multiple databases. In short SQL State can be useful when we want our program to act depending on the severity of the error.

This driver is very flexible allows access to multiple databases using one driver. Second section is the middle ware or so called the application server which passes the request to database. Some distinctive characteristic of type 2 jdbc drivers are shown below. How do you handle SQL exceptions?


Statement object will be used to fire the sql. It is suitable for the web.

The driver is platform-dependent as it makes use of ODBC which in turn depends on native libraries of the operating system. The middle-tier application server converts JDBC calls directly or indirectly into a vendor-specific database protocol.

JDBC driver

The use of this driver is discouraged if the alternative of a pure-Java driver is available. The JDBC type 3 driver, also known disadvanntage the Pure Java driver for database middleware, [7] is a database driver implementation which makes use of a middle tier between the calling program and the database. The type 2 driver is not written entirely in Java as it interfaces with non-Java code that makes the final database calls. Usually not thread safe.

Java | JDBC JDBC API SQL Exception Handling Types Of Drivers JDBC ODBC Bridge Drivers |

Below is the code snippet for the same. No cleanup reason has been specified. At client side, a separate driver is needed for each database. There are four major components in JDBC. Better performance than Type 1 since no hdbc to odbc translation is needed Disadvantage: JDBC allows you to write Java code, and leave the platform database specific code to the driver.

But the connection string change is a small issue if you design your application architecture carefully you can really make it configurable. If we change the Database we have to change the native api as it is specific to a database 4. JDBC technology drivers fit into one of four categories.


Disadvantage With type 4 drivers, the user needs a different driver for each database. Developers prefer this driver only for prototyping purpose and avoid them for actual development.

JDBC driver – Wikipedia

Also, making use of the middleware provides additional advantages of security and firewall access. You can also find the setup installation in the CD supplied. For instance in the above scenario we get a disconnect error and we would like our program to connect to some other server.

Traversing the recordset may take longer, since the data comes through the backend server. In such cases, the order in which the drivers are tested is significant because the DriverManager will use the first driver it finds that can successfully connect to the given URL. Type 2 driver resides on the client along with the JAVA application. Next Post Meta Data.