This code is working fine with SQL server.
But when I tried to make changes to make it work for Oracle its giving me error.
Please help.
// Step 1: Load the
JDBC driver.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//String url = "jdbc:odbc:DRIVER={SQL Server};Server=saraswati;Database=master;"; //for sql server
// Step 2: Establish the connection to the database.
//Connection conn = DriverManager.getConnection(url,"sa","sa"); //for sqlserver
String url="jdbc:odbc:DRIVER={Oracle in OraHome90};Server=saraswati;Database=stud1";//for Oracle9
Connection conn = DriverManager.getConnection(url,"scott","tiger");//for Oracle9
if(conn instanceof Connection)
{
System.out.println("DONE");
Statement s=conn.createStatement();
// ResultSet rs=s.executeQuery("select areaname from AreaMaster order by areaName");
ResultSet rs = s.executeQuery("select * from stud1");
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}
}
else
{
System.out.println("NOT DONE");
}
}
catch (Exception e)
{
System.err.println("Got an exception! " + e.toString());
}
Its giving me TSN:protocol adapter error.
DRIVER name is Oracle in OraHome90
Server name is saraswati
Table name stud1
