Re: Jdbc for Jdbc gurus

[Lurangwa N.]

Hi ;
I am having oracle 8.0.6 with JavaTM 2 SDK, Standard Edition Version 1.4.2 running on windows 2000 Client. I have setup env path as
   PATH=C:\jdk1.3\jdk\bin;C:\orant\jdbc\lib\classes102.zip;
   CLASSPATH=.;C:\orant\jdbc\lib\classes102.zip
/************** connection *******************/
In my source code i do the following:
   try
     {
           Class.forName ("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
              e.printStackTrace();
        }
        Connection conn = DriverManager.getConnection("jdbc:oracle:oci8:@oracl", "scott", "tiger"); 
              
        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
        while (rset.next())
              System.out.println (rset.getString(1));   // Print col 1
  
     stmt.close();
/***************** end ************************/

My program compiles well but when i run it , I get the following error
Exception in thread "main" java.lang.UnsatisfiedLinkError: no ocijdbc8 in java.l
ibrary.path
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1491)
        at java.lang.Runtime.loadLibrary0(Runtime.java:788)
        at java.lang.System.loadLibrary(System.java:834)
        at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:232)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:252)
        at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:365)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
      &nbs p; at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at Emp1.main(Emp1.java:20)

Can anyone tell me what is this all about!

I will appreciate any help

Lurangwa

 

---

Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage! ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html