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 -~----------~----~----~----~------~----~------~--~---
