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

Explain jdbc savepoint?

567


What is jdbc driver?

463


What is preparedstatement in jdbc?

519


How many rowset are available in jdbc?

667


What are jdbc?

548






How to rollback a JDBC transaction?

570


What is a java driver?

502


What is jdbc and why is it required?

465


What protocol does jdbc use?

517


Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?

574


What are the differences between statement and preparedstatement interface?

522


What does executequery return in java?

511


What is difference between java.util.Date and java.sql.Date?

540


What are the factors that the jdbc driver performance depends upon?

525


How data can be inserted into long row column of database?

1708