Antonio, It most certainly should be able to cache formulas. Do you have an example where it doesn't?
On Tue, Sep 22, 2009 at 7:45 PM, Antonio Terreno <[email protected]>wrote: > I've changed few criteria queries setting .SetCacheble(true) and now > everything makes sense. > > Another impression is that hibernate can't cache formulas (we have few > count done with formulas on a couple of entities), am I wrong? > > Thanks for your help. > > On Tue, Sep 22, 2009 at 4:09 PM, Ayende Rahien <[email protected]> wrote: > >> Antonio, >> There is no relation to the database backend in SysCache >> >> SysCache2 (stupid name) have dependencies on SQL Server, but not SysCache >> >> >> On Tue, Sep 22, 2009 at 4:37 PM, Antonio Terreno < >> [email protected]> wrote: >> >>> Thanks, I've actually found that there was some duplication between the >>> Web.Config and the hibernate.xml (spring) file. >>> >>> Another question: does SysCache work with MySql DB or it works only with >>> MS SQL Server? >>> >>> On the doc I see: >>> >>> SysCache2 requires Microsoft SQL Server 2000 or higher and .NET Framework >>>> version 2.0 or higher. >>>> >>>> >>> >>> We are planning to use MS SQL Server, but at the moment on the query logs >>> of mysql I can still see the queries performed each time, even on simple >>> select from where id=? >>> >>> Thanks again. >>> toni >>> >>> >>> On Tue, Sep 22, 2009 at 10:22 AM, Ayende Rahien <[email protected]>wrote: >>> >>>> Drop the hibernate prefix >>>> >>>> >>>> On Tue, Sep 22, 2009 at 11:28 AM, Antonio Terreno < >>>> [email protected]> wrote: >>>> >>>>> Hi all, >>>>> I'm getting this message even if I'm pretty sure I've followed the >>>>> "manual" on how to enable the 2nd level cache on our application. >>>>> >>>>> On our hibernate.xml I've set up the cache as it follows: >>>>> >>>>> <object id="SessionFactory" >>>>>> type="Spring.Data.NHibernate.LocalSessionFactoryObject, >>>>>> Spring.Data.NHibernate21" singleton="true"> >>>>>> <property name="DbProvider" ref="DbProvider" /> >>>>>> <property name="MappingAssemblies"> >>>>>> <list> >>>>>> <value>XXX.BusinessDomain</value> >>>>>> </list> >>>>>> </property> >>>>>> <property name="HibernateProperties"> >>>>>> <dictionary> >>>>>> <entry key="hibernate.connection.provider" >>>>>> value="NHibernate.Connection.DriverConnectionProvider"/> >>>>>> <entry key="hibernate.connection.driver_class" >>>>>> value="NHibernate.Driver.MySqlDataDriver"/> >>>>>> <entry key="hibernate.dialect" >>>>>> value="NHibernate.Dialect.MySQLDialect"/> >>>>>> <entry key="hbm2ddl.keywords" value="none"/> >>>>>> <entry key="proxyfactory.factory_class" >>>>>> value="NHibernate.ByteCode.Castle.ProxyFactoryFactory, >>>>>> NHibernate.ByteCode.Castle"/> >>>>>> <entry key="hibernate.cache.provider_class" >>>>>> value="NHibernate.Caches.SysCache.SysCacheProvider,NHibernate.Caches.SysCache" >>>>>> /> >>>>>> <entry key="cache.use_second_level_cache" value="true" >>>>>> /> >>>>>> <entry key="expiration" value="300" /> <!-- five minutes, at >>>>>> the minute --> >>>>>> </dictionary> >>>>>> </property> >>>>>> <property name="ExposeTransactionAwareSessionFactory" value="true" >>>>>> /> >>>>>> </object> >>>>>> >>>>>> >>>>> On our web.config as it follows: >>>>> >>>>>> >>>>>> </configSections> >>>>>> ... >>>>>> <section name="syscache" >>>>>> type="NHibernate.Caches.SysCache.SysCacheSectionHandler, >>>>>> NHibernate.Caches.SysCache" requirePermission="false" /> >>>>>> </configSections> >>>>>> >>>>> >>>>> >>>>>> <syscache> >>>>>> <cache region="entities" expiration="3600" priority="5" /> >>>>>> <cache region="LongTerm" expiration="3600" priority="5" /> <!-- as >>>>>> a reference --> >>>>>> <cache region="ShortTerm" expiration="900" priority="3" /> <!-- as >>>>>> a reference --> >>>>>> </syscache> >>>>>> >>>>> >>>>> On the entities that I want to cache: >>>>> >>>>> <class name="XXX"> >>>>>> <cache usage="nonstrict-read-write" region="entities" /> >>>>>> >>>>>> >>>>> If you guys think that this is good we might have a problem elsewhere >>>>> (no idea where, perhaps templating config files..) >>>>> >>>>> >>>>> Thanks for your patience and help. >>>>> >>>>> toni >>>>> >>>>> -- >>>>> http://www.the-arm.com >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >>> -- >>> http://www.the-arm.com >>> >>> >>> >> >> >> > > > -- > http://www.the-arm.com > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "NHibernate Contrib - Development Group" 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.ar/group/nhcdevs?hl=en -~----------~----~----~----~------~----~------~--~---
