org.netezza.util.PSQLException: The connection attempt failed because Exception: java.net.SocketException: Socket option not supported by PlainDatagramSocketImp The operation completed successfully. Stack Trace: java.net.SocketException: Socket option not supported by PlainDatagramSocketImp The operation completed successfully.

Oracle Community | 529051 | 8 years ago
  1. 0

    oracle to netezza

    Oracle Community | 8 years ago | 529051
    org.netezza.util.PSQLException: The connection attempt failed because Exception: java.net.SocketException: Socket option not supported by PlainDatagramSocketImp The operation completed successfully. Stack Trace: java.net.SocketException: Socket option not supported by PlainDatagramSocketImp The operation completed successfully.
  2. 0

    IKM Netezza to File Error.

    Oracle Community | 7 years ago | 625681
    org.netezza.util.PSQLException: ERROR: pg_aclcheck: object "LST" not found
  3. 0

    IKM Netezza to File Error.

    Oracle Community | 7 years ago | 625681
    org.netezza.util.PSQLException: ERROR: CREATE EXTERNAL TABLE: permission denied.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.netezza.util.PSQLException

      The connection attempt failed because Exception: java.net.SocketException: Socket option not supported by PlainDatagramSocketImp The operation completed successfully. Stack Trace: java.net.SocketException: Socket option not supported by PlainDatagramSocketImp The operation completed successfully.

      at sun.nio.ch.Net.setIntOption0()
    2. Java RT
      SocketAdaptor.setTcpNoDelay
      1. sun.nio.ch.Net.setIntOption0(Native Method)
      2. sun.nio.ch.Net.setIntOption(Net.java:156)
      3. sun.nio.ch.SocketChannelImpl$1.setInt(SocketChannelImpl.java:368)
      4. sun.nio.ch.SocketOptsImpl.setBoolean(SocketOptsImpl.java:38)
      5. sun.nio.ch.SocketOptsImpl$IP$TCP.noDelay(SocketOptsImpl.java:284)
      6. sun.nio.ch.OptionAdaptor.setTcpNoDelay(OptionAdaptor.java:48)
      7. sun.nio.ch.SocketAdaptor.setTcpNoDelay(SocketAdaptor.java:258)
      7 frames
    3. org.netezza
      PG_Stream.<init>
      1. org.netezza.PG_Stream.<init>(Unknown Source)
      1 frame
    4. org.netezza.jdbc1
      AbstractJdbc1Connection.openConnection
      1. org.netezza.jdbc1.AbstractJdbc1Connection.sockConstructor(Unknown Source)
      2. org.netezza.jdbc1.AbstractJdbc1Connection.openConnection(Unknown Source)
      2 frames
    5. org.netezza
      Driver.connect
      1. org.netezza.Driver.getConnection(Unknown Source)
      2. org.netezza.Driver.connect(Unknown Source)
      2 frames
    6. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:573)
      2. java.sql.DriverManager.getConnection(DriverManager.java:187)
      2 frames
    7. nzTest
      main.doConnNZ
      1. nzTest.main.<init>(main.java:21)
      2. nzTest.main.doConnNZ(main.java:11)
      2 frames