On 10.12.2012 20:56, Pavel Bortnovskiy wrote: > Does Derby use some kind of PrepStatement pooling?
In embedded mode, i.e. the database engine, the execution plan for prepared statements is cached, but the prepared statement objects as such are not pooled. http://db.apache.org/derby/docs/10.9/tuning/ctundepth32379.html The client driver has client side caching of prepared statements, though, cf. http://db.apache.org/derby/docs/10.9/adminguide/cadminnsdatasources.html. Thanks, Dag