Trouble with Oracle 8i (8.1.5) JDBC Driver

From: Dale Peters <petersda_at_muohio.edu>
Date: 2000/04/25
Message-ID: <3905DFF5.1BD32DB2@muohio.edu>#1/1

Environment: Win 95, jdk1.2.2, Oracle8 (8.1.5)

I'm having trouble connecting to an Oracle database from a java application. For test purposes, I'm just trying to run the Oracle demo application JdbcCheckup.java in the
oracle8/jdbc/demo/samples/oci8/basic-samples directory. The program is failing on the connection with an error that I'm unfamiliar with. I can connect to the database using SQL*Plus.

A listing of the environment variables that I have set, the command line, and the resulting stack trace is listed below. Any help would be greatly appreciated.

Thanks,
Dale

• Environment Variables *** C:\Oracle8\jdbc\demo\samples\oci8\basic-samples>set TMP=c:\windows\TEMP TEMP=C:\windows\TEMP PROMPT=$p$g winbootdir=C:\WINDOWS COMSPEC=C:\WINDOWS\COMMAND.COM WIN32DMIPATH=C:\DMI\ SYBVIDEO=18 SYBROOT=C:\SYBOOKS windir=C:\WINDOWS BLASTER=A220 I5 D1 T4 NWLANGUAGE=English WINDOWS_LOGIN=0 PATH=C:\ORACLE8\JDBC\LIB;Z:.;C:\NOVELL\CLIENT32;C:\ORACLE8\BIN;C:\WINDOWS;C:\WINDOWS\COMMAND;C:\ORAWIN95\BIN

CMDLINE=c:\jdk1.2.2\jre\bin\java -classpath .;c:\oracle8\jdbc\lib\classes111.zip
;c:\oracle8\jdbc\lib\nls_charset11.zip JdbcCheckup

• Command line (in a batch file) *** path c:\oracle8\jdbc\lib;%path% c:\jdk1.2.2\jre\bin\java -classpath .;c:\oracle8\jdbc\lib\classes111.zip;c:\oracle8\jdbc\lib\nls_charset11.zip JdbcCheckup
• Stack Trace *** Connecting to the database...Connecting... Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\Oracle8\BIN\ocijdb c8.dll: One of the library files needed to run this application cannot be found at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1319) at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1243) at java.lang.Runtime.loadLibrary0(Runtime.java:470) at java.lang.System.loadLibrary(System.java:778) at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:192) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:142)

        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja va:214)

        at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:193)

        at java.sql.DriverManager.getConnection(DriverManager.java:457)
        at java.sql.DriverManager.getConnection(DriverManager.java:137)
        at JdbcCheckup.main(JdbcCheckup.java, Compiled Code)

Received on Tue Apr 25 2000 - 00:00:00 CDT