This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes prepared statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "prepared statement" Watch "prepared statement" New topic
Author

prepared statement

thomas davis
Ranch Hand

Joined: Feb 01, 2003
Posts: 207
How does the databases identify the request is for prepared statement?
What is the process flow of handling prepared statement (starting from webserver to database server and back to webserver)?
I read from an article that prepared statements are using precompiled statement and after syntax check, compilation and optimization, handle is returned to the JDBC driver.
At the end of the program the statement handle is discarded.
I have not understood the complete process of handling prepared statement and the concept of handle. Can someone explain to me about this?
It would also be great if someone helps me to understand process going on at database when it receives the request for prepared statement, if possible with examples?
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
It's really up to the JDBC driver how the implementation handles PreparedStatements. Remember that JDBC is just an API... Anyway, this is my "educated guess" at how things happen.
When you call prepareStatement("SELECT * FROM ..."), the driver or the database server itself compiles the SQL with wildcards into a proprietary query execution plan. The handle is simply an abstract reference to this already compiled execution plan. When you have set the parameters and call executeXXX(), the JDBC driver calls the pre-compiled query execution plan with the given parameters, thus, bypassing the sometimes costly query compilation phase.
I would like to hear others' takes on this, though.


Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

You asked a similar question here.
Is there something else we can help you with?
Dave
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: prepared statement
 
Similar Threads
How to upload a file from applet to the webserver ?
Inserted value too large for column
handling quotes in sql queries
Prepared Statement
Prepared Statement