Hi
I want to check the jdbc connection using weblogic 7.0 and Oracle 9.0.1.
To verify this I wrote the following program.
import java.sql.*;
public class TestOracle
{
public static void main(String args[])throws SQLException
{
try
{
Class.forName("weblogic.jdbc.oci.Driver");
String url = "jdbc:weblogic
racle
racledb";
Connection con = DriverManager.getConnection(url,"scott", "tiger");
con.close();
}catch(Exception e){ System.out.println(e); }
}
}
I get the following run time error:
java.lang.ClassNotFoundException: weblogic.jdbc.oci.Driver
I am using windows XP and have set the following in Environment->System Variables.
CLASSPATH settings in system variable
C:\oracle\ora90\jdbc\lib\classes12.zip;C:\bea\weblogic700\server\lib\weblogic_sp.jar;C:\bea\weblogic700\server\lib\weblogic.jar;
PATH settings in system variable
C:\bea\weblogic700\server\bin\oci901_8;C:\j2sdk1.4.0_03\bin;C:\oracle\ora90\bin;
JAVA_HOME: C:\j2sdk1.4.0_03
Please let me know what has gone wrong.