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?
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).
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.