Re: Oracle Problem

[John Arockiaraj]

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:[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