Attribute "poolPreparedStatements" and "maxOpenPreparedStatements" are marked as un-used but are being used in Tomcat dbcp implementation. This leads to confusion.
You are mixing up tomcat-jdbc and tomcat-dbcp. Tomcat JDBC is Tomcat's "home grown" database connection pooling and does not use poolPreparedStatements Tomcat DBCP is Tomcat's package renamed fork of Apache Commons DBCP 2. Tomcat DBCP is used by default.
See the "Common Attributes" heading in the documentation link. It says "These attributes are shared between commons-dbcp and tomcat-jdbc-pool, in some cases default values are different." This is clearly talking about dbcp attributes.
That is the doc for tomcat-jdbc. The doc states tomcat-jdbc does not use those attributes. This is correct.
Mark, can you please point me to the dbcp documentation for that version ? Thank You.
It's commons-dbcp. Google is your friend. https://commons.apache.org/proper/commons-dbcp/configuration.html
Thank You Chris for pointing me to the commons-dbcp. I was curious about the documentation of tomcat-dbcp. Since there are quite a bit of changes in tomcat-dbcp vs commons-dbcp. I was hoping to find documentation which is relevant to tomcat-dbcp and not the one it was copied from. Anyways, It makes me believe none exists for tomcat-dbcp specifically. Thanks Again.
If you are looking for some specific information, please post to the users' mailing list with a question. Based on what you've said so far, are you just asking whether prepared statements are pooled? (Please reply/post to the list if this is your question.)