Re: Oracle Problem

[Veerendra Jote]

Hi Souvik,

I guess ur classpath shuold include, classes12.jar/zip and not classes111.jar/zip.

check up and then try.

also try to copy classes12.jar/zip to ur default java install's lib directory.

 

Regards

Veeren

-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]On Behalf Of Souvik Basak
Sent: Tuesday, June 17, 2003 12:10 PM
To: [EMAIL PROTECTED]
Subject: Oracle Problem

Hi,
   I have installed Oracle 9i in my machine. I'm using WindowsNT with SP6. I have put classes111.zip in CLASSPATH variable. The folowing code

  import java.sql.*;

public class TestSQL {
    public static void main (String [] a){
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
             System.out.println("Driver loaded");
            Connection con = DriverManager.getConnection("jdbc:oracle:thin:[EMAIL PROTECTED]:sid","username","password");
            System.out.println("Connection Created");
            Statement stmt = con.createStatement();
            System.out.println("System created");
            ResultSet rs = stmt.executeQuery("Select * from tab;");
            System.out.println("Query Executed");
            while(rs.next()){
                     System.out.println(rs.getString("TNAME"));
            }
            stmt.close();
            con.close();
        }catch (Exception ex){
              ex.printStackTrace();
         }
    }
}

gives
Driver loaded
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at TestSQL.main(TestSQL.java:8)

please help.
-- Souvik Basak