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
Discuss the procedure of retrieving warnings?
What does the jdbc connection interface?
What is the latest version of JDBC? What are the new features added in that?
Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?
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?
What is jndi lookup?
What is the use of jdbc?
What are the differences between setmaxrows(int) and setfetchsize(int)?
Where is mysql jdbc driver located?
Explain different types of locks in jdbc?
How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?
Why do we use jdbc statements?
How java can be connected to a database?
What is jdbc odbc?
What is odbc. how is it related to sql cli?