Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Name few "optional" classes introduced with java 8 ?
Can you change array size in java?
What are the drawbacks for singleton class?
What is a subsequence of a string?
Mention a package that is used for linked list class in java.
what are three ways in which a thread can enter the waiting state? Or what are different ways in which a thread can enter the waiting state? : Java thread
What is considered an anti pattern?
Explain what access modifiers can be used for methods?
How do you convert an int to a string in java?
Explain the significance of listiterator.
What does main method?
what is nested class in java?
what is mutual exclusion? How can you take care of mutual exclusion using java threads? : Java thread
If goto and const is reserve words than why it is not work in java?
What do you mean by stream pipelining in java 8?
