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
What does 0 mean in boolean?
how to deploy tomcatserver to weblogic server? write d following steps?
What is a constructor, constructor overloading in java?
How is it possible for two string objects with identical values not to be equal under the == operator?
Class c implements interface I containing method m1 and m2 declarations. Class c has provided implementation for method m2. Can I create an object of class c?
Difference between stack and queue?
What is garbage collector?
Can we create our own wrapper class in java?
Can extern variables be initialized?
What is byte code and why is it important to java’s use for internet programming?
Does java list allow null?
What does percent mean in java?
In a class implementing an interface, can we change the value of any variable defined in the interface?
Difference between arraylist and vector.
What does compareto () do in java?