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.
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.
Syed Faraz Ahmed
For just ping the DB, you can create a customSQL type service with “Select 1”