This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
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 Head First Android this week in the Android 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 agree. Here's the link: http://aspose.com/file-tools
 
subject: Prepared Statement
 
It's not a secret anymore!