Here's my (really Oracle's) code:
import java.sql.*;
class OracleTest {
public static void main (String args []) throws SQLException {
// Load Oracle driver
DriverManager.registerDriver (new
oracle.jdbc.driver.OracleDriver());
// Connect to the local database
Connection conn =
DriverManager.getConnection ("jdbc:oracle:oci7:@help", "Peter",
"Peter");
// Query the employee names
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select Assignee from Problem");
// Print the name out
while (rset.next ())
System.out.println (rset.getString (1));
}
}
Here's my error:
java.lang.UnsatisfiedLinkError: no oci73jdbc in shared library path
at java.lang.Runtime.loadLibrary(Runtime.java:440)
at java.lang.System.loadLibrary(System.java:569)
at oracle.jdbc.oci7.OCIDBAccess.logon(OCIDBAccess.java:138)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:93)
at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:146)
at java.sql.DriverManager.getConnection(DriverManager.java:91)
at java.sql.DriverManager.getConnection(DriverManager.java:134)
at OracleTest.main(OracleTest.java:11)
I've found "oci73jdbc.dll" and tried to put it in just about everywhere
imaginable. I've
mucked with my PATH and CLASSPATH variables to no avail.
Please help! I don't know much about Windows 95 or Oracle and I'm
feeling
more lost by the minute.
Thanks, Peter DeAngelis
I have the same problem which I haven't yet solved, but am trying to. If I
manage to solve it I'll let you know how. If you solve it please let me know
how !!
Andy.
Peter A. DeAngelis wrote in message <354F93D1...@lmco.com>...
Try to put it in your \oracle\bin directory, where your OCI drivers
are.
jchuang
- Erik