im trying to connect to oracle server which is in linux. From a different machine in which i have oracle client and windows 2000 im trying to connect im using oci8 driver. im getting the error java.lang.UnsatisfiedLinkError: do_open at oracle.jdbc.oci8.OCIDBAccess.do_open(Native Method) at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java) at oracle.jdbc.driver.OracleConnection.(OracleConnection.java) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja va) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at Offline$connect.run(Offline.java:126) pl any body help me thanx in advance sundar
you need to set the Path as well as classpath when using the OCI drivers: JDBC OCI Driver: If you are installing the JDBC OCI driver, you must also set the following value for the library path environment variable On Solaris, set LD_LIBRARY_PATH as follows: [Oracle Home]/lib
This directory contains the libocijdbc9.so shared object library. On Windows NT, set PATH as follows: [Oracle Home]\lib
This directory contains the ocijdbc8.dll dynamic link library.