db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag Wanvik <dag.wan...@oracle.com>
Subject Re: concurrent execution of Statement's .addBatch() and .executeBatch()
Date Mon, 10 Dec 2012 20:30:05 GMT

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


Mime
View raw message