Re: Oracle's support of PreparedStatement

Alain Kreienbuhl wrote:
>
> 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.

Hi Alain. It is possible that driver caches the SQL and maybe any subsequent parameters, and sends them all at one time to the DBMS in response to the first execute() call. At that time the DBMS will parse the SQL. It would be then that it would throw an exception for bad SQL. Subsequent execute()s would use the query plan from the first parse/exec of the SQL, and the driver might only have to send the new parameter values.
Joe

>
> 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
 

-- 

PS: Folks: BEA WebLogic is expanding rapidly, with both entry and advanced positions
for people who want to work with Java, XML, SOAP and E-Commerce infrastructure products.
We have jobs at Nashua NH, Liberty Corner NJ, San Francisco and San Jose CA.
Send resumes to joe_at_bea.com