Question
Anthem
US
Last activity: 23 Nov 2017 6:07 EST
Tomcat context.xml file changes, validations to be performed.
Hi Team,
We have added the below mentioned parameters to the Tomcat context.xml file:
validationQuery="SELECT 1"
testOnBorrow="true"
validationInteval="30000"
Please provide some insights about the validations.
Anthem
US
In continuation to the above mentioned question,do we need a Application server restart after the DB server switch over.
Pegasystems Inc.
IN
Hi
The validation query is used to validate connections from the datasource connection pool, before those are handed-off to the clients. Usually these are low impact query such as "SELECT 1..." or "SELECT SYSDATE..."
http://tomcat.apache.org/tomcat-6.0-doc/jndi-resources-howto.html#JDBC_Data_Sources
tesOnBorrow : (boolean) The indication of whether objects will be validated before being borrowed from the pool. If the object fails to validate, it will be dropped from the pool, and we will attempt to borrow another. NOTE - for a true value to have any effect, the validationQuery or validatorClassName parameter must be set to a non-null string. In order to have a more efficient validation, see validationInterval. Default value is false
Yes I think Application restart would be required because we are making changes related to DataSource and hence connection pool should initialize again.
Regards,
Ujjwal