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