Optim - Test Data Management and Archiving

OptimConnect JDBC 5.3.3.9

  • 1.  OptimConnect JDBC 5.3.3.9

    Posted Thu August 26, 2021 03:57 PM
    Hi all.

    Does anyone have any experience using the "OptimConnect JDBC 5.3.3.9" driver? We have only been able to get a connection to work from a SQL client installed on the database host itself. I.e. we cannot get it to work from a different host over the network. 

    What we have observed so far:
    1. We can establish a connection to the database using the ODBC driver (3.5) from any host.
    2. We can establish a connection to the database using a SQL client installed on the host where the database resides using the JDBC driver.
    3. We cannot establish a connection to the database using a SQL client installed on my local PC or any other host using the JDBC driver - the following error occurs.:

    15:29:09 [DEBUG ExecutorRunner-pool-4-thread-12 G.?] Connecting: CDE2021-08 (JDBC Driver OC533)
    15:29:09 [DEBUG ExecutorRunner-pool-4-thread-12 L.?] Loading class using dynamic ClassLoader: com.ibm.optim.connect.jdbc.NvDriver
    15:29:09 [DEBUG ExecutorRunner-pool-4-thread-12 L.?] Loading class using dynamic ClassLoader: com.ibm.optim.connect.jdbc.NvDriver
    15:29:09 [DEBUG pool-5-thread-16 D.?] RootConnection: NvDriver.acceptsURL("jdbc:attconnect://SOMEHOSTNAME:2551/CDE;DefTdpName=CDE2021-08")
    15:29:09 [DEBUG pool-5-thread-16 D.?] RootConnection: NvDriver.connect("jdbc:attconnect://SOMEHOSTNAME:2551/CDE;DefTdpName=CDE2021-08", {user=********, password=************})
    15:29:31 [DEBUG pool-5-thread-16 D.?] RootConnection: EXCEPTION -> java.sql.SQLException: Connection timed out: connect
    java.sql.SQLException: Connection timed out: connect
    at com.ibm.optim.connect.comm.Server.connectToServer(Unknown Source)
    at com.ibm.optim.connect.comm.Server.getSysTdp(Unknown Source)
    at com.ibm.optim.connect.navapi.SysTdp.getRemoteSysTdp(Unknown Source)
    at com.ibm.optim.connect.jdbc.NvConnectionBase.open(Unknown Source)
    at com.ibm.optim.connect.jdbc.NvConnectPropertiesBase.openConnection(Unknown Source)
    at com.ibm.optim.connect.jdbc.NvDriverCoreBase.connect(Unknown Source)
    at com.ibm.optim.connect.jdbc.NvDriverCoreBase.connect(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.onseven.dbvis.g.B.D.?(Z:1413)
    at com.onseven.dbvis.g.B.F$A.call(Z:1474)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)


    So the fact the the ODBC connection from my local PC works suggest that there isn't a problem connecting to the port. Is there perhaps some configuration on the host/database required to allow remote JDBC connections? 

    Thanks!

    ------------------------------
    BYron Kneppers
    ------------------------------