This driver is very flexible allows access to multiple databases using one driver. If you are targeting for large number of users, performance benefits, three tier architecture, scalability and portability this the best choice. Using the above three information you can really show some in depth information to the end user. All JDBC drivers are divided in to four types as defined below: Please help improve it to make it understandable to non-experts , without removing the technical details. The driver is platform-dependent as it makes use of ODBC which in turn depends on native libraries of the underlying operating system the JVM is running upon. Actually the error code table is huge do look in to documentation for more depth.
|Date Added:||1 November 2004|
|File Size:||41.19 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
This returns us vendor specific error code which can be useful in case the driver itself has some errors. Above is the code snippet which makes the select.
The use of this driver is discouraged if the alternative of a pure-Java driver is available.
Developers prefer this driver only for prototyping purpose and avoid them for actual development. Type 3 drivers are the right choice for three-tiered approach and they can only be implemented with three-tier architecture.
This article has multiple issues. The driver is implemented in the sun. Paid and Free Tests.
Type 3 database requests are passed through the network to the middle-tier server. Usually not thread safe.
JDBC Driver Types
Oracle will have oracle native api. This page was last edited on 25 Septemberat The one big issue is if you are changing the database you need to also change the driver which means you need to change the connection string to load the driver. Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine. Interview Questions and Tutorials. The middle-tier application server converts JDBC calls directly or indirectly into a vendor-specific database protocol.
is JDBC ? Explain Types Of Drivers with Advantage and Disadvantage ?
The first two characters define the class of the state and the three characters later define subclass of the error code. So if you want to odhc any database related error below is the code snippet to go about it: Not good for the Web. Lot of inconsistency in code as we are dealing with different vendor API.
There are four major components in JDBC. How do you handle SQL exceptions?
Contact links Contact Us Report a Bug. It tests the drivers by calling the method Driver. All JDBC drivers are divided in to four types as defined below: This technology isn’t suitable for a high-transaction environment.
It depends on the number of databases the middleware has been configured to support. First the DriverManager tries to use each driver in the order it was registered.
As we have middle tier we can do caching and load balancing. Mostly obsolete now 5. This driver communicates directly with the database server.
JDBC driver – Wikipedia
This driver is native code and not Java, and is closed source. The type 2 driver is not written entirely in Java as it interfaces with non-Java code that makes the final database calls. Next Post Meta Data. Java is a trademark of Sun Microsystems, Inc. It requires another server application to install and maintain.