What Is Difference Between <validate-on-match> And <background-valida

What Is Difference Between And ?

FullFormDefinition · 2025-09-18T19:47:17.000000Z

What Is Difference Between And ?

1.	What Is Difference Between <validate-on-match> And <background-validation>?
Answer» <validate-on-match> validate the database CONNECTION every time, and if a connection is not valid, it will write a WARNING in the logs. Having “validate-on-match” CONFIGURED may have a little high load on the database as it may create lots of requests. <background-validation> validate the connection periodically based on what frequency is configured for “background-validation-millis”. The default configuration is set to zero means disabled. Having “ background-validation” set to true will create fewer database connections and it’s side-effects would be not DETECTING immediately if dead connections.

Answer»

<validate-on-match> validate the database CONNECTION every time, and if a connection is not valid, it will write a WARNING in the logs.
Having “validate-on-match” CONFIGURED may have a little high load on the database as it may create lots of requests.
<background-validation> validate the connection periodically based on what frequency is configured for “background-validation-millis”. The default configuration is set to zero means disabled.
Having “ background-validation” set to true will create fewer database connections and it’s side-effects would be not DETECTING immediately if dead connections.