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