-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 
Author Message
 Post subject: Second Level Cache - SQL Query Notifications -Does not work
PostPosted: Tue Jul 10, 2007 4:32 pm 
Newbie

Joined: Tue Jul 03, 2007 11:50 am
Posts: 9
Using nHibernate version:1.2 I am try to invalidate the cache using SQL Query notifications. I have 4 records in a lookup table in the database that I would want cached. The initial request gets it from the database and caches it. I can see that in the SQL Profiler and the log4Net logs. Here is the log file entries.

2007-07-10 14:29:07,168 [5] DEBUG NHibernate.Cache.StandardQueryCache - checking cached query results in region: NHibernate.Cache.StandardQueryCache
2007-07-10 14:29:07,168 [5] DEBUG NHibernate.Cache.StandardQueryCache - query results were not found in cache
2007-07-10 14:29:07,168 [5] DEBUG NHibernate.SQL - select patientsta0_.PatientStatusKey as PatientS1_80_, patientsta0_.Version as Version80_, patientsta0_.Code as Code80_, patientsta0_.Description as Descript4_80_, patientsta0_.SortOrder as SortOrder80_, patientsta0_.LongDescription as LongDesc6_80_ from paceart.PATIENT_STATUS patientsta0_
2007-07-10 14:29:07,183 [5] DEBUG NHibernate.Cache.ReadWriteCache - Caching: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#874f8621-44ff-4e08-8572-87ffa3b2b777
2007-07-10 14:29:07,215 [5] DEBUG NHibernate.Cache.ReadWriteCache - Cached: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#874f8621-44ff-4e08-8572-87ffa3b2b777
2007-07-10 14:29:07,215 [5] DEBUG NHibernate.Cache.ReadWriteCache - Caching: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb77
2007-07-10 14:29:07,215 [5] DEBUG NHibernate.Cache.ReadWriteCache - Cached: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb77
2007-07-10 14:29:07,215 [5] DEBUG NHibernate.Cache.ReadWriteCache - Caching: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb78
2007-07-10 14:29:07,215 [5] DEBUG NHibernate.Cache.ReadWriteCache - Cached: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb78
2007-07-10 14:29:07,215 [5] DEBUG NHibernate.Cache.ReadWriteCache - Caching: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb79
2007-07-10 14:29:07,215 [5] DEBUG NHibernate.Cache.ReadWriteCache - Cached: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb79
2007-07-10 14:29:07,215 [5] DEBUG NHibernate.Cache.StandardQueryCache - caching query results in region: NHibernate.Cache.StandardQueryCache



When I request it again, it finds the data in the cache and does not go to the database.

2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.StandardQueryCache - checking cached query results in region: NHibernate.Cache.StandardQueryCache
2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.StandardQueryCache - Checking query spaces for up-to-dateness [Iesi.Collections.HashedSet]
2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.StandardQueryCache - returning cached query results
2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache lookup: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#874f8621-44ff-4e08-8572-87ffa3b2b777
2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache hit: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#874f8621-44ff-4e08-8572-87ffa3b2b777
2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache lookup: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb77
2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache hit: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb77
2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache lookup: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb78
2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache hit: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb78
2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache lookup: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb79
2007-07-10 14:30:22,436 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache hit: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb79



Now I update one of the four rows in the database external to the app. When the app requests the data there is a cache miss and it gets the rows from the database.

2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache lookup: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#874f8621-44ff-4e08-8572-87ffa3b2b777
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache miss: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#874f8621-44ff-4e08-8572-87ffa3b2b777
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.SQL - SELECT patientsta0_.PatientStatusKey as PatientS1_80_0_, patientsta0_.Version as Version80_0_, patientsta0_.Code as Code80_0_, patientsta0_.Description as Descript4_80_0_, patientsta0_.SortOrder as SortOrder80_0_, patientsta0_.LongDescription as LongDesc6_80_0_ FROM paceart.PATIENT_STATUS patientsta0_ WHERE patientsta0_.PatientStatusKey=@p0; @p0 = '874f8621-44ff-4e08-8572-87ffa3b2b777'
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Caching: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#874f8621-44ff-4e08-8572-87ffa3b2b777
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cached: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#874f8621-44ff-4e08-8572-87ffa3b2b777
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache lookup: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb77
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache miss: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb77
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.SQL - SELECT patientsta0_.PatientStatusKey as PatientS1_80_0_, patientsta0_.Version as Version80_0_, patientsta0_.Code as Code80_0_, patientsta0_.Description as Descript4_80_0_, patientsta0_.SortOrder as SortOrder80_0_, patientsta0_.LongDescription as LongDesc6_80_0_ FROM paceart.PATIENT_STATUS patientsta0_ WHERE patientsta0_.PatientStatusKey=@p0; @p0 = '1a142f19-5854-4635-a0aa-a8597b9dfb77'
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Caching: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb77
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cached: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb77
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache lookup: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb78
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache miss: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb78
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.SQL - SELECT patientsta0_.PatientStatusKey as PatientS1_80_0_, patientsta0_.Version as Version80_0_, patientsta0_.Code as Code80_0_, patientsta0_.Description as Descript4_80_0_, patientsta0_.SortOrder as SortOrder80_0_, patientsta0_.LongDescription as LongDesc6_80_0_ FROM paceart.PATIENT_STATUS patientsta0_ WHERE patientsta0_.PatientStatusKey=@p0; @p0 = '1a142f19-5854-4635-a0aa-a8597b9dfb78'
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Caching: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb78
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cached: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb78
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache lookup: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb79
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cache miss: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb79
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.SQL - SELECT patientsta0_.PatientStatusKey as PatientS1_80_0_, patientsta0_.Version as Version80_0_, patientsta0_.Code as Code80_0_, patientsta0_.Description as Descript4_80_0_, patientsta0_.SortOrder as SortOrder80_0_, patientsta0_.LongDescription as LongDesc6_80_0_ FROM paceart.PATIENT_STATUS patientsta0_ WHERE patientsta0_.PatientStatusKey=@p0; @p0 = '1a142f19-5854-4635-a0aa-a8597b9dfb79'
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Caching: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb79
2007-07-10 14:31:40,345 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cached: Paceart.Domain.Lookups.PatientStatus, Paceart.Domain, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9951c8675d8c08ec#1a142f19-5854-4635-a0aa-a8597b9dfb79


