How to enable implicitCachingEnabled (statement caching) from Tomcat for oracle?

Question

I read about implicitCachingEnabled and MaxStatements with oracle jdbc driver.

I tried adding implicitCachingEnabled = "true" to server.xml to determine the data source, but that does not make any difference.

I also noted other messages, however, a long time ago, when people couldn’t get this parameter working by simply installing it in the tomcat configuration files.

So someone is just working on an off-road vehicle, is there a trick?

At the same time, I will investigate whether it is possible or not to do this with code, but we are using JPA, so I'm not sure how this will work!

Thanks Dan

Answer 1

Try setting OracleConnection.setStatementCacheSize () instead of MaxStatements

http://www.stanford.edu/dept/itss/docs/oracle/10g/java.101/b10979/stmtcach.htm