Hello,
What would the scope and capacity of the cache be? For example, scoped to the lifetime of a (pooled) Connection, to that of Statement, or something else, and how could the cache capacity be controlled (avoiding excessive garbage collection pressure, etc.) and instrumented (cache hits/misses, cache filling and emptying rates, etc.)? Would it be possible for the application to issue a command to clear the cache immediately if the application is aware of structural changes (this can happen a lot in development might lead to unexpected behavior)?
--