What I notice is instead of grabbing the entire resultset in one select it grabs the rows one row at a time. I can see this behaviour in the SQL profiler too. In the SQL profiler I also see an extra select for all the rows too


The other problem I have encountered is if I insert a fifth row in the database after the results have been cached on the next round trip it does not grab the new row but just the changes in the original four. Is this a flaw in the implementaion of the Query notifications by nHibernate or is this behavious by design?


Configuration
configuration.SetProperty("hibernate.cache.use_second_level_cache", "true");
configuration.SetProperty("hibernate.cache.use_query_cache", "true");

<section name="syscache2" type="NHibernate.Caches.SysCache2.SysCacheSection, NHibernate.Caches.SysCache2"/>
<syscache2>
<cacheRegion name="PatientStatus">
<dependencies>
<commands>
<add name="patientstatus" command="SELECT [PatientStatusKey], [SortOrder], [Code], [Description], [LongDescription], [LastUpdate], [Version] FROM [Paceart].[PATIENT_STATUS]"/>
</commands>
</dependencies>
</cacheRegion>
</syscache2>

Mapping file
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" schema="paceart" default-lazy="false">
<class name="Paceart.Domain.Lookups.PatientStatus, Paceart.Domain" table="PATIENT_STATUS">
<cache usage="read-write" region="PatientStatus"/>
<id name="Key" type="Guid" column="PatientStatusKey">
<generator class="assigned" />
</id>
<version name="Version" column="Version" type="Int32" unsaved-value="null" />
<property name="Code" column="Code" type="String" />
<property name="Description" column="Description" type="String" />
<property name="SortOrder" column="SortOrder" type="Int32" />
<property name="LongDescription" column="LongDescription" type="String" />
</class>
</hibernate-mapping>


Get functionpublic DomainCollection<T> GetLookupList<T>() where T : ILookup, new()
{
try
{
ISession session = GetSession();
IQuery query = session.CreateQuery("from " + typeof(T).ToString());
query = query.SetCacheable(true);
IList list = query.List();
DomainCollection<T> listReturn = new DomainCollection<T>(list, null);
return listReturn;
}
catch (NHibernate.HibernateException hibernateException)
{
throw ConvertHibernateException(hibernateException, null);
}
}


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jul 13, 2007 9:33 am 
Newbie

Joined: Tue Jul 03, 2007 11:50 am
Posts: 9
After further digging I found more issues with the NHibernate implementaion for SQLdependency(Query notifications).
1. I delete a row that is cached from the database the application crashes the next time I request the same data. Because nHibernate tries to request the rows one at time based on the cached ids and it does not find that row in the database.

2.How do I relate the Command(for which I have a SQLDependency) in the Cache Region of the config file back to my mapping file? I see two queries one that is auto generated because of the mapping file and the other because of the syscache2 dependency region in the config file. These two don't seem to know about each other.

3. I tried to look at the source for nHibernate 1.2 Syscache2 and did not find any references to SQLDependency(implementation of sql2005 query notifications). I found references to SQLCacheDependency but none to SQL Dependency.


4.I tried using a stored proc. without any luck. Found one issue with stored procs. if you are trying to use caching. The loader proc. cannot be parameterless. You have to create the loader proc. is such a way that it can load one row at a time or the entire table at one shot. This is because after the cache miss nHibernate tries to load the rows one at a time instead of the entire table.

