What are pros and cons of using of Type-2 and Type-4
Drivers over Type-1 driver?
- 4 Answers
- 7571 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / eswar
Type1 driver is bridge driver which is not written in java.
So it is not Platform Independent. we canot use this for
mulitple purpose It will stick to one OS thats y it is used
only for practical purpose....
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sujit kumar panda
type1 driver is platform depandent where type2 & type4 are
platform independent.also type1 driver is a thin driver
means it can handle very few request form client at time
but type 2 is a fat driver which is generally used in
banking solution for handling large numbers of request form
client.
| Is This Answer Correct ? | 1 Yes | 0 No |
write a query to select name from one table which has id,name and salary from another table which has id, sal where the salary is the second maximum
3 Answers Bosch, HireCraft, Infosys,
How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?
What are devices?
How to get the Database server details in java program?
What is executeupdate in java?
What type of drivers have you used?
What is the role of class.forname while loading drivers?
How can I create a custom RowSetMetaData object from scratch?
How do java applications access the database using jdbc?
How do I find jdbc version?
How to find total column from a resultset?
What is while rs next ())?
Core Java 
