Re: Trouble with Oracle 8i (8.1.5) JDBC Driver

It sounds to me like you're using the
Oracle JDBC driver to access Oracle's
native OCI driver. Try using the thin
client driver. i.e. change the url
[Quoted] that you use in Driver.getConnection() to

jdbc:oracle:thin:_at_<host>:1521:<SID>

assuming your Oracle8i listener is
listening on port 1521.

Dale Peters wrote:
>
> 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 CEST