Checking database connectivity from service

Hi,

I am using JDBC connection and have a requirement where I need to first check availability of Database connectivity and perform certain operations based on connectivity test(success/failure). Is this possible. If yes then how can I achieve this in my service.

Regards
Garva21

Hi Gaurav,

I wrote a java service for a similar requirement.

Also there are some internal services through which you can check the connectivity of adapter connection if you want.
The issue that i faced with these internal services is someone disabled the adapter connection manually and my service was considering database as down.

Regards,
Syed Faraz Ahmed

For just ping the DB, you can create a customSQL type service with “Select 1”

1 Like