aspose file tools*
The moose likes JDBC and the fly likes performance of Type-2 and Type-4 drivers..?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "performance of Type-2 and Type-4 drivers..??" Watch "performance of Type-2 and Type-4 drivers..??" New topic
Author

performance of Type-2 and Type-4 drivers..??

abhishek pendkay
Ranch Hand

Joined: Jan 01, 2007
Posts: 184
do Type-2(part java part native) drivers offer better performance for SQL and PL-SQL operations as compared to Type-4(pure java) drivers..???


The significant problems we face cannot be solved by the same level of thinking which created them – Einstein
SCJP 1.5, SCWCD, SCBCD in the making
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3716
    
    5

There's no one right answer to the question, although here's a quick comparison chart from the JavaRanch Faq: JDBC Driver Types

In theory type 2 would be better, but I suggest you run actual performance comparisons on the types of queries and data you expect to run. There may be other issues such that the performance difference is negliable or possibly worse for using type 2.


My Blog: Down Home Country Coding with Scott Selikoff
 
wood burning stoves
 
subject: performance of Type-2 and Type-4 drivers..??