What are pros and cons of using of Type-2 and Type-4
Drivers over Type-1 driver?

Answer Posted / chandrarekha

native API partly java driver(type-2 driver) doesn't have
the ODBC intermediate layer as the type 1 driver and the
native protocol pure java driver(type-4 driver) interacts
directly with the database(no native class libraries nor
driver as the intermediate layer) hence high perfomance
delivered compared to type-1 driver

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is odbc needed?

504


How many jdbc driver types are there?

493


How java can be connected to a database?

576


What does the jdbc resultset interface?

537


What are four types of JDBC driver?

578






Describe odbc?

567


Explain about DSN?

545


I have the choice of manipulating database data using a byte[] or a java.sql.blob. Which has best performance?

490


Which Java and java.sql data types map to my specific database types?

547


What is batch processing and how to perform batch processing in jdbc?

520


Discuss the procedure of retrieving warnings?

565


Where jdbc drivermanager class is used?

538


What is the difference between client and server database cursors?

613


Is odbc an api?

525


What are the utilities of the callablestatement?

529