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

Answer Posted / venkatesh.t

prepared Statements are compiled at database server side.
Once the statement is passed to the database the Statement
is parsed for validness and checked weather the table exist
or not .if the statement is valid the server holds the
statement object and process the multiple request from the
client.
Finally parsing of the statement is done at server side that
to only once.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

please tell me the name and url path for type-4 driver ?

2481


How many ways can you update a result set?

565


What is the full form of jdbc?

495


Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.

523


How vendor Naming registry supports JNDI?

1771






What are the differences between execute, executequery, and executeupdate?

491


What are the advantages of using preparedstatement over statement?

541


What is phantom read and which isolation level prevents it?

505


What is jdbc odbc connection?

509


What does executeupdate return in jdbc?

512


What is difference between odbc and jdbc?

512


What does the jdbc databasemetadata interface?

526


Does jdbc use odbc?

506


What is jdbc architecture in java?

477


How to rollback a JDBC transaction?

570