Re: Oracle's support of PreparedStatement

The 8.1.7 JDBC documentation talks about caching of preparedStatements but this has to be turned on in your code and appears to be quite buggy.

There are also some 3rd party connection pools (COTS and freeware) that attempt something similar.

If you don't cache on the client Oracle generally makes a hash of the SQL text in the server and reuses plans. Obviously you need to use bind variables (?) for this to work, and it will require a trip to the server.

-Peter

Sybrand Bakker wrote:
>
> "Alain Kreienbuhl" <alain.kreienbuhl_at_fisystem.com> wrote in message
> news:3B27945B.5144F725_at_fisystem.com...
> > Hello,
> >
> > Are preparedStatement supported in the following configuration:
> > - JDBC Driver 8.1.(6-7)
> > - RDMS Oracle 8.0.5
> >
> > By supported I mean, are the query really prepared once (for a given
> > scope, method scope or longer if connection pool + preparedStatement
> > pool are used).
> >
> > Where can I found official information about this.
> >
> > Thanks .
> >
> > Alain.
> >
> >
>
> In Oracle's jdbc documentation, obviously.
> Although running a higher version driver against a lower version database
> (which has also been desupported) is just asking for problems.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
Received on Sat Jul 21 2001 - 18:51:37 CDT