Re: Oracle's support of PreparedStatement

Thanks for your reply.

I'm very much aware of the JDBC Developper's guide and reference (540 pages). There is nothing mentioning that preparedStatement are really repared once. The reason my asking this is because I Merant mentioned that :  con.prepareStatement("invalid sql code")

does not throw any SQLException nor SQLWarning. Therefore I'm wondering if preparedStatement are really being prepared once.

Alain.

Sybrand Bakker a écrit :

> "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:40 CDT