Hi Carlos,
You are right, as far I know there isn't single validation query for all
databases.
It seems we must add 2 Property's to DBCPConnectionPool service which user
must fill.
1. Do you want drop invalid connections and create new ones automatically
(which might affect performance little
Hi Toivo, Thanks for you reply.
I opened a Jira ticket NIFI-2381
(https://issues.apache.org/jira/browse/NIFI-2381)
Its good to Know Apache commons DBC P already has this capability,
unfortunately as I know there isn’t a universal simple validation query, its
database specific. I obtain this