This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC 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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Compiling using oracle JDBC drivers" Watch "Compiling using oracle JDBC drivers" New topic
Author

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 (classes12.zip or classes9i.zip).
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: 1131

Charles,
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,
Avi.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Compiling using oracle JDBC drivers