I was wondering whether it is possible to configure specific SQL statement ignore patterns (exceptions) for backend notifications?
We have our JDBC statement execute threshold set to 30s. Some of the statements run on the datasource take longer than 30s occasionally (i.e. AD group to application role mapping). We'd still like to retain the ability to catch long running statements on the same datasource for the server, so setting the pool exception doesn't seem a viable option.
We were thinking the server-specific exception list can be configured with a %like patter for our SQL procedure call:
in order to ignore notification about this specific query, but it doesn't look like such option exists?