Oracle 8i connection

Hi all !

I try to connect to Oracle database using jdk 1.3, and defining classpath = classe12.jar.

There's no problem at compilation but errors runtime.

Thanks, it's urgent !!!!!!

The source:

import java.sql.*;

import oracle.jdbc.driver.*;

public class OracleConnection

{

public static void main (String[] args)

{

String url = "jdbc:oracle:oci8:@oriluxd1";

try

{

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

Connection con = DriverManager.getConnection(url, "mbenamara", "mbenamara");

System.out.println("Connection is ready");

}

catch(SQLException sqle)

{

System.out.println(sqle.getMessage());

}

}

}

Runtime message:

java.lang.UnsatisfiedLinkError: no ocijdbc8 in java.library.path

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

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

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

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:517)

at java.sql.DriverManager.getConnection(DriverManager.java:177)at OracleConnection.main(OracleConnection.java:16)

[1542 byte] By [jjessy] at [2007-9-26 6:54:05]
# 1
The oci driver needs the Oracle OCI software installed on the client machine (the machine that is running the java.)There might be other sources for this, but the oracle client install installs it.
jschell at 2007-7-1 16:24:27 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...