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

What are the differences between resultset and rowset?

530


What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?

516


What are the differences between execute, executequery, and executeupdate?

491


What is jsp and jdbc?

503


How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?

621






Differentiate between type_scroll_insensitive and type_scroll_sensitive.

524


What are the types of jdbc drivers that exist?

541


What driver should I use for scalable Oracle JDBC applications?

507


What are the advantages of using jdbc datasource?

497


Can I use JDBC to execute non-standard features that my DBMS provides?

557


What is JDBC ResultSet?

598


code to insert values/rows into oracle database from a java swing textfield when a button is pressed(using preparedstatements)

3887


Why do I get UnsatisfiedLinkError when I try to use my JDBC driver?

570


Where is mysql jdbc driver located?

522


What is represented by the connection object?

528