Any response to these or my previous post will be greatly appreciated. These issues are hampering our use of nHibernate on our product development efforts.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jul 13, 2007 9:44 am 
Beginner
Beginner

Joined: Wed Jul 19, 2006 8:24 am
Posts: 35
It sounds like you don't have the sqldependency configured correctly in nHibernate. When you update the data in the database outside of nHibernate do you see any nHibernate debug log entries that says something like cache region expired due to dependancy change?

Also, it looks like nHibernate is caching your objects in the query cache not the second level cache. That's why it's querying by the key values. Is it possible you're using criteria objects?

I've been using sqldependencies for a while without any problems. The hardest part was getting the web.config setup right.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jul 13, 2007 2:07 pm 
Newbie

Joined: Tue Jul 03, 2007 11:50 am
Posts: 9
I donot see anything in the nHibernate debug logs that invalidates the cache after I change the data outside nHibernate.

I have added some more log entries below. The ones in red I don't seem to understand. It adds the entities to the cache and sets them to be expired in default five minutes. Then removes the item from the cache because the dependency changes


2007-07-13 09:16:46,626 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - root cache item for region not found.
2007-07-13 09:16:46,626 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - Creating root cache entry for cache region: Parent
2007-07-13 09:16:46,626 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - Enlisting cache dependency for change notification
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - Attaching cache dependencies to root cache entry. Cache entry will be removed when change is detected.
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - adding new data: key=NHibernate-Cache:Parent:testnHibernate.Parent, testnHibernate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null#e02e6c2c-ad48-4b92-815e-37e450addb9b@2053515045 & value=Item{version=6,freshTimestamp=4850967374274560}
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - item will expire at: 07/13/2007 09:21:462007-07-13 09:16:46,641 [10] DEBUG NHibernate.Cache.ReadWriteCache - Cached: testnHibernate.Parent, testnHibernate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null#e02e6c2c-ad48-4b92-815e-37e450addb9b
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Impl.SessionImpl - done materializing entity [testnHibernate.Parent#e02e6c2c-ad48-4b92-815e-37e450addb9b]
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Impl.SessionImpl - resolving associations for: [testnHibernate.Parent#a5aa0ab6-a396-4ce6-8163-bb3e4dbdcd6c]
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Impl.SessionImpl - adding entity to second-level cache [testnHibernate.Parent#a5aa0ab6-a396-4ce6-8163-bb3e4dbdcd6c]
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Cache.ReadWriteCache - Caching: testnHibernate.Parent, testnHibernate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null#a5aa0ab6-a396-4ce6-8163-bb3e4dbdcd6c
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - Fetching object 'NHibernate-Cache:Parent:testnHibernate.Parent, testnHibernate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null#a5aa0ab6-a396-4ce6-8163-bb3e4dbdcd6c@-1120123332' from the cache.
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - adding new data: key=NHibernate-Cache:Parent:testnHibernate.Parent, testnHibernate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null#a5aa0ab6-a396-4ce6-8163-bb3e4dbdcd6c@-1120123332 & value=Item{version=0,freshTimestamp=4850967374401536}
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - item will expire at: 07/13/2007 09:21:46
2007-07-13 09:16:46,641 [10]
DEBUG NHibernate.Cache.ReadWriteCache - Cached: testnHibernate.Parent, testnHibernate, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null#a5aa0ab6-a396-4ce6-8163-bb3e4dbdcd6c
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Impl.SessionImpl - done materializing entity [testnHibernate.Parent#a5aa0ab6-a396-4ce6-8163-bb3e4dbdcd6c]
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Impl.SessionImpl - initializing non-lazy collections
2007-07-13 09:16:46,641 [10] DEBUG NHibernate.Cache.StandardQueryCache - caching query results in region: Parent
2007-07-13 09:16:46,657 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - adding new data: key=NHibernate-Cache:Parent:sql: exec usp_GetParentList; parameters: []; named parameters: {}; first row: 0@-1327527374 & value=System.Collections.ArrayList
2007-07-13 09:16:46,657 [10] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - item will expire at: 07/13/2007 09:21:46
2007-07-13 09:16:46,657 [10] DEBUG NHibernate.Impl.ConnectionManager - after autocommit
2007-07-13 09:16:46,657 [10] DEBUG NHibernate.Impl.ConnectionManager - aggressively releasing database connection
2007-07-13 09:16:46,657 [10] DEBUG NHibernate.Impl.SessionImpl - transaction completion
2007-07-13 09:16:46,829 [4] DEBUG NHibernate.Caches.SysCache2.SysCacheRegion - Cache items for region 'Parent' have been removed from the cache for the following reason : DependencyChanged


Top
 Profile  
 
 Post subject:
PostPosted: Thu Feb 19, 2009 9:04 pm 
I know it's an old post, but it's the exact same problem I had. I think the fix is here http://forum.hibernate.org/viewtopic.ph ... 01#2406601 in case anybody finds this article.


Top
  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.