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

What is foreach loop in java?

538


What are the restrictions that are applied to the java static methods?

534


How can we create a thread in java?

590


What is the program compilation process?

589


What is append in java?

633






What are measurable parameters?

571


What is a literal coding?

517


Can classes declared using the abstract keyword cab be instantiated?

564


What is method overloading with type promotion?

581


What is java life cycle?

541


What is ascii format?

555


What is the reason behind using constructors and destructors?

558


Why wait(),notify(),notifyAll() methods defined in Object class althought we are using in only threads.

2377


What is a singleton class in Java?

514


Why is it called a string?

569