Skip to Content
0
Former Member
Sep 21, 2007 at 07:25 AM

Oracle Exception in Web Dynpro.

20 Views

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?