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