java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • How to Install and Run ODI Agent on iSeries
    via by 1374429,
  • Using TNS Alias with ojdbc 12.1
    via Stack Overflow by Nick Papagiorgio
    ,
  • 11g demo Invalid Repository Connection
    via by User743448-Oracle,
  • UCP: Cannot get Connection from Datasource
    via by user9149194,
  • Unable to connect with work repository
    via by HimanshuP,
    • java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLNonTransientConnectionException: [FMWGEN][DB2 JDBC Driver]Error establishing socket to host and port: xx.xxx.xx.xx:xxx . Reason: Connection timed out at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488) at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163) at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:943) at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:873) at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863) at oracle.odi.Agent.validateConnectionProperties(Agent.java:455) at oracle.odi.Agent.doGetDataSource(Agent.java:408) at oracle.odi.Agent.main(Agent.java:516) Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLNonTransientConnectionException: [FMWGEN][DB2 JDBC Driver]Error establishing socket to host and port: 10.161.30.4:446. Reason: Connection timed out at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368) at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:49) at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:80)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    9 more bugmates