Francesco Pasqualini wrote:
> JDBC already support prepared statements cache in pooledConnections.
>
> BTW I think that DB already cache prepared statements so not shure if
> it s always a benefit tou use stmt cache from client too.
> The cache put and fetch has a cost...

Hi,

IMHO Groovy is very usefull for ad hoc scripts and tasks using one simple and direct SQL connection without using pooledConnection.
But you can use pooledConnection without caching and simple connection with caching, both can coexist.

--
Marc DeXeT
CNRS - DSI
Pôle Expertises
<http://www.dsi.cnrs.fr>


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

  http://xircles.codehaus.org/manage_email