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
------------------------------

#InfoSphereOptim
#Optim