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


Please Help Members By Posting Answers For Below Questions

Can private members of a base class are inheritable justify?

496


Can finally block be used without a catch?

550


What is the function of static in java?

547


How can we pass argument to a function by reference instead of pass by value?

591


Can we have multiple classes in single file ?

616






What does super keyword do?

564


What do you understand by synchronization?

599


What are the types of literals?

572


Explain about features of local inner class?

607


There are two classes named classa and classb. Both classes are in the same package. Can a private member of classa can be accessed by an object of classb?

1006


What is package protected in java?

530


What is the intersection and union methods?

555


What is the byte order of byte buffer?

571


Can a static member function access member variable of an object?

566


What is a conditional equation?

567