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
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply 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: 1300
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
Ranch Hand

Joined: Jul 11, 2001
Posts: 15229

Since this question has nothing to do with Servlets, I'll move it to JDBC where all the Database junkies hang out.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: choose jdbc driver type
 
Similar Threads
JDBC Type $ Driver
JDBC for Btreive
connection to mssql server database
JDBC Drivers
All about JDBC