Hi all,

I'm trying to activate prepared statement caching for my hibernate application. As far as I remember I need a jdbc driver and/or a connection pool which allows this. However I cannot find such a thing. Can anybody point me into the same direction !?

Also, I think I've seen a property / hibernate setting to turn on prepared statement caching, but also here I cannot find this thing again...

Thanks in advance :-)
Holger

Think I've got it myself...

http://www.hibernate.org/hib_docs/refer ... ation.html

"You must set the properties hibernate.dbcp.* (DBCP connection pool properties) to enable the DBCPConnectionProvider. Prepared statement caching is enabled (highly recommend) if hibernate.dbcp.ps.* (DBCP statement cache properties) are set."

...