Ah, sorry, didn't read properly, The mapping version should indeed work. 2016-05-13 10:52 GMT+02:00 Gunnar Liljas <[email protected]>:
> Does it work? I thought that function was not yet migrated to NHibernate > (the link is about Hibernate) > > /G > > 2016-05-12 17:35 GMT+02:00 Andrés Falcón <[email protected]>: > >> I fix it using <synchronize table=""/> inside <sql-query ...>. Note the >> table=*""* >> >> I found the solution at the end of this post >> https://www.link-intersystems.com/blog/2011/10/08/impact-of-native-sql-queries-on-hibernates-second-level-cache/ >> >> Andrés Falcón >> >> >> El jueves, 12 de mayo de 2016, 7:11:39 (UTC-3), Andrés Falcón escribió: >>> >>> Hi, I have an issue executing a stored procedure from *sql-query* that >>> does an insert in a *Log *table. Before executing the query NH fires a >>> Cache Evict on other cached Entities. >>> >>> Is this the default behavior?? >>> Am I missing some configuration in the procedure or someone else to >>> avoid evicting cache?. I triedto set *Cacheable=false* but it didn´t >>> work. >>> >>> *My Cache config*: >>> >>> configuration.Cache(delegate(ICacheConfigurationProperties properties) >>> { >>> properties.Provider<NHibernate.Cache.HashtableCacheProvider>(); >>> properties.UseQueryCache = true; >>> }); >>> >>> configuration.EntityCache<FieldType>( >>> entityCacheconfig => {entityCacheconfig.Strategy = >>> EntityCacheUsage.ReadWrite; } >>> ); >>> configuration.EntityCache<FieldValue>( >>> entityCacheconfig => { entityCacheconfig.Strategy = >>> EntityCacheUsage.ReadWrite; } >>> ); >>> >>> thanks! >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
