Oracle and JDBC frustration
I have been pulling my hair out trying to get this to work, perhaps someone has a solution.
I am trying to get a connection between Java (JDK 1.4.2) and Oracle 8 using the classess111.zip package. I finally was able to get a driver connection but when I run the application I get a java.lang.UnsatisfiedLinkError: no ocijdbc8 in java
runtime error. I have been playing with my enviroment variables and I beleive that I have everything correct in my PATH and CLASSPATH settings. Is it possible that since classess111.zip is meant to be used with JDK 1.1.8 that it is incompatible with my JRE version?
[619 byte] By [
jwarzecha] at [2007-11-27 5:56:08]
# 2
http://www.caucho.com/support/resin-interest/0402/0129.html
http://forum.java.sun.com/thread.jspa?forumID=48&messageID=967068&threadID=258345
"The Oracle JDBC drivers are compatible with JDK versions 1.0.2 and 1.1.x.
The Oracle JDBC drivers for version 8.1.5 do not support the JDK 1.2. "
This is a quote for the oracle documentation. You can look around their
website for the update for 1.2.*, I think it's still in beta though.
Reference:
https://lists.xcf.berkeley.edu/lists/advanced-java/2000-January/005497.html
# 4
I finally got it to work with help from a coworker who had the problem a few years ago. He remembered it had something to do with the enviroment. I copied his enviroment variables to my account and it worked. I found out that I had to add LD_LIBRARY_PATH=[Oracle Home]/lib
to my variable list(at least on Solaris) to get the classes111.zip driver to work with JDK 1.4.2 and Oracle 8. Thanks for your help, Dukes for you :0)
