| 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