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 c:\java\jdbc\pgms All the unzipped personal oracle is in c:\java\jdbc\pgms\oracle The full oracle stuff is at c:\oracle.... 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 classes12.zip 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 technet.oracle.com 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?