what is difference between type 4 driver and type 1 driver?
Answer Posted / ashokkumar
Type 1 –(JDBC-ODBC bridge, plus an ODBC driver). The JDBC
API are implemented as mapping to other Database driver API.
All the JDBC calls will be translated to an ODBC request and
sent to ODBC driver,which then will be take care of the
request. This translation results in the degradation of
performance
Type4 -are direct-to-database pure Java drivers ("thin"
drivers). A Type 4 driver takes JDBC calls and translates
them into the network protocol (proprietary protocol) used
directly by the DBMS. Thus, client machines or application
servers can make direct calls to the DBMS server.Each DBMS
requires its own Type 4 driver; therefore, there are more
drivers to manage in a heterogeneous computing environment,
but this is outweighed by the fact that Type 4 drivers
provide faster performance and direct access to DBMS features.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
Is vector synchronized in java?
What are the two environment variables that must be set in order to run any java programs?
give an example for encapsulation?
Explain the difference between runnable and callable interface in java?
What do you mean by buffering?
Suppose if we have variable ' I ' in run method, if I can create one or more thread each thread will occupy a separate copy or same variable will be shared?
What is oop in java?
What is an immutable object? How do you create one in java?
What is starvation?
Describe the Big-O Notation.
What is the use of volatile in java?
How to compare strings in java?
What is the difference between compare and compareto in java?
What are the elements of java?
What are the various access specifiers for java classes?