SQL « Cache « JPA Q&A

  1. JPA Q&A
  2. Cache
  3. SQL




1. Controlling when SQL UPDATE is executing on ehcache 'd classes    stackoverflow.com

We are using Hibernate and ehcache as 2nd level cache. If I load an entity that is cached (e.g. cache-usage="read-write") and update it, it seems that this immediately results in an SQL ...

2. When to use Hibernate caching (second level)?    stackoverflow.com

This is a basic question about Hibernate Caching, but I've to be sure before going forward. I had use query caching before in small projects, but now I'm involved in a ...

3. SQL filter cache    forum.hibernate.org

I'm suffering the same problem right now and it does look very much like Hibernate is using a cached version of the resulting SQL for the filter rather than re-generating the code. My problem is pretty similar to yours as described, using an "IN" directive in a filter but changing the number of parameters in the associated parameter list. Once the ...

4. Does Native SQL still use the cache?    forum.hibernate.org

5. Large SQL Updates And Caching...    forum.hibernate.org

Our application has a variety of batch processes that update 10k+ records. Many times we use sql updates for speed. Sometimes these updates are on an "object" contained in another object from a hibernate perspective. What techniques have people found using Hibernate to balance update speeds and caching/revalidation of data? Scott Delap

6. why the console couldnt show the sql when using the 2L cache    forum.hibernate.org

7. Native SQL and 2nd Level Caching    forum.hibernate.org

Hibernate Version: 3.3 Cache Provider: Ehcahce App Server: Websphere 6.1 + EJB 3 FTP Hi All, I just want to confirm that the use of native SQL queries via session.createSQLQuery(x).executeUpdate() will not cause problems with the 2nd Level cache becoming out of sync. Will both HQL and SQL updates be correctly sync'ed with the 2nd level cache? Thanks in advance. -- ...