How we say that PreparedStatment is Precompiled? where it
will be compiled?

Answer Posted / natraj

Hi,
In parsings there are two types.One Hard Parsing and second
is softparsing. Firt time hard parsing will happen.That
means wheather this query is syntatically correct or not +
what is the table name,no of cols,what are the index for
that table,any sequences and foreign key related details
etc. , and firt time only hard parsing and after that it is
going to cache it at database side only,from next time
onwards only soft parsing that means only specified record
values it will retrive.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is phantom read and which isolation level prevents it?

501


What are the higher level apis under development on top of jdbc currently?

487


What does setautocommit do?

553


What are the different classes through which JDBC represents statements?

503


How do I disallow NULL values in a table?

539






What is jdbc driver?

459


The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?

1664


What does the jdbc connection interface?

538


What happens if connection is not closed in jdbc?

493


How can you make the connection using jdbc?

561


What is batch processing and how to perform batch processing in jdbc?

508


How do I find jdbc version?

529


How to know howmuch data is truncated?

1915


What is an advantage of using the jdbc connection pool?

448


Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?

484