Hi All,

I have been having issues with NHibernate’s 2nd level caching while
using the SysCache2 provider. I am receiving a lot of random caching
misses that are occurring roughly every 3-5 minutes or so. The 2nd
level caching appears to be working when inspecting database calls
through SQL profiler, i.e. for cached queries or entities, first time
they are loaded into the 2nd level cache a query is sent and after
that no query is sent until the next miss.

I am using what I believe is the latest version from the trunk of the
SysCache2 provider (as of last wee). I built the solution against a
NHibernate version from more than a few months ago. I would really
like to get this caching provider working because of the SQL Server
Dependencies functionality. I’ve tried SysCache but that does not
build against my NHibernate version.

I’ve searched the net and found that some people are having the same
problem but their solution did not work for me:

https://forum.hibernate.org/viewtopic.php?p=2406601

Below are my settings and configurations:

*Web.config*

      <section name="syscache2"
type="NHibernate.Caches.SysCache2.SysCacheSection,
NHibernate.Caches.SysCache2"/>

  <syscache2>
    <cacheRegion name="ReferenceData">
      <dependencies>
        <tables>
          <add name="DomainObjectA" databaseEntryName="DatabaseName"
tableName="dbo.DatabaseObjectA" />
          <add name=" DomainObjectB " databaseEntryName="
DatabaseName" tableName="dbo. DatabaseObjectB" />
        </tables>
      </dependencies>
    </cacheRegion>
  </syscache2>

*Session Factory.config*

  <session-factory name=" DatabaseName">
    <property name="dialect">NHibernate.Dialect.MsSql2005Dialect</
property>
    <property
name="connection.provider">NHibernate.Connection.DriverConnectionProvider</
property>
    <property
name="connection.driver_class">NHibernate.Driver.SqlClientDriver</
property>
    <property name="cache.use_second_level_cache">true</property>
    <property name="cache.use_query_cache" >true</property>
    <property
name="cache.provider_class">NHibernate.Caches.SysCache2.SysCacheProvider,
NHibernate.Caches.SysCache2</property>
    <!--<property
name="connection.connection_string_name">DatabaseConnectionString</
property>-->
    <property name="show_sql">false</property>
    <property name="generate_statistics">false</property>
    <property name="max_fetch_depth">1</property>
    <property name="connection.isolation">ReadCommitted</property>
    <property name="default_schema">dbo</property>
     <mapping assembly="AssemblyName.Repositories" />
</session-factory>
</hibernate-configuration>

*Mapping Files*

ObjectA.hbm
<class name="BusinessLogic.Domain.ObjectA, BusinessLogic.Domain"
table="ObjectA" optimistic-lock="version">

    <id name="Id" column ObjectAId" access="field.camelcase-
underscore">
      <generator class="identity" />
    </id>

    <version name="Version" column="RowVersion"
access="field.camelcase-underscore" />

    <many-to-one name=" ObjectB" class="BusinessLogic.Domain.ObjectB,
BusinessLogic.Domain" access="field.camelcase-underscore">
      <column name=" ObjectBId" not-null="true" fetch="select"
lazy="false"/>
    </many-to-one>

<property>
…
<property />
  </class>

ObjectB.hbm
  <class name=" BusinessLogic.Domain.ObjectB, BusinessLogic.Domain "
table="ObjectB" optimistic-lock="none" mutable="true">
    <cache usage="read-only" region="ReferenceData"/>
    <id name="Id" column="ObjectBId" access="field.camelcase-
underscore">
      <generator class="assigned" />
    </id>

<property>
…
<property>
</class>

*Query Example*

        public List<ObjectB> GetObjectBReferenceData()
        {
            List<ObjectB> objectBs = new List<ObjectB>();
            ICriteria critObjectBs =
UnitOfWork.CurrentSession.CreateCriteria(typeof(ObjectB))
                                    .SetCacheable(true);
            objectBs = critObjectBs.List<ObjectB>() as
List<ObjectB>;
            return objectBs;
        }

Any help or direction would be very much appreciated.

Thanks,
Joe Turcic
Senior .NET Developer
Email: [email protected]
Mobile: 0404 002 630

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" 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/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to