On 8/17/2016 10:34 AM, McKenzie, Mitch wrote: > Seeing the following warning for all of my datasources when tomcat 8.5.4 > starts up : Ignoring unknown property: value of "30000" for > "validationInterval" property > > I see validationInterval in the docs here: > https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html > > Here is one of my resource defs: > > <Resource > name="jdbc/XYZAPP" > auth="Container" > type="javax.sql.DataSource" > factory="org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory" > username="?" > password="?" > driverClassName="some.driver" > url="jdbc:xyz://xyzapp:12345/SomeDB" > initialSize="10" > maxTotal="100" > maxIdle="50" > minIdle="10" > timeBetweenEvictionRunsMillis="30000" > minEvictableIdleTimeMillis="60000" > testOnBorrow="true" > testWhileIdle="false" > testOnReturn="false" > validationQuery="SELECT 1" > validationInterval="30000" > validationQueryTimeout="3"/> > > > This message has been scanned for malware by Websense. www.websense.com >
I believe that the configuration above is for Tomcat's database connection pooling factory, and not the default repackaged Apache Commons DBCP 2.x factory. In order to use the Tomcat factory, you'll have to add the following line to your context.xml: factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" See the following for more information: https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html . . . just my two cents /mde/
signature.asc
Description: OpenPGP digital signature
