2 Replies Latest reply on Jul 6, 2015 9:24 AM by prashanthi1

    error importing oracle datasource

    prashanthi1
    prashanthi1 Jul 6, 2015 6:24 AM

      Hi,

       

      I am trying to import Oracle data source but i am getting the below error when i am testing the connection.

       

      *********************************************************************************************************************************

      java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)

        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)

        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)

        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)

        at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:328)

        at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

        at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

        at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)

        at org.eclipse.datatools.enablement.internal.oracle.JDBCOracleConnectionFactory.createConnection(JDBCOracleConnectionFactory.java:27)

        at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

        at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

        at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)

        at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)

        at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

      Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

        at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:439)

        at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:454)

        at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:693)

        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:251)

        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)

        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)

        ... 14 more

      Caused by: java.net.ConnectException: Connection timed out: connect

        at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)

        at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)

        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)

        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)

        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)

        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)

        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

        at java.net.Socket.connect(Socket.java:579)

        at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:149)

        at oracle.net.nt.ConnOption.connect(ConnOption.java:133)

        at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:405)

        ... 19 more

      *********************************************************************************************************************************

      jar used is ojdbc6.jar

      Is it due network settings or can it be any other settings?


      Thanks in advance!

      Prashanthi.