Exception while creating a DataBase Connection (Unix)

Hello Friends,

I am Trying to create a DataBase Connection using OCI in java on UNIX Platform, but it gives an error message:

Exception in thread "main" java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path

at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1542)

at java.lang.Runtime.loadLibrary0(Runtime.java:795)

at java.lang.System.loadLibrary(System.java:834)

at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java)

at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)

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 TestDBConn.<init>(TestDBConn.java:16)

at TestDBConn.main(TestDBConn.java:35)

I have also checked my environment variables which seems to be correct, just have a look:

$ echo $ORACLE_HOME

/oratest/ora/proddb/9.2.0

$ echo $CLASSPATH

/oratest/ora/proddb/9.2.0/jdbc/lib

$ echo $LD_LIBRARY_PATH

/oratest/ora/proddb/9.2.0/lib

Please help in solving this problem...

Thanks in Avance,

Ankur

[1312 byte] By [AnkurBhatiaa] at [2007-10-3 5:11:20]