Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC explanation of JDBC drivers
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Kalaiselvi.M
explanation of JDBC drivers
2 Answer(s)      6 years and 11 months ago
Posted in : JDBC


Need tutorial on JDBC drivers
Thanks!


Advertisement
View Answers

February 26, 2008 at 11:56 PM


Hello,

There are four types of JDBC drivers.

There are mainly four type of JDBC drivers available. They are:

Type 1 : JDBC-ODBC Bridge Driver
A JDBC-ODBC bridge provides JDBC API access via one or more ODBC drivers. 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. Hence, this kind of driver is generally most appropriate when automatic installation and downloading of a Java technology application is not important. For information on the JDBC-ODBC bridge driver provided by Sun.

Type 2: Native API Partly Java Driver
A native-API partly Java technology-enabled driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or other DBMS. Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine.

Type 3: Network protocol Driver
A net-protocol fully Java technology-enabled driver translates JDBC API calls into a DBMS-independent net protocol which is then translated to a DBMS protocol by a server. This net server middleware is able to connect all of its Java technology-based clients to many different databases. The specific protocol used depends on the vendor. In general, this is the most flexible JDBC API alternative. It is likely that all vendors of this solution will provide products suitable for Intranet use. In order for these products to also support Internet access they must handle the additional requirements for security, access through firewalls, etc., that the Web imposes. Several vendors are adding JDBC technology-based drivers to their existing database middleware products.

Type 4: JDBC Net pure Java Driver
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. Since many of these protocols are proprietary the database vendors themselves will be the primary source for this style of driver. Several database vendors have these in progress.

Since Type 4 driver directly talks with the database, the performance are very good. Due to very good performance type 4 driver is used.

Thanks


February 26, 2008 at 11:58 PM


Hi,

Here is another good explanation of JDBC drivers
http://www.roseindia.net/jdbc/jdbc-driver-and-its-types.shtml

Thanks


Related Tutorials/Questions & Answers:
jdbc drivers
jdbc drivers  what are the various kinds of jdbc drivers explain in detail
different JDBC drivers available
different JDBC drivers available  What are the different JDBC drivers available
Advertisements
type 4 drivers - JDBC
type 4 drivers  Hi! What is the syntax for Type - 4 drivers. give me any sample code. Thanks in advance..  Hi Friend, Please visit the following link: http://www.roseindia.net/jdbc/jdbc-driver-and-its
Database drivers - JDBC
.   Hi friend, There are four types of JDBC drivers known...-types.shtml Thanks.  Hi! we have four types of drivers. JDBC-ODBC... drivers: 1. Jdbc Odbc Driver: using this driver, the jdbc can be accessed via
Drivers
Drivers  How to insert Drivers in jdbc for java
Write to the log used by DriverManager and JDBC drivers.
Write to the log used by DriverManager and JDBC drivers.  How can I write to the log used by DriverManager and JDBC drivers
Types of JDBC drivers
JDBC Driver's Type JDBC Driver can be broadly categorized into 4 categories-- JDBC-ODBC BRIDGE DRIVER(TYPE 1)  Features 1.Convert the query of JDBC Driver into the ODBC query, which in return pass the data. 2.JDBC-ODBC
The required JDBC drivers to establish connectivity to my database part of the JDK.
The required JDBC drivers to establish connectivity to my database part of the JDK.  Are all the required JDBC drivers to establish connectivity to my database part of the JDK
explanation
the explanation in internet,but not very clear about it. Thank you
A Brief Introduction to JDBC
to different database applications using different JDBC drivers. JDBC.... JDBC Driver Types There are 4 types of JDBC drivers available. Type 1: JDBC-ODBC Bridge driver (Bridge) – They are JDBC-ODBC bridge drivers
Class.forName will do while loading drivers
Class.forName will do while loading drivers  What Class.forName will do while loading drivers
example explanation - Java Beginners
example explanation  can i have some explanation regarding the program given as serialization xample....  Hi friend, import java.io.*; import java.util.*; import java.util.Date; import java.io.Serializable
jdbc
jdbc  why do we need to load jdbc drivers before connecting to database
explanation to your code - Java Beginners
explanation to your code  sir, I am very happy that you have responded to my doubts in no time.Thank you very much.I saw the code u sent.Can i... classes.sir i need your brief explanation on this code and also your guidance.this
JDBC - JDBC
explanation of JDBC drivers  Need tutorial on JDBC driversThanks!  Hello,There are four types of JDBC drivers. There are mainly four type of JDBC drivers available. They are:Type 1 : JDBC-ODBC Bridge Driver A JDBC-ODBC
how to connect mySql drivers into eclipse(configuration)?
how to connect mySql drivers into eclipse(configuration)?  how to connect mySql drivers into eclipse(configuration)? I need the configuration in eclipse. what do i have to download from mySql and just downloading is enough or do
huffman code give the explanation for this code
huffman code give the explanation for this code  package bitcompress; class Compress extends BitFilter { private boolean encode_flag = false; private BitFilter next_filter = null; private int value; private
huffman code give the explanation for this code
huffman code give the explanation for this code  package bitcompress; class Compress extends BitFilter { private boolean encode_flag = false; private BitFilter next_filter = null; private int value; private
Java JDBC driver
Java JDBC driver  What are the different JDBC drivers available
The JDBC-ODBC Bridge.
The JDBC-ODBC Bridge.  Are there any ODBC drivers that do not work with the JDBC-ODBC Bridge
JDBC Driver
JDBC Driver  I want to know the clear syntax and usages of $ types of JDBC drivers. Where can i get it? I search for it, nobody give Syntax for tat different drivers. can u give a sample codes for tat
jdbc - JDBC
jdbc  What is the difference b/w jdbc driver and jdbc driver manager... Class.forName("foo.bah.Driver") The DriverManager will try to load as many drivers... and refer JDBC API. Thanks Rajanikant
jdbc - JDBC
drivers for concurrent access?   Question: Is the JDBC-ODBC Bridge multi-threaded? Answer: No. The JDBC-ODBC Bridge does not support concurrent access from different threads. The JDBC-ODBC Bridge uses synchronized methods
jdbc
jdbc  display the records using index in jdbc
JDBC
JDBC  why we use batch in jdbc
jdbc
jdbc  Hai , Give a steps for jdbc connectivity
Best JDBC Driver and Why - JDBC
Best JDBC Driver and Why   Hi Friends , In JDBC 4 drivers are there among this which is best and why. which driver is most commonly used in web application
 

 

 

DMCA.com