File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Compiling using oracle JDBC drivers 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 "Compiling using oracle JDBC drivers" Watch "Compiling using oracle JDBC drivers" New topic

Compiling using oracle JDBC drivers

Charles Hasegawa
Ranch Hand

Joined: May 22, 2003
Posts: 117
We have clients that run either Oracle 8i or 9i, so of course our build has to vary the included oracle JDBC drivers to match their system ( or
The question I have is: does is matter which file we use when we compile the system? Our product compiles fine using either file. The question then is if we always compile using one or the other, but include the correct one for run time, do you see anyplace that might cause issues?
Loren Rosen
Ranch Hand

Joined: Feb 12, 2003
Posts: 156
The one issue I can see is if you are using any of the Oracle jdbc extensions, since these might have changed (but probably in an upward compatible way).
Similarly, these two releases might depend on different versions of JDBC itself (though again, I think any changes made were upward-compatible).
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

Although I haven't studied the Oracle documentation extensively, I'm sure that most of the differences are detailed there. One problem I do recall encountering -- but later saw in the documentation -- was the mapping of the DATE data-type. With the Oracle 8i JDBC driver, the "getObject()" method of "java.sql.ResultSet" returns a "java.sql.Timestamp" object for a database table column with the DATE data-type. However, with the Oracle 9i JDBC driver, the same method returns a "java.sql.Date" object (not the same thing!).
Good Luck,
I agree. Here's the link:
subject: Compiling using oracle JDBC drivers
It's not a secret anymore!