CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

MS SQL 2008 on ASP.NET Hosting



Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.microsoft_application_blocks Tags:
Item Type: NewsGroup Date Entered: 9/20/2004 8:20:19 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 1 Views: 27 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
2 Items, 1 Pages 1 |< << Go >> >|
tavarich
Asp.Net User
Clean cached parameters9/20/2004 8:20:19 PM

0/0

Hello everyone,
I know that this forum should be used for Microsoft Data Access Block but I'm using the GOTDOTNET Data Access application block, which anyway derived from the Microsoft block.

I'm really stuck with a problem that others are probably already faced.

We hava our first application that uses the GotDotNet application block in a testing environment. Since we test the applicaiton, we had to modify one of our stored procedure. Thus, we compiled the stored procedure on the testing database... but it didn't work. The cached parameters used the old definition of the stored procedure parameters which have been changed.

How could we flush the cached parameters WITHOUT restarting IIS ?

We found no method in the application block that do so and the shared variable that is used to cached parameters is a private variable. Thus, we don't want to modify the GotDotNEt package.

Anyone has a solution ?
Anyone else uses parameters caching ? How do you do when you update your procedures on the production site ?

Thanks for all your help.


Richard Pineault
Paul Gielens
Asp.Net User
Re: Clean cached parameters3/16/2005 6:10:18 PM

0/0

We had similar problems and decided to migrate to Enterprise Library 1.0 since it offers support for clearing the parameter cache using the ClearParameterCache() method.
2 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
ARM System Developer's Guide: Designing and Optimizing System Software Authors: Andrew N. Sloss, Dominic Symes, Chris Wright, John Rayfield, Pages: 689, Published: 2004
The Twenty-Fourth International Symposium on Fault-Tolerant Computing: Digest of Papers Authors: International Symposium on Fault-Tolerant Computing, IEEE Computer Society Fault-Tolerant Computing Technical Committee, University of Texas at Austin, Pages: 467, Published: 1994
Conference Record of the Twenty-sixth Asilomar Conference on Signals, Systems & Computers: October 26-28, 1992, Pacific Grove, California Authors: Systems & Computers 26th Pacific Grove Asilomar Conference on Signals, Calif., Institute of Electrical and Electronics Engineers, Avtar Singh, Naval Postgraduate School (U.S.), San Jose State University, IEEE Signal Processing Society, IEEE Computer Society, Pages: 1161, Published: 1992
System Performance Tuning Authors: Gian-Paolo D. Musumeci, Mike Loukides, Michael Kosta Loukides, Pages: 334, Published: 2002

Web:
Clean cached parameters - ASP.NET Forums We found no method in the application block that do so and the shared variable that is used to cached parameters is a private variable. ...
Rinat Shagisultanov : Data Access Application Block: cached ... Mar 24, 2006 ... if (ex is related to command parameters) Clean parameter cache for the command. Prepare the command. Execute original method ...
ConcurrentCache (Apache Derby V10.5 Internals) Parameters: entry - the entry to clean: item - the cached object contained in the entry; Throws: StandardException - if an error occurs while cleaning ...
System parameter maximum cache size is less than stop clean flush ... Nov 16, 2007 ... System parameter maximum cache size is less than stop clean flush threshold. ESE adjusts this parameter correctly to avoid malfunction. ...
ARM11 MPCore Processor Technical Reference Manual 3.4.18. c7 ... Table 3.31 shows the relationship of cache sizes and the S parameter value. ... Example 3.1 is an example using the command Clean Data Cache Line (using ...
SQL Server: Automated database object recompiling after cleaning ... Aug 2, 2007 ... DBCC FREEPROCCACHE; and DBCC DROPCLEANBUFFERS; are commands that clean the cached execution plans from memory. ...
Exact Cache Characterization by Experimental Parameter Extraction ... How is a clean cache initially populated? Which exact replacement strategy is used in Intel’s P4? T. John, R. Baumgartl. Experimental Cache Parameter ...
Optimizing PL/SQL Performance Configuring this parameter correctly is important since cleaning up too often can result in a lower cache hit ratio and when cleaning does not occur often ...
1.5.9 Bugfixes or Features 2 - Purge Expired Cache It is a supplement to the "Clean Cache" that has been already there - with ... of parameters creates new URL and each of them creates new cache file file ...
Rails Envy: Ruby on Rails Caching Tutorial - Part 2 Action Caching; Cleaning the Action Cache; Fragment Caching; Cleaning the .... rails assumes the first two parameters, so I don't need to write those. ...

Videos:
GTUG - Using the Google Collections Library for Java (2 of 2) 08/06/2008 - http://sv-gtug.org The Java Collections Framework is indispensable to nearly every Java developer. Yet, you may often find ...
django: Web Development for Perfectionists with Deadlines Google TechTalks April 26, 2006 Jacob Kaplan-Moss ABSTRACT Django is one of the premier web frameworks for Python, and is often compared ...
How To Break Web Software - A look at security ... Google TechTalks April 13, 2006 Mike Andrews Mike Andrews is a senior consultant who specializes in software security and leads the web ...




Search This Site:










create mydb object for every database operation?

reg:application blocks

ent lib 2.0 logging block timestamp offset by 4 hours

deploying exception handling block (enterprise library)

exception when use daab 2.0 to config web.config

logging application block basics

i am against the ui process block

timeout expired in enterprises library

enterprise library (june 2005) and medium trust

insert checkbox data into access in asp?

asynchronous insert

how to handle decimal precision & scale with daab addoutparameter?

cannot see exception/s details in my eventlog mmc viewer folder

enterprice library 3.0 (april 2007) issue - configuration won't save

aggregation block - number of improvements

how to use the same connection for multiple subsequent queries?

configure enterprise library from file website

cryptography application block - is it ok for an asp.net website?

database trace listener

system.security.securityexception: requested registry access is not allowed

parameter caching

problem | cache not holding on to items...

please help

back button and uip

randomly occurring error

exception management block

parameter order

cant open the .sln solution file for the application block

configuration problem

logging configuration and formatters

  Privacy | Contact Us
All Times Are GMT