Subject | Re: Prepared Statement caching |
---|---|
Author | rwilcom |
Post date | 2004-08-11T13:12:52Z |
I am not sure that is true - can you show me where this is
documented?
Most JDBC drivers that provide this functionality do not do it by
default - for example, Oracle's thin JDBC requires an explicit and
proprietary call to instigate PS caching. I am referring to global
caching across opening and closing connections - not just within an
open/close. The JDBC driver must explicitly hold the PS indexed by
the uniqueness of the SQL string - avoiding reparsing and rebuilding.
Where did Roman go?
Ron
--- In Firebird-Java@yahoogroups.com, Elmar Haneke <elmar@h...>
wrote:
documented?
Most JDBC drivers that provide this functionality do not do it by
default - for example, Oracle's thin JDBC requires an explicit and
proprietary call to instigate PS caching. I am referring to global
caching across opening and closing connections - not just within an
open/close. The JDBC driver must explicitly hold the PS indexed by
the uniqueness of the SQL string - avoiding reparsing and rebuilding.
Where did Roman go?
Ron
--- In Firebird-Java@yahoogroups.com, Elmar Haneke <elmar@h...>
wrote:
>the
>
> rwilcom schrieb:
> > Does anyone know if Prepared Statement caching is supported by
> > JayBird driver? If so, where is it documents - or - how do youset
> > it up?using an
>
> Prepared statements should be automatically cached if you are
> pooled connection.
>
> Elmar