Do you not need to wrap your call to get all in a transaction? I thought second level cache was only commited on commit of a transaction?
Cheers Stefan On Wed, Feb 4, 2009 at 10:15 AM, jasonsirota <[email protected]> wrote: > > After wrestling with the trunk version of ActiveRecord and NHibernate > and NH-Contrib version numbers I finally got cache support enabled for > the AR project, however I'm having trouble getting it to work. > > The call is something like: > > Category.FindAll(new Order("SortOrder"),true) > > which returns a list of category sorted by the db field "SortOrder". > > I've enabled caching on the Category object like: > > [ActiveRecord("Categories", Cache=CacheEnum.ReadOnly)] > public class Category > ... > > However, each time the page loads, it requeries the database instead > of pulling the resulting list from the cache. > > SELECT this_.CategoryID as CategoryID4_0_, this_.Description as > Descript2_4_0_, this_.SortOrder as SortOrder4_0_, this_.Type as > Type4_0_ FROM BudgeterCategories this_ ORDER BY this_.SortOrder asc > > Any ideas? > Jason > > > > > -- Stefan Sedich Software Developer http://weblogs.asp.net/stefansedich --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
