Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


PreparedStatement is a pre compiled statement but where it's
pre compiled ?

Answers were Sorted based on User's Feedback



PreparedStatement is a pre compiled statement but where it's pre compiled ?..

Answer / aravind

Hi Manikandansit

There is a small correction in my answer prepared statement
will be parsed for the first time when it executes any query
and there onwards parsed query will be maintained in some
sort of pool....hence next time when it tries to execute
mutilple queries with different values parsing will not
happen again...that's how we say it as precompiled...so this
will reduce the processing time when u have multiple rows of
data to insert..

I hope this will help you...if u r not satisfied with the
answer please do let me know.

Is This Answer Correct ?    12 Yes 0 No

PreparedStatement is a pre compiled statement but where it's pre compiled ?..

Answer / manikandansit

thanks aravind.

Is This Answer Correct ?    5 Yes 1 No

PreparedStatement is a pre compiled statement but where it's pre compiled ?..

Answer / amitabha

What is meant by parsing here?

Is This Answer Correct ?    2 Yes 0 No

PreparedStatement is a pre compiled statement but where it's pre compiled ?..

Answer / aravind

Hi,
in prepared statement when u mention the query that time
only statement will be internaly sent to DB and checks for
the query syntax, so when u execute it directly executes
the statement.

PreparedStatement pstmt = conn.prepareStatement("insert
into table (column2) values ("My Value") where id = 1000");

//pstmt is already compiled

pstmt.execute();

Is This Answer Correct ?    5 Yes 7 No

Post New Answer

More JDBC Interview Questions

How can you retrieve data from the resultset using jdbc?

0 Answers  


What is preparedstatement in jdbc?

0 Answers  


How can I get or redirect the log used by DriverManager and JDBC drivers?

0 Answers  


Explain about the drive manager class working?

0 Answers  


How do I find whether a parameter exists in the request object?

0 Answers  


What is jdbc stand for?

0 Answers  


What is “dirty read” in JDBC? Which isolation level prevents dirty read?

0 Answers  


What are the different types of statements? How we can you use preparedstatement.

0 Answers  


what happen if we set JDBC string to NULL?

0 Answers   Sapient,


How do you create Connection?

5 Answers   HCL,


What is difference between statement and preparedstatement in jdbc?

0 Answers  


What is db client?

0 Answers  


Categories