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 Unsatisfied Link Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Unsatisfied Link Error" Watch "Unsatisfied Link Error" New topic

Unsatisfied Link Error

shree vijay
Ranch Hand

Joined: Sep 18, 2000
Posts: 208
Hi, This is my program portion which gives the error
conn = DriverManager.getConnection(
"jdbc : oracle : oci8:@shree",
"scott", "tiger");
shree is my sid in the oracle database.
I am working in
All the unzipped personal oracle is in
The full oracle stuff is at
I am able to compile my program, but when running it, the error is :
Exception in thread main java.lang.UnsatisfiedLinkError no ocijdbc8 in java.library.path
I have included in the classpath and
c:\oracle\ora81\jdbc\lib in the path

I am not able to run any demos that come with personal oracle since they give the same problem.
Is there anything wrong with my directory structure? What should I do ?
I am working in Win 98. I checked the FAQ at
and it says i should check whether I have shared object files and ORACLE_HOME\LIB is in my path. I guess shared object files is not needed for me as i am working in Windows. Also , in another FAQ i was told that I should include the environment variable LD_CLASS_PATH to ORACLE_HOME\bin. I did that too.
I am assuming that ORACLE_HOME is c:\oracle\ora81. Is that correct?

Thanks for the help,

I agree. Here's the link:
subject: Unsatisfied Link Error
It's not a secret anymore!