Re: Oracle Problem

Hi,

Your connection url string is wrong.
It should be ""jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" +
sid
i.e., "jdbc:oracle:thin:@127.0.0.1:1521:sid","username","password")


Some more tips:

Better to use

    1. Class.forName ("oracle.jdbc.driver.OracleDriver").newInstance();

    or

    DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver ());

    2. classes12.zip (or classes12.jar) , since it's the latest

HTH
John


  -----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 2:40 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:127.0.0.1@1521: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