Skip to Content
avatar image
Former Member

JDBC Channel Connection details not taking effect

Hi Experts,

We have been having issues regarding our JDBC receiver since last week with the shortened error below.

Fallback to another registered driver failed: com.sap.aii.adapter.jdbc.sql.jdbctrace.$Proxy3618 returns: The TCP/IP connection to the host <ipAdd>, port 1433 has failed. Error: "connect timed out (local port ***** to address ************ (*************), remote port 1433 to address <ipAdd>). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."..
: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <ipAdd>, port 1433 has failed. Error: "connect timed out (local port ***** to address ************ (*************), remote port 1433 to address <ipAdd>). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

We were advice that the IP address of the DB server have been changed and so we tried to apply the new IP in the connection details of the JDBC channel. After we activate the change and resend the stuck messages it seem to use the old IP.

My question is that is the connection details embedded/contained within the JDBC driver upon installation? I am new to how JDBC integrates so I am suspecting that way. Am I missing something that I need to check? If anyone could provide technical details or steps it would be a great help. Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 19, 2017 at 06:12 AM

    Hi Joel,

    May be the channel settings are chached, you can try for example to set it inactive and to test if the exception is that the channel is innactive or not, also you can delete and create again.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • May 19, 2017 at 06:51 AM

    Hi Joel!

    You could try to restart java service "XPI Adapter: JDBC".

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • May 23, 2017 at 08:47 AM

    Hello Joel,

    The connection details are not embedded in driver.

    If the host is changed it is sufficient to update the channel parameters alone. Try to do complete refresh on cache once.

    Could you trace the old message what channel is being used and make sure you dont have any duplicate channels configured in the system.

    Add comment
    10|10000 characters needed characters exceeded