SQLState 42S02 leaves Tomcat JDBC pool connections in service after schema change
Apache Tomcat's built-in JDBC connection pool ( org.apache.tomcat.jdbc.pool.DataSource , available since Tomcat 7) exposes rollbackOnReturn to reset transaction state when a connection is returned. After a database schema change, a connection may encounter a table-not-found failure such as SQLState 42S02 or ORA-00942 . The pool's validation settings ( testOn