Hi
Experts
I am getting this error while connecting to oracle server through web Dynpro.
I can connect directly to oracle server with SQL plus.
java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: Server IP:1521:adaniinframs
I am giving my code.
MessageManager msgMgr = (MessageManager)wdThis.wdGetAPI().getComponent().getMessageManager(); Connection conn=null; try { wdComponentAPI.getMessageManager().reportException("after 0",false); Class.forName("oracle.jdbc.driver.OracleDriver"); wdComponentAPI.getMessageManager().reportException("after 1st",false); DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); wdComponentAPI.getMessageManager().reportException("after 2nd",false); conn =DriverManager.getConnection ("jdbc:oracle:thin:@ServerIp:1521:adaniinframs","scott", "tiger"); wdComponentAPI.getMessageManager().reportException("after 3",false); Statement stmt=conn.createStatement(); wdComponentAPI.getMessageManager().reportException("after 4",false); ResultSet rs=stmt.executeQuery("select ename from emp where empno=7369"); // select statment wdComponentAPI.getMessageManager().reportException("after 5",false); while(rs.next()) { wdComponentAPI.getMessageManager().reportException("after 6",false); IPrivateDatabaseConnectView.INodeEmpElement a = wdContext.createNodeEmpElement(); a.setEmpName(rs.getString(1)); a.setEmpJob(rs.getString(2)); wdContext.nodeNodeEmp().addElement(a); } } catch(Exception ex) { //System.out.println("Error"); wdComponentAPI.getMessageManager().reportException(ex.toString(),false); //wdContext.currentContextElement().setError(ex.toString()); ex.printStackTrace(); } finally { try { conn.close(); // closing the connection } catch(Exception e) { System.out.println("Error"); } }
Can anyone help me to solve this error?