[jimmycmkan]

Hi,

To use Oracle’s JDBC drivers in Weblogic, I usually modify the “startWebLogic.cmd” file to include the “classes12.zip” and “nls_charset12.zip’

e.g.
CLASSPATH=D:\oracle\ora81\jdbc\lib\classes12.zip;D:\oracle\ora81\jdbc\lib\nls_charset12.zip;%WEBLOGIC_CLASSPATH%;%POINTBASE_CLASSPATH%;%JAVA_HOME%\jre\lib\rt.jar;%WL_HOME%\server\lib\webservices.jar;%CLASSPATH%

To start Weblogic from within MyEclipse I tried to include the zip files in the path settings (Windows->Preference->MyEclipse->App Servers -> Weblogic8.1->Paths). However this does not work and I get an exception

java.lang.UnsatisfiedLinkError: no ocijdbc8 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1403)
at java.lang.Runtime.loadLibrary0(Runtime.java:788)
at java.lang.System.loadLibrary(System.java:832)
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)

whenever I load the driver.

Can anyone help? Thanks!

Jimmy

[jimmycmkan]

BTW, I’m using

MyEclipse : 2.5.0
WebLogic : 8.1
Oracle : 8i

Jimmy

[Scott Anderson]

Jimmy,

You need to add the zip files to the on the Paths preference page where it says “Append to classpath”. Then you need to add <orcle>/BIN directory to the java library path on the same page. It contains ocijdbc8.dll. Weblogic often ships with the necessary dll also. In WebLogic it’s often under <weblogic>/server/bin/oci817_8. Just add the containing directory for the dll to the java library path.

–Scott
MyEclipse Support

[jimmycmkan]

Thanks! It worked!

Jimmy

[Author]

Posts