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 jdbc 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 "jdbc prepared statement" Watch "jdbc prepared statement" New topic

jdbc prepared statement

anbarasan nadar

Joined: Nov 24, 2004
Posts: 1
when we are passing input parameteres prepared statement get compiled again
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Is this a problem or a question? Prepared Statements should be compiled once only.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

Just to expand on this: a prepared statement is compiled once. Each time it is called, the different input parameters are bound to the question marks.

And welcome to JavaRanch!

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Don't get me started about those stupid light bulbs.
subject: jdbc prepared statement
It's not a secret anymore!