Connecting Oracle 8x

[Uday Kumar]

I need some help in connecting to my Oracle database. This db server is on a machine in my network and my java class runs on my laptop(WinNT) using JDK1.3 and latest JDBC drivers.
I have set my classpath to include classes111.zip and classes12.zip and imported oracle.jdbc.driver.* in my class code. The code compiles fine but when executed thru DOS prompt I get the following error:-

Exception in thread "main" java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Test.main(Test.java:15)
<code snippet>
String url = "jdbc.oracle.thin:@1.1.1.11:1521:aaaa";
String driver = "oracle.jdbc.driver.OracleDriver";
Class.forName(driver);
Connection conn= DriverManager.getConnection(url, "uid", "password");
</code snippet>

Any help would be highly appreciated.
Uday
PS: Keep in mind, I am brand new to Java.
[ March 28, 2002: Message edited by: Uday Kumar ]

[Julio Carlos]

Hi, i have this code to connect to the Oracle 8.1.7 Database, i'm using JDK 1.2.2, and in my classpath i only have the classes12.zip, this is my code

import java.sql.*;
import java.text.*;
import oracle.jdbc.driver.*;
 
public class TestInsert{
    public static void main(String args[]){
        Connection dbConnection = conectaDB();
        PreparedStatement pstmt = null; 
        
        try{
            pstmt = dbConnection.prepareStatement("INSERT INTO XPASO VALUES('" + args[0] + "')");
            pstmt.executeUpdate();
        }
        catch(Exception e){
            e.printStackTrace();
        }
        finally{
            try {pstmt.close();} catch(SQLException e) {pstmt = null;}
            try {dbConnection.close();} catch(SQLException e) {dbConnection = null;}
        }
    }
    
  private static Connection conectaDB(){ 
    Connection con = null; 
    try{ 
      DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver());
      con = DriverManager.getConnection("jdbc:oracle:oci8:@","usr","pwd");
    }catch(Exception e){ 
      System.out.println("Fallo la conexion a La base de Datos"); 
      e.printStackTrace(); 
    }
    finally{
        return con;
    }
  }
}        

This work fine, i hope that this help you
JcSO
[ Edited by Dave to format code and fix ]
[ April 01, 2002: Message edited by: David O'Meara ]

[Uday Kumar]

Thanks for your help Julio Carlos :-). Since, I was out of town, I could not reply sooner.