wood burning stoves
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


Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Prepared Statement
 
It's not a secret anymore!