wood burning stoves 2.0*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Prepared Statement" Watch "Prepared Statement" New topic
Author

Prepared Statement

Natesh Kurup
Greenhorn

Joined: Nov 23, 2004
Posts: 19
Hi,

When iam using a prepared statement for executing a query which is being executed repeatedly, i need to know where is the prepared statement is stored temporarily, is it in the database or in the app server

Thanks in advance
NK
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"nada76",
it appears that you had a valid display name and have changed it to an invalid display name. Please change it back immediately, since accounts with invalid display names get deleted.

thanks,
Dave.
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

PreparedStatements are supposed to 'coupled' with the compiled database statement, hence they should be cached in the database. While this is the typical behaviour, some database drivers 'fake' support for PreparedSatements by caching in the driver, or by not caching at all.

Dave
Natesh Kurup
Greenhorn

Joined: Nov 23, 2004
Posts: 19
I have updated my profile. hope this suffice.

thanks for your reply

nk
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

Sorry, we require display names to be two words:
Your first name, a space, then your last name. Like it was originally.

Please update your profile.

thanks,
Dave
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Prepared Statement
 
Similar Threads
pre-compile and prepared statement
Create DB2 database
Escaping special characters
what is better
Urgent Java interview question 6+ yrs exp.