Re: Precompiled statement?

David Harper wrote:
> joeNOSPAM@[EMAIL PROTECTED]
 wrote:
>> On Apr 22, 9:13 am, Taras_96 <taras...@[EMAIL PROTECTED]
> wrote:
>>> Hi all,
>>>
>>> I've read a bit about precompiled SQL statements. However, I haven't
>>> been able to find anything which explains what the compilation process
>>> entails. What exactly is done in order to change a normal inline SQL
>>> statement into a precompiled one?
>>>
>>> Thanks
>>>
>>> Taras
>>
>> The major benefit possible by re-using Prepared/CallableStatements
>> is that when you create them, you supply the SQL, which can be
>> sent to the DBMS for parsing and compilation. The resultant query
>> plan is retained by the DBMS, and re-used as long as the statement
>> remains open. The saving is that a plain statement would have to
>> as the DBMS to parse and compile it's [sic] SQL for every execution.
>>
>> Joe Weinstein at BEA Systems
> 
> Other benefits of prepared statements: that they can protect against SQL

> injection attacks, and they can simplify the insertion of user-supplied 
> parameters into an SQL query by taking care of vendor-specific quoting 
> rules.

But wait, there's more!  PreparedStatements also provide increased type
safety 
between your Java data and the SQL data types.

-- 
Lew