File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 REST with Spring (video course) this week in the Spring 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: 3749

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]
I agree. Here's the link:
subject: performance of Type-2 and Type-4 drivers..??
It's not a secret anymore!