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 DIFFERENT TYPES OF Jdbc Driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DIFFERENT TYPES OF Jdbc Driver" Watch "DIFFERENT TYPES OF Jdbc Driver" New topic
Author

DIFFERENT TYPES OF Jdbc Driver

Chetan Mehta
Ranch Hand

Joined: Aug 04, 2001
Posts: 40
Hi,
Can someone please tell me what are the differences between avaliable types?
How do we identify for a given scenario which is the best suitable driver for use?
I understand that we have type1, type2 , type3 and type4 driver avaliable by Specification.
I needed help understanding scenario where particular driver can be the best fit.
Thanks,
Chetan
Robert Brunner
Ranch Hand

Joined: Jul 18, 2001
Posts: 49
Originally posted by Chetan,Mehta:
Hi,
Can someone please tell me what are the differences between avaliable types?
How do we identify for a given scenario which is the best suitable driver for use?
I understand that we have type1, type2 , type3 and type4 driver avaliable by Specification.
I needed help understanding scenario where particular driver can be the best fit.
Thanks,
Chetan


Hi Chetan,
This is actually easy, although it may not seem so. Type 1 is the JDBC-ODBC bridge driver. You only use it for ODBC connections, like ACCESS or Excel. It is not for distributed Apps.
Type 2 is basically non-existant, don't even worry about them (they are part Java, part native code, thus DB specific code has to be installed on each client).
Type 3 drivers communicate in a database independant protocol with a special middleware server, which then communicates directly with your database. This type is nice if you want to be able to easily move your app between databases (but this is less important with introduction of datasources).
Type 4 is a high performance all Java driver which communicates direcxtly with the database of choice.
I would recommend you get a Type 4 if at all possible.
Cheers,
Robert
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DIFFERENT TYPES OF Jdbc Driver