Connecting JDBC adapter using proxy server

, ,
1

Hello,

We are connecting to the external partners via PROXY server. We have one JDBC connection (postgresq) connecting with org.postgresql.ds.PGPoolingDataSource class. We are getting below error when we are trying to enable the connection.

2018-02-01 13:07:11 EET [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.204] Cannot connect to the database with DataSource class
“org.postgresql.ds.PGPoolingDataSource”.
Connection to xxx.xx.xx.xx:xxxxxrefused. Check that the host name and port are correct and that the postmaster is accepting TCP/IP connections

Partner confirmed that they have opened the firewall.

But as per our network team update the traffic is going via internal proxy server which should not be the case. Could you please let us know if we need to add any Other Properties to go via proxy server.

Also please suggest any alternate.

Thanks,
Mahesh

2

Hi,

please check IS Administrators Guide for Proxy configuration in IntegrationServer.

You will find the configuration in IS Admin under Settings section.

Regards,
Holger

3

Hello Holger,

Thanks for the reply, I am not looking for the proxy server configurations. We have already proxy servers configured. We need traffic to go via proxy server but the request is going through bi pass proxy and the IP is not configured in bi proxy.
I suspect we need to do some configuration changes in JDBC connections that will enable us to go via proxy server. Example in java we will use something like (-Dhttp.proxyHost and -Dhttp.proxyPort). I think we need to use some properties in “Other Properties” field which will enable us go data via proxy server.
Please help me in fixing the issue.

Thanks,
Prudvi