This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes JDBC Drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Drivers" Watch "JDBC Drivers" New topic
Author

JDBC Drivers

David Cuthill
Greenhorn

Joined: Jun 12, 2001
Posts: 3
Hi Bjarki
Has your work/research for this book exposed you to a variety of vendor & other commercial JDBC drivers? As performance & stability are paramount in e-commerce apps, any opinions would be appreciated. Currently using SQL Server 2000 & Oracle.
Bjarki Holm
Author
Ranch Hand

Joined: May 25, 2001
Posts: 65
David,
most of my experience with relational databases is with Oracle. Oracle supplies two types of JDBC drivers, OCI and Thin. Since the OCI driver is a Type II driver, that makes use of native code, it might be natural to assume that it would give better performance than the Thin driver. My experience, however, is quite the opposite, especially if you obtain the latest driver edition (for 8.1.7). In addition, it is generally more simple to develop applications with the Thin driver (you are not dependent on Oracle client software at the middle tier). However, there are cases where you must use the OCI driver, such as when using public synonyms through JDBC (doesn't work with Thin). So each type has its cons and pros that must be evaluated for each application in question.
For SQL Server, I have mostly been using the JTurbo JDBC driver from http://www.jturbo.com. But, as I said, I don't work that much with SQL Server in the enterprise, so I don't really have any comparison there.
Cheers,
Bjarki
[This message has been edited by Bjarki Holm (edited June 12, 2001).]


Bjarki Holm
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Drivers
 
Similar Threads
How can we get Driver Info?
Class.forname() return
How to configurate the JDBC Explorer in JBuilder4
Usage of Polymorphism feature in a project
about jdbc drivers