PreparedStatement caching in Tomcat

Question

I am looking for a way to achieve PreparedStatement caching, so as to save recreating the PreparedStatement objects for queries that were already executed in the past.

Is there some built in way to achieve this using Tomcat? Or must I program this cache myself?

Answer 1

I believe tomcat uses commons-dbcp and commons-dbcp supports prepared statement pooling.

check it out here.

poolPreparedStatements false Enable prepared statement pooling for this pool.

Answer 2

Prepared statement caching is done by either your JDBC connection pool or your JDBC driver, not by Tomcat.