JDBC Connection failed in ISC

Hello,

If your test connection is getting timed out, following the below troubleshooting steps.

  1. Check whether JDBC URL is correct.
  2. Check whether you have explicitly provided the port to which your Target DB is pointing to.
  3. Check whether through SQL Developer client, the credentials and URL are working as expected.
  4. If above 3 are as expected, then, it could be the connectivity issues from your VA.
  5. Check connectivity from VAs using ping and netstat command to check connection with host and port respectively.
  6. If connections are getting timed out from VAs as well, then, surely its a connectivity issue which could be resolved by the firewall team.
  7. Also, make sure that correct JDBC driver files are imported in your connector. It seems that is not issue in your case but still, its good to check it once.
  8. Also, check whether target DB is supporting the SQL Native Authentication or Windows Authentication & change your configurations of connections accordingly.
2 Likes