Open Edge Driver error when doing port forwarding

[hrm]

Hi All,

We have implemented a simple JDBC call to query a table in Progress DB from a Java portlet application. We are trying to connect to a Unix box where the DB reside and getting the following error. (We connect to DB server from our Dev server and ports were opened between them)

Exception in thread "main" java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]Error establishing socket to host and port: <server name>:1073. Reason: Connection timed out
at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplConnection.open(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.connect(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.open(Unknown Source)
at com.ddtek.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(libgcj.so.7rh)
at java.sql.DriverManager.getConnection(libgcj.so.7rh)
at ProgressDAO.initDataSourceLookup(ProgressDAO.java:123)
at ProgressDAO.main(ProgressDAO.java:70)

We are using com.ddtek.jdbc.openedge.OpenEdgeDriver and use port 27247 where the database is listening. But as appear in the sql exception it returns port 1073, so we assume it is doing a port forwarding. When we run the same program from a different server (other than our dev env.) it runs perfectly. This may occur from server side or from router (port number change).

Do we have a workaround to overcome this issue?

Thanks in advance.
Hemantha.

 

[hrm]

Hi ,

We got resolved this issue. It actually happened from DB server end. DBA has forgot to set max port no and min port number parameters. Once he set them it worked as expected.

Hemantha.