Jeanne, thanks for your concern, the problem is that i am using Type 2 driver for connecting to Oracle database and i actually don't know the parameters to be passed an how to use it . i have written the following code so could please check it and suggest me the procedural way of doing it.
Could you also suggest whether any environment variables have to be defined to use the Type 2 Driver, because i have checked out some websites which suggested such changes.
String T2_Driver = "oracle.jdbc.driver.OracleDriver";
String T2_URL = "jdbc
racle
ci8:@TNSname";
try
{
Class.forName(T2_Driver);
Connection con = DriverManager.getConnection(T2_URL,"scott","tiger");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select eno from emp where ename='SCOTT'");
rs.next();
System.out.println("The ENO is "+rs.getString("eno"));
}
