This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
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 REST with Spring (video course) this week in the Spring 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!