CODEWITHSUNDEEP
oracle-databasejdbcprepared-statement
Codek
Codek

Reputation: 5164

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

I've been reading about implicitCachingEnabled and MaxStatements with the oracle jdbc driver.

I've tried adding implicitCachingEnabled="true" into the server.xml for the datasource definition but it makes no difference.

I've also noted other posts admittedly from a long time ago, where people have failed to get this setting to work simply by setting it in the tomcat config files.

So just on the offchance someone has it working, is there a trick to it?

In the mean time i'll investigate whether it's possible or not to do this via code, but we're using JPA so i'm not sure how that'll work!

Thanks, Dan

Upvotes: 4

Views: 2072

Answers (1)

dba.in.ua
dba.in.ua

Reputation: 593

Try to set the value OracleConnection.setStatementCacheSize () instead of MaxStatements

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

Upvotes: 1

Related Questions