Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases 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

Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "performance of Type-2 and Type-4 drivers..??" Watch "performance of Type-2 and Type-4 drivers..??" New topic

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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3740

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.

[OCA 8 Book] [Blog]
Consider Paul's rocket mass heater.
subject: performance of Type-2 and Type-4 drivers..??
It's not a secret anymore!