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.
