File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes jdbc oci8 connectivity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc oci8 connectivity" Watch "jdbc oci8 connectivity" New topic

jdbc oci8 connectivity


Joined: Nov 05, 2003
Posts: 2
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(
at oracle.jdbc.driver.OracleConnection.(
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
at oracle.jdbc.driver.OracleDriver.connect(
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(
at Offline$
pl any body help me
thanx in advance
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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 shared object library.
On Windows NT, set PATH as follows:
[Oracle Home]\lib

This directory contains the ocijdbc8.dll dynamic link library.

you can read more in the Oracle9i JDBC Developer's Guide and Reference. The above exerpt was taken from chapter 2 - getting started.

Joined: Nov 05, 2003
Posts: 2
thanx for reply
but it is working with oracle server in winodows 2000 machine
but it is not working with oracle clint
what should i do
thanx in advance
I agree. Here's the link:
subject: jdbc oci8 connectivity
It's not a secret anymore!