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

Explain creation of statement object with connection method create method with help of an example.

604


What are the advantages of database connection pooling?

566


Give an example of code used for setting up connection with a driver.

593


How do I insert/update records with some of the columns having NULL value?

589


Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?

570






What is execute in java?

595


Explain the role of driver in jdbc.

651


Explain some new features available in jdbc 4.0?

694


Does sql allow null values ? Can we use it within where clause ?

604


What are the jdbc statements?

652


Explain the main method?

636


What is the different between ResultSet and RowSet?

620


What are the considerations for deciding on transaction boundaries?

646


What is jdbc architecture in java?

541


What is jdbc and odbc in java?

571