File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes prepared statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "prepared statement" Watch "prepared statement" New topic

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

Joined: Jan 23, 2002
Posts: 11962
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

Joined: Mar 06, 2001
Posts: 13459

You asked a similar question here.
Is there something else we can help you with?
I agree. Here's the link:
subject: prepared statement
It's not a secret anymore!