Database Queries for Service Health Check of JDBC Shared Resource
Database specific benign queries for the Service Health Check of the JDBC Shared Resource are listed below:
- Oracle:
select systimestamp from dual - DB2:
values current timestamp - MS SQL:
select current_timestamp - PostgreSQL :
select now() - HSQL:
select count(*) from INFORMATION_SCHEMA.SYSTEM_TABLETYPES