You can set database connection testing options in a data source to make sure that the database connections remain healthy, which helps keep your applications running properly. For more information, see Configuring JDBC Data Sources.
To configure testing options for a JDBC data source:
You can use these options to get the right mix of performance and fault tolerance for your system. Read more about these options in Advanced Configuration Options
select 1 from table_name. If
you prefer to use a different query as a connection test, enter
SQL followed by a space and the SQL code you
want to use to test database connections.