Hello, In our Tomcat (7 or 8 doesn't matter) servers we always override many parameters among datasources, in each application context file (we deploy one context file / application under conf/Catalina/localhost).
Every time I have to set : - maxActive - maxIdle - validationQuery (we mostly work with oracle...) then depending on tomcat 7 or 8 we override as well the parameters for logabandoned, removeabandoned... and many others. But we in fact always or almost set the same values for all of them. The issue is that when we want to change on of those parameters (for ex decide that now for our DataSource the maxActive should be 20 instead of 10 let's say), we have to update all our XML I was wondering if there was a way to change the default parameters in a centralized place, this way in each of our context file we would only need to set : name="jdbc/xxx" username="user" password="password" driverClassName="oracle.jdbc.OracleDriver" url="jdbcurl" and the rest would be OUR default settings, not the one from tomcat default :-) I didn't find any documentation/discussion on this requirement, but I'm sure we are not alone ? Best regards, Aurelien Pernoud
