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

How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?

662


What is jdbc and odbc?

589


What is a jdbctemplate?

600


How many types of jdbc drivers are available?

568


What is JDBC Savepoint? How to use it?

758






What is ojdbc?

606


What is CLOB and BLOB datatypes in JDBC?

639


Differentiate between a statement and a preparedstatement.

571


Explain the difference between resultset and rowset in jdbc

612


What are the new features added to JDBC 4.0?

621


Why can't I invoke the ResultSet methods afterLast and beforeFirst when the method next works?

762


Explain the process of creating tables using NetBeans IDE?

608


State the different connection methods used for creating different types of sql.

589


What is jdbc drivers in java?

568


What is the advantage of namedparameterjdbctemplate?

600