jdbc error

[gani]

Hello Following is the error I am getting when I compile the code below:
import java.sql.*;
class JdbcTest {
public static void main (String args []) throws SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc racle ci8:@lmtest", "gani", "babu");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select sname from students");
while (rset.next ())
System.out.println (rset.getString (1));
}
}
error
--------------------------
JdbcTest.java:5: Exception java.lang.ClassNotFoundException must be caught, or it must be declared in the throws clause of this method.
Class.forName("oracle.jdbc.driver.OracleDriver");

Pls help me if you have any suggestions.
Thanks
Gani

[Riaz Mohamed]

hi ghani ,
when u throw an exception always remember to catch it ..i dont see a try catch block in u'r program.. the ideal program would be as below
class JdbcTest {
public static void main (String args []) throws SQLException
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DDriverManager.getConnection("jdbc racle:thin:username/password@host ort:sid");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select sname from students");
while (rset.next ())
{
System.out.println (rset.getString ("sname"));
}

}
catch(SQLException e)
{
}
}
guess this would work

[Adam Adams]

if you are using Oracle Jdrivers instead of thin driver what would be the URL: ??? and the
Driver ClassName = ???