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 choose jdbc driver type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "choose jdbc driver type " Watch "choose jdbc driver type " New topic

choose jdbc driver type

kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1383
What are the basic criteria to choose jdbc driver type ?
Frederic Filiatrault
Ranch Hand

Joined: Jul 12, 2004
Posts: 69
Depending on what you want to do, I'll say get the latest version of Type 4, which is the fastest. Try to use Stored Procedure, is it faster or if you cannot, use ANSI SQL with inner join, which is 40% faster that normal queries.

Hope this will help !

F.<br />SCJP, SCJD, SCWCD, SCBCD<br /> <br />Failure is not an option... It comes with the software bundle.
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

Since this question has nothing to do with Servlets, I'll move it to JDBC where all the Database junkies hang out.

GenRocket - Experts at Building Test Data
It is sorta covered in the JavaRanch Style Guide.
subject: choose jdbc driver type