Thanks for that, I'll add your notes to the tomcat docs.
> -----Original Message----- > From: ahmet dalli [mailto:[EMAIL PROTECTED]] > Sent: 05 July 2002 11:30 > To: [EMAIL PROTECTED] > Subject: Tomcat4.04+Oracle8i(8.1.7)+JDBC/OCI HOWTO(some hints...) > > > Hi all, > > Here is what i learned from two days trying to access > an Oracle8i database using OCI driver. > > 1)In order to use OCI driver, you should have an > Oracle client installed. Suppose you have installed > Oracle8i(8.1.7) client from cd, and now you go to > otn(otn.oracle.com) and download the suitable JDBC/OCI > driver(Oracle8i 8.1.7.1 JDBC/OCI Driver) and after > renaming the "classes12.zip" file as "classes12.jar" > for Tomcat, you put it into somewhere so that > CLASSPATH references it, or directly into > %JAVA_HOME%\jre\lib\ext. > > You are sure that you have the "ocijdbc8.dll" is in > your PATH(possibly in %ORAHOME%\bin) and you have also > confirmed that it could be loaded by a simple test > program using "System.loadLibrary("ocijdbc8");". > You have a very simple test servlet that has tese > critical lines: > ^^^^^^^^^^^^^^^^^^^^^^^^^^ > DriverManager.registerDriver(new > oracle.jdbc.driver.OracleDriver()); > conn = > DriverManager.getConnection("jdbc:oracle:oci8:@database","user > name","password"); > ^^^^^^^^^^^^^^^^^^^^^^^^^^ > where database is of the form "host:port:SID" > > Now you try to access the URL > http://localhost/servlet/OracleOCIServlet (or > localhost:8080... if you use Tomcat without Apache) > and what you get is a > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > ServletException with a root cause of > java.lang.UnsatisfiedLinkError:get_env_handle. > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > You confirm that your simple program works with the > "thin" driver, you apply to Oracle metalink to no > avail...and you are stuck!!! > > First, this UnsatisfiedLinkError : " ...indicates that > you have a mismatch between your JDBC classes file and > your Oracle client version. The giveaway here is the > message stating that a needed library file cannot be > found. For example, you may be using a classes12.zip > file from Oracle Version 8.1.6 with a Version 8.1.5 > Oracle client. The classeXXXs.zip file and Oracle > client software versions must match."(Java Programming > with Oracle JDBC, from O'reilly). > > Second, give up the driver you have downloded from > otn, go to the directory %ORAHOME%\jdbc\lib and use > the classes12.zip file there.... > > This will rescue you from this UnsatisfiedLinkError. > > 2)You have so far changed the classes12.zip file from > otn with the one that came with your client > installation, and now you get this error: > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > ORA-06401 NETCMN: invalid driver designator > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > First, Oracle documentation says : > "Cause: The login (connect) string contains an invalid > driver designator. > Action: Correct the string and re-submit." > > Second, change the database(of the form > "host:port:SID") with this one: > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > (description=(address=(host=myhost)(protocol=tcp)(port=1521))( > connect_data=(sid=orcl))) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > Now, if everything else is pure, you must be accessing > Oracle8i. > > I hope these hints can help somebody struggling with > Tomcat/Oracle couple via OCI driver... > > Baris.... > > > __________________________________________________ > Do You Yahoo!? > Sign up for SBC Yahoo! Dial - First Month Free > http://sbc.yahoo.com > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
