File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Compiling using oracle JDBC drivers

 
Charles Hasegawa
Ranch Hand
Posts: 117
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 156
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic