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.
