FYI, if you're already using Spring as your IoC then you can use Spring as
your ProxyFactory:
<entry key="proxyfactory.factory_class"
value="Spring.Data.NHibernate.Bytecode.ProxyFactoryFactory,
Spring.Data.NHibernate21" />
This has allowed me to drop two assemblies as my reference (Castle) since
using NHib 2.1
-Scott
On Tue, Sep 22, 2009 at 8:37 AM, 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
-~----------~----~----~----~------~----~------~--~---
