wood burning stoves 2.0
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
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: 1430
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
I agree. Here's the link: http://aspose.com/file-tools
subject: choose jdbc driver type
It's not a secret anymore!