Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


jdbc drivers?

Answers were Sorted based on User's Feedback



jdbc drivers?..

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

Is This Answer Correct ?    8 Yes 3 No

jdbc drivers?..

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.

Is This Answer Correct ?    7 Yes 2 No

jdbc drivers?..

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

Is This Answer Correct ?    2 Yes 0 No

jdbc drivers?..

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 :)

Is This Answer Correct ?    1 Yes 0 No

jdbc drivers?..

Answer / devnaga

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

Is This Answer Correct ?    0 Yes 2 No

jdbc 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.

Is This Answer Correct ?    0 Yes 2 No

jdbc 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

Is This Answer Correct ?    1 Yes 3 No

jdbc drivers?..

Answer / laxmi

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

Is This Answer Correct ?    0 Yes 3 No

Post New Answer



More Core Java Interview Questions

Explain Connection Pooling?

3 Answers  


What are default methods ?

0 Answers  


Is int a class in java?

0 Answers  


What are the classes of java?

0 Answers  


What happens when you invoke a thread’s interrupt method while it is sleeping or waiting?

0 Answers  






what is Assertion?

4 Answers   Wipro,


what are the diffrences between interface and abstract class?

4 Answers  


When will we use class loader?

2 Answers  


What is the difference between parameters and arguments ?

2 Answers  


what is servlet filter?

2 Answers  


What is your platform?s default character encoding and how to know this?

0 Answers   TCS,


What do you mean by platform independence of Java?

0 Answers  






Categories