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

Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
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: 32328

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]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
wood burning stoves
subject: jdbc prepared statement
It's not a secret anymore!