I am trying to connect an Application to Oracle 8i running on the same
machine using Java JDBC. My test program is the demo program...
import java.sql.*;
class Employee
{
public static void main (String args [])
throws SQLException
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn =
DriverManager.getConnection ("jdbc:oracle:oci8:@", "scott", "tiger");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select ENAME from EMP");
while (rset.next ())
System.out.println (rset.getString (1));
rset.close();
stmt.close();
conn.close();
}
}
Compilation is OK but I am getting the following runtime error....
java.lang.UnsatisfiedLinkError: make_c_state
at oracle.jdbc.oci8.OCIDBAccess.make_c_state(Native Method)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:197)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:142)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:214)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:193)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at Employee.main(Employee.java:20)
My connection string ("jdbc:oracle:oci8:@", "scott", "tiger") and the SQL
("select ENAME from EMP") both work perfectly from SQLplus which indicates
my installation is OK.
Does any of this look suspicious to you?
How should I set up my installation? What imports should I use? I have set
the CLASSPATH as in the documentation to point to
%ORACLE_HOME%/jdbc/lib/classes111.zip.
btw.... I am using Forte4J
HELP! Many many thanks....
Andy