File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "choose jdbc driver type " Watch "choose jdbc driver type " New topic
Author

choose jdbc driver type

kri shan
Ranch Hand

Joined: Apr 08, 2004
Posts: 1371
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: 15299
    
    6

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
 
Similar Threads
connection to mssql server database
All about JDBC
JDBC for Btreive
JDBC Drivers
JDBC Type $ Driver