Get your CodeRanch badge!*
The moose likes JDBC and the fly likes Oracle: Type2 vs. Type4 drivers' performance Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle: Type2 vs. Type4 drivers Watch "Oracle: Type2 vs. Type4 drivers New topic

Oracle: Type2 vs. Type4 drivers' performance

Venkat Sadasivam
Ranch Hand

Joined: May 10, 2008
Posts: 139
I am using Oracle 10g database. For large rowset (more than 10,000 rows) retrieval which type of driver is better in terms of performance?

For long ago I read Type2 is better than Type4 in terms of performance. I don't know the recent changes in their implementation hence requesting your feedback.


“Any fool can write code that a computer can understand. Good programmers write code that humans can understand. ”<br>
-Martin Fowler
I agree. Here's the link:
subject: Oracle: Type2 vs. Type4 drivers' performance
Similar Threads
Oracle thin driver for jdk1.3
Type2/Type4 and preparedstatement relation?
Type3 and Type4 drivers for JDBC
Oracle Driver
JDBC drivers