Kiran, What's the problem? You are going to need to post some more details here so someone can help you. In particular, what error message are you getting?
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.
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")); }