{"id":75573,"date":"2020-01-20T11:01:30","date_gmt":"2020-01-20T05:31:30","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?p=75573"},"modified":"2024-04-12T14:33:38","modified_gmt":"2024-04-12T09:03:38","slug":"oracle-8i-with-oci-client","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/oracle-8i-with-oci-client\/","title":{"rendered":"Oracle 8i with OCI client"},"content":{"rendered":"

Introduction<\/strong><\/p>\n

Whilst not strictly addressing the creation of a JNDI DataSource using the OCI client, these notes can be combined with the Oracle and DBCP solution above.<\/p>\n

In order to use OCI driver, you should have an Oracle client installed. You should have installed Oracle8i(8.1.7) client from cd, and download the suitable JDBC\/OCI driver(Oracle8i 8.1.7.1 JDBC\/OCI Driver) from otn.oracle.com.<\/p>\n

After renaming classes12.zip file to classes12.jar for Tomcat, copy it into $CATALINA_HOME\/lib. You may also have to remove the javax.sql.* classes from this file depending upon the version of Tomcat and JDK you are using.<\/p>\n

Putting it all together<\/p>\n

Ensure that you have the ocijdbc8.dll or .so in your $PATH or LD_LIBRARY_PATH (possibly in $ORAHOME\\bin) and also confirm that the native library can be loaded by a simple test program usingSystem.loadLibrary(“ocijdbc8”);<\/p>\n

You should next create a simple test servlet or jsp that has these critical lines:<\/p>\n

DriverManager.registerDriver(new<\/p>\n

oracle.jdbc.driver.OracleDriver());<\/p>\n

conn =<\/p>\n

DriverManager.getConnection(“jdbc:oracle:oci8:@database”,”username”,”password”);<\/p>\n

where database is of the form host:port:SID Now if you try to access the URL of your test servlet\/jsp and what you get is a ServletException with a root cause of java.lang.UnsatisfiedLinkError:get_env_handle.<\/p>\n

First, the UnsatisfiedLinkError indicates that you have<\/p>\n