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

Discuss the procedure of retrieving warnings?

559


What does the jdbc connection interface?

538


What is the latest version of JDBC? What are the new features added in that?

521


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

571


Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?

519






What is jndi lookup?

512


What is the use of jdbc?

560


What are the differences between setmaxrows(int) and setfetchsize(int)?

540


Where is mysql jdbc driver located?

516


Explain different types of locks in jdbc?

511


How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?

619


Why do we use jdbc statements?

507


How java can be connected to a database?

566


What is jdbc odbc?

516


What is odbc. how is it related to sql cli?

600