Answer / devnaga

Type 1: JDBC-ODBC Bridge
Type 2: Native API partly Java Driver
Type 3: Network protocol Driver
Type 4: JDBC Net pure Java Driver -> thin driver

Answer / srinivas

we have 4 types drivers
1)JDBC-ODBC bridge.
2)native-API partly Java technology-enabled driver.
3)A net-protocol fully Java technology-enabled driver
4)A native-protocol fully Java technology-enabled driver
-------------------------------------
1)JDBC-ODBC bridge:-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
----------------------------------------------------------------
2)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.
--------------------------------------------------------
3)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.
--------------------------------------------------------------
4)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.

Answer / devnaga

Type 1: JDBC-ODBC Bridge
Type 2: Native API partly Java Driver
Type 3: Network protocol Driver
Type 4: JDBC Net pure Java Driver

Type 1 Drivers

Bridge drivers such as the jdbc-odbc bridge. They rely on an
intermediary such as ODBC to transfer the SQL calls to the
database and also often rely on native code. It is not a
serious solution for an application
Type 2 Drivers

Use the existing database API to communicate with the
database on the client. Faster than Type 1, but need native
code and require additional permissions to work in an
applet. Client machine requires software to run.
Type 3 Drivers

JDBC-Net pure Java driver. It translates JDBC calls to a
DBMS-independent network protocol, which is then translated
to a DBMS protocol by a server. Flexible. Pure Java and no
native code.
Type 4 Drivers

Native-protocol pure Java driver. It converts JDBC calls
directly into the network protocol used by DBMSs. This
allows a direct call from the client machine to the DBMS
server. It doesn't need any special native code on the
client machine.
Recommended by Sun's tutorial, driver type 1 and 2 are
interim solutions where direct pure Java drivers are not yet
available. Driver type 3 and 4 are the preferred way to
access databases using the JDBC API, because they offer all
the advantages of Java technology, including automatic
installation. For more info, visit Sun JDBC page

http://faisalmb.50webs.com/kbinterviewjdbc.html

Answer / manish kushwaha

Hi All, i have gone through above answers they all are quit
well,

you can refer any ans i would like to add few points

1) JDBC-ODBC driver(TYPE-1) : this is performance wise okay,
maintenance is acceptable but the biggest problem is
platform dependency (so use only when your application is OD
specific).

2) Partial java and Partial native(TYPE-2): this is the
fastest driver available in market in java, the reason is it
is directly interacting with java library to database
library but maintenance wise it is not acceptable it is very
costly in maintenance(over all not acceptable because
maintenance cost is more).

3) net protocol driver(IDS server)(TYPE-3): this is not much
fast but maintenance is improve because they placed one IDS
server between the java library to database library(over all
not acceptable because performance is down)

4) pure java driver (TYPE-4): this is much good in both
performance and maintenance wise because driver is directly
interacting with db library.it is the second fast driver
among above four drivers.

for any other query you can drop me mail on
mails.manish1@gmail.com
i will love to solve your problem if i have solution :)

Answer / devnaga

Could anyone say in which circumsances do we use these drivers?

Answer / narasimha

For Stand alone applications u can use the type-1 driver
and when your db is network u canu use the Type-4 driver
but i i dont know about other drivers could any can tell me
when to use other drivers.

Answer / devarathnam

Hi... There are 4 type of drivers .
1:JDBC-ODBC BRIDGE OR (TYPE1)
2:PARTLY JAVA DRIVER OR(TYPE2)
3:NET PROTOCOL DRIVER OR(TYPE3)
4:PURE JAVA DRIVER OR THIN DRIVER OR(TYPE4)
Among these drivers TYPE4 driver will give u sophisticated
performance

Answer / laxmi

1>jdbc-odbc bridge driver
2>part java-part native driver
3>intermediate d/b acess server driver
4>pure java driver

Which class has no duplicate elements?

8 Answers  

What is a string what operation can be performed out with the help of a string?

0 Answers  

Is string is a class in java?

0 Answers  

what r callable statement and give their proper use

2 Answers  

how u do unit testing?

2 Answers   iFlex,

Can we assign the reference to this variable?

0 Answers  

Why would you desing a J2EE application so user data is entered by way of a JSP page and managed by an underlying Java Beans class?

5 Answers   Adobe,

3) Suppose you are a very rich person, having 50 rooms and you have lost the key for one of the room's. How effectively you can find this key? (Qs2 and Qs3 are related)

3 Answers   RBS,

How is the marker interface used in Java?

0 Answers   BirlaSoft,

does core java and j2se both are same?

5 Answers  

What do you understand by access specifiers in Java?

0 Answers   Genpact,

what is associative array

1 Answers   Tech Mentro,