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

What is the purpose of the jdbc resultset interface?

672


What is the use of getGeneratedKeys() method in Statement?

734


What is the use of callablestatement? Name the method, which is used to prepare a callablestatement.

643


How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?

695


What is an advantage of using the jdbc connection pool?

637






What is executequery in java?

641


How will you perform truncation using JDBC?

749


What is getconnection method in java?

667


What are the exceptions in jdbc?

659


What is the difference between jdbc and jndi?

672


What is the difference between client and server database cursors?

780


What is in terms of jdbc a datasource?

707


What is jdbc url for mysql?

741


Where is ojdbc14 jar located?

681


What is jdbc odbc in java?

675