This post is a continuation of this Stack Overflow question where the author attempted to incorrectly setup statement caching. The overall idea is well described in chapter 20. Statement and Result Set Caching documentation however the example uses OracleDataSource.setImplicitCachingEnabled(true) which is a proprietary API.

I was trying to correctly identify application using Oracle JDBC Thin driver to the database server in Spring Boot 2.2. In Spring Boot 1.5 this was accomplished by setting the v$session.program connection property as I explained here. The setup was: