cache 1 « Query « JPA Q&A
1. automatic query cache invalidation stackoverflow.comhi |
2. understanding hibernate cache stackoverflow.comIf I have this method in object class: |
3. Need to solve a query cache problem stackoverflow.comI'm developing an double-entry accounting system and I need to insert posting records without any gaps in the sequential id. Since all database access will happen through a web application, I'm ... |
4. Hibernate 3.5.5, Second Level Cache Configuration stackoverflow.comAfter implement Hibernate Monitoring, i have noticed that hibernate execute too much query than it have on the query string table in statistics.
Screen-shots of statistics:
|
5. JPA: caching queries stackoverflow.comI'm using JPA to load and persist entities in my JEE-based web application. Hibernate is used as an implementation of JPA, but I don't use Hibernate-specific features and only work with ... |
6. Hibernate Query cache eviction strategy stackoverflow.comFor a simple Post-Tag @ManyToMany scenario like this one @ManyToMany inconsistent data on both side problem It seems that hibernate's 2nd level cache doesn't know the time to update the aggregation ... |
7. Hibernate - Does the resulting SQL from a HQL query get cached by the hibernate system? stackoverflow.comHibernate 3.3 If I've got code that is dynamically creating hibernate hql queries like |
8. Hibernate, second level cache and query cache stackoverflow.comI'm using Hibernate with Ehcache (don't think it matters, tho).. When a user logs in I identify him by his email and I use his email for all subsequent calls. Now, since email ... |
9. efficient queries for the use of hibernate cache stackoverflow.comI use JPA with Hibernate implementation. My question is probably basic for experienced hibernate users: what is the most efficient way to write queries based on Hibernate first level cache? For example, ... |
10. How to use hibernate query cache coderanch.comHi, I have setup ehcache as hibernate query cache. But when I execute the same query multiple times, it still go and query the database (from the hibernate sql out, it still executes mysql query). Can you please tell me what am i missing? Here is why I did in my hibernate.cfg.xml file: Add these: |
11. Hibernate Query Cache coderanch.comHi, I try to setup Hibernate Query Cache, I am using ehcache. It works in the beginning (i.e. if i execute the same query multiple times, it does not send the sql commands to mysql everytime). however, after about 1 minutes, the cache seems expire (i.e. I see hibernate executes sql commmands to the database. I have the following configuration in ... |
12. hibernate query cache coderanch.comHi All, I have configured hibernate query cache in my app. I want to use the query cache for one specific part of the application where in there is heavy database roundtrip. The query in question is SQL query (not HQL due to union clause) and is accessed a lot many times during one application flow. We wanted to utilise queryCache ... |
13. Regarding the Hibernate Query Cache coderanch.com |
14. caching for SQL queries via Hibernate not HQL coderanch.comHi All, I have a specific table data which I want to load it in hibernate cache (ehcache) and utilize hibernate cache features. The query operating on this data is a SQL query and not the normal HQL query. How can I utilize cache for SQL queries executed through Hibernate layer. How to get the entire table data loaded in memory ... |
15. Hibernate Read-Only Cache Query coderanch.comHi All, I'm a new bie to hibernate caching. I need youe help in understanding the cache expiration criteria. In my application i have lot of configurational data's (read only data and updated very rarely) in a table and i would like to use "Read-only" caching strategy to cache the configurational data's. I read about an article of hibernate caching and ... |
16. Hibernate Query Caching - Why the misses? coderanch.comHi, I'm using Hibernate 3.5 and ehcache 2.2.0 and have decided to improve my applications performance by implementing query caching. The problem I'm having is that according to the SessionFactory statistics, my second level query cache hits are 0 (i.e. I only get misses). However, if I watch my console I can see that the number of queries being executed by ... |
17. Query Cache behaviour which I don't understand forum.hibernate.orgI'm seeing the following behaviour in Hibernate 3.3.2 which doesn't fit my mental model of how Sessions and the Query Cache work. I'm using two sessions from the same thread: 1. Session A: do a select using a candidate key -- but defined as |
18. Query cache across multiple requests forum.hibernate.orgHi, I am new to hibernate cache concepts. Is there a way to use the query cache across multiple request like the second level cache it does? I wrote the (Grails 1.2.2) code below to experiment with the hibernate cache. I observed that for a request the Composition domain class is cached in the for loop. There is only one database ... |
19. Hibernate newbie has second level cache query forum.hibernate.orgI'm playing around with second level caching. I have a test that loops around a block of code that creates a session, does a query, then closes the session. It displays how long each iteration in the loop takes. With caching turned on, it takes a few seconds to do the first iteration, then a few milliseconds to do the rest. ... |
20. Query cache expires prematurely forum.hibernate.orgAuthor Message jeromeblouin Post subject: Query cache expires prematurely Posted: Tue Jun 01, 2010 1:32 pm Newbie Joined: Mon Mar 05, 2007 5:12 pm Posts: 3 Hello, our hotel reservation system is using the L2 cache with the query cache. The issue I'm seeing is that it seems that after the cache size of the HotelImpl domain object is ... |
21. Hibernate Query Caching forum.hibernate.orgDear all, I'm using ehCache for caching the queries in order to achieve a better performance for my product that basically authenticates users. Following is an extract from my ehcache.xml for the classes set for caching. Code: |
22. Trying to understand the L2 cache, NamedQueries vs. em.find forum.hibernate.orgHi guys I have made a basic example in order to try to understand how the L2 cache in Hibernate is working. I am using JPA2 with the latest Hibernate Entitymanager, and EhCache as cache provider. My example first finds and object by its primary key in the entity manager, and then does the same thing using a named query: Code: ... |
23. Need to solve a query cache problem forum.hibernate.orgNewbie Joined: Mon Aug 09, 2010 8:30 pm Posts: 1 Hi, I'm developing an double-entry accounting system and I need to insert posting records without any gaps in the sequential id. Since all database access will happen through a web application, I'm taking care of id generation using a syncronized static variable: Code: import org.hibernate.*; public class JournalService { ... |
24. Back end changes not reflecting through query cache. forum.hibernate.orgHi, Problem : Caching the Query is working but if any of the data modifies at back end it is not showing in the UI. I am using hibernate query level caching with second level cache. I have set the below two line in my hibernate xml file. |
25. very strange behavior from the query cache forum.hibernate.orghi all, I have a very strange problem with the query cache! When i start my application, everything is fine the query cache works as expected : when i execute a criteria request, the query is put into cache and so are the returned objects (even the fetch objects). But if I clear my caches, my problems start : if I ... |
26. query cache and object references forum.hibernate.orghey, Some data used by my application are modified by external batchs, so i need to have the possibility to clear my entity/collection cache. I do this using the 2 following methods : Code: private void clearCollectionCache(SessionFactory factory) { Map |
27. Augmenting query cache : long-lived, incremental query forum.hibernate.orgHello! I have this idea for extending how the Hibernate query cache works, but I don't know nearly enough to tell if this is feasible or not: Suppose I have a fixed SQL query Q, and I want to track the result set of Q as other users update the database (via Hibernate ). But, I don't want to keep hitting ... |
28. HQL queries and standard query cache misses. forum.hibernate.orgHi all, fairly new to hibernate so please be kind! In short, have query caching switched on, and am creating and running named queries, expecting a second invocation of the same named query with the same parameter to hit the cache. However, the cache is 'missed' (looks like cache is keyed on SQL) ? Am using ehcache 1.7.0 Core and hibernate ... |
29. Query cache forum.hibernate.orgOne thing I've been milling around in my head for awhile in the JBoss CMP world is the concept of a query cache and I'm wondering if the concept could be applied to the Hibernate world. Here are the parameters for a simply implemented query cache: - Hibernate has sole access to datasource - Access is read-mostly This is how it ... |
30. Query Cache Problem forum.hibernate.orgI'm trying to cache the results of a very repetitive query, and am running into problems using the new query cache of 2.1 rc1. I've configured my second-level cache (I'm using OSCache) so that it is unlimited for the time being, I've put the |
31. Query cache and cache provider support forum.hibernate.orgQuery cache was supported since Hibernate 2.1 beta 4. We are using SwarmCache for our clustered environment. From the Hibernate document section 12.2, it states that SwarmCache does not support the query cache, but others do. so my question is: do I have to switch to JBoss TreeCache, for example, in order to use query caches in my application? Thanks in ... |
32. ORDER BY and Cache forum.hibernate.orgCould it be that using the ORDER BY clause in queries disables caching for these queries completely? I am experiencing relatively harmless queries like "FROM users ORDER BY name" missing any cache and accessing the DB every time. I have configured ehcache for second level and switched on the query cache. Each class of my object model has got the "nonstrict-read-write" ... |
33. Query cache using Tangosol forum.hibernate.orgSection 12.4 of the Hibernate docs talks about the Query cache and it's usefulness in caching frequently run queries. I have specified the following properties in the session-factory configuration files: hibernate.cache.use_query_cache = true hibernate.cache.provider_class = org.mitre.cache.HibernateTangosolCacheProvider The documentation is a little weak when it comes to explaining the expiration policies: "If you require fine-grained control over query cache expiration policies, you ... |
34. select Object from Cache ! forum.hibernate.org |
35. cache: could not find configuration forum.hibernate.orgHello, I am trying to use the cache for some time, and combined with createQuery, things go well; I have however one message at startup which tells me that something is missing: at startup I am getting this message: 11:08:57,031 WARN Plugin:95 - Could not find configuration for eu.cec.admin.epes.services.exercice.Exercice. Configuring using the defaultCache settings. this message appears for each |
36. Could not destroy query cache forum.hibernate.orgI am using OSCache 2.0.1 with Hibernate 2.1 in web app running on Tomcat 4.0.6. I get this exception when stopping Tomcat servlet. Is this OSCache problem or Hibernate's? Tnx, Ales Justin -------- exception stack trace ------- WARN [20-02-2004 12:26:46] (QueryCache.java:90) - could not destroy query cache: net.sf.hibernate.cache.QueryCache java.lang.NullPointerException at com.opensymphony.oscache.base.AbstractCacheAdministrator.finalizeListeners(AbstractCacheAdministrator.java:326) at com.opensymphony.oscache.general.GeneralCacheAdministrator.destroy(GeneralCacheAdministrator.java:187) at net.sf.hibernate.cache.OSCache.destroy(OSCache.java:51) at net.sf.hibernate.cache.QueryCache.destroy(QueryCache.java:87) at net.sf.hibernate.impl.SessionFactoryImpl.close(SessionFactoryImpl.java:549) at com.generalynx.gema.hibernate.HibernateSessionFactory.dispose(HibernateSessionFactory.java:56) ... |
37. OSCache & Query Cache forum.hibernate.orgAccording to the docs, the query cache works properly with OSCache. I'm trying to switch from EHCache to OSCache due to a very difficult to track down bug that I'm encountering. I don't know if it's due to EHCache, or some other factor, so for now, I'm going to try to switch caches to see if the problem goes away. I'm ... |
38. Query Cache forum.hibernate.orgI read about UpdateTimestampsCache, QueryCache. But i want to be more clear about it. Now i would like to understand how exactly cache is working. I have one-to-many relation between Place & Person classes. I am calling the below code twice in my test program to test performance which works good. Each call loads Place and set of persons for the ... |
39. Problem with query caching in Hibernate 2.1.3 forum.hibernate.orgNewbie Joined: Wed Jan 07, 2004 11:34 am Posts: 11 Location: London, UK I've got a problem with 2.1.3 query caching - it doesn't seem to work for me (everything was fine under 2.1.2). I've stripped some test code out of my WL environment and brought it down to a minimal set of code - Code: package test; import net.sf.hibernate.SessionFactory; import ... |
40. Cache query forum.hibernate.orgWe are currently finishing the last bits of a real estate app. We've found out that all our classes can be cached for read-write purposes. My question is: memory and disk resources aside, are there any inconveniences of setting all mappings as cacheable? And what about collections? It would be highly appreciated if someone could point me out to a "study" ... |
41. Unexpected query-cache behaviour forum.hibernate.org |
42. Distributed query cache? forum.hibernate.org |
43. Query Cache forum.hibernate.org |
44. Query Cache forum.hibernate.org |
45. Query Cache Problem/Extension? forum.hibernate.orgHibernate version:2.1.6 Mapping documents: (Unless there really is a problem with my setup, this isn't really relevant.) Code between sessionFactory.openSession() and session.close():(Unless there really is a problem with my setup, this isn't really relevant either.) Name and version of the database you are using: MySQL (prolly not relevant) After playing around with hibernate it appears that if you call Query.iterator() ( ... |
46. SessionFactory.evict()'s effect on Collection/Query cache forum.hibernate.orgHibernet 2.1 I'm using Hibernate with SwarmCache as my 2nd level cache. If I make a call to SessionFactory.evict(Foo.class, someID) will this also evict any collections and cached queries in which this object is involved? In looking at the NonstrictReadWriteCache code, I'm guessing that it does not. The motivation for this question is because I'm trying to do a bunch of ... |
47. How does query cache work? forum.hibernate.orgLets consider the following scenario. we have a query like this and we are using the query cache for this. "* from com.xxx.PO where PO.value=10 and PO.xyz=20" For the first time the query returns 10 rows and hibernate caches the IDs of these 10 rows. Lets assume that in some other session, the values of some of the rows are changed. ... |
48. secondary-cache query cache read-only forum.hibernate.orgRegular Joined: Sat Feb 21, 2004 8:54 pm Posts: 60 Location: Lakewood, California hi, trying to get some stuf in to secondary cache. secondary cachng seems to work fine automatically when i find stuff by pk (the timings get better). the data i am reading is immutable, but i need to access it by a unique value that is not the ... |
49. 2nd level Caching - Query & Criteria forum.hibernate.orgThanks. I was playing around with the caching. If I used 'get' based on the id it would cache it. But if I used criteria in conjunction with the setCachable flag it would not work (still need to figure this out; I'm using Ehcache which says it has query caching). Let me describe what I'm doing and you can probably suggest ... |
50. Cached query forum.hibernate.org |
51. Query Caching forum.hibernate.org |
52. Query caching and swarm cache forum.hibernate.orgHibernate version: 2.1.7c I've read a previous post relating to query caching and the various cache providers here, but didn't want to revive that old thread. My question relates to Hibernate's query caching mechanism, and in particular, the SwarmCache provider. I've been tracing through the Hibernate source and debugging my application today, and I can't figure out why the query cache ... |
53. Query cache not working. Miss at each query forum.hibernate.orgHi. I can't get the query cache to work. Can somebody please advice me how to debug the problem? Each call of the same query "misses" and hits the db again. Thans for any suggestion. /roberto Hibernate version: 2.1.3 Code between sessionFactory.openSession() and session.close(): final String query = "from Setting setting " + "where setting.key = :my_key and setting.type = :my_type ... |
54. Query Cache forum.hibernate.orgHi I'm using ehcache for caching the query results using th flg code ... |
55. Query caching forum.hibernate.orgEnvironment Information: Not rquired This is for general information. I spent a lot of time going through documents and forums before figuring this out. IMO the documentation should clearly mention that query caching does not work if Query.iterate() is used - Query.list() must be used. Assuming that hibernate.cache.use_query_cache has been set to true The query results from this snippet will NOT ... |
56. Hibernate Query Cache with TreeCache and 2.1.8 forum.hibernate.orgHibernate version: 2.1.8 Name and version of the database you are using:Oracle 9 Hi, I am trying to use the Hibernate Query Cache with Hibernate 2.1.8 and TreeCache. Origionally I got the exception that I beleive is already known, similar to this: Code: ERROR [org.jboss.cache.lock.IdentityLock] write lock for //net/sf/hibernate/cache/UpdateTimestampsCache/Customer could not be acquired after 15000 ms. Lock map ownership Read lock ... |
57. Preload the query cache? forum.hibernate.orgI'm experimenting with the auction mapping in the hibernate examples. I'd like to load all the auction items and bids into memory with a minimum of queries. I do one query: load all the AuctionItems: Session session = factory.openSession(); List auctionItems = session.createQuery("from AuctionItem").list(); Then I iterate over the auctionItems, getting their bids (because it's a lazy collection), generating sql (in ... |
58. Caching scalar queries forum.hibernate.orgHi, I have create a cacheable query like this : Code: session.createQuery( "select count(*) from mt.domain.geo.Land land where land.landCode=:landCode") ... |
59. caching queries forum.hibernate.org |
60. query cache sometimes used and sometimes not used forum.hibernate.orgThe hibernate query cache only seems to work for some queries. What are the criteria for which queries are or are not cached? When I call query.setCacheable(true); after a query, sometimes the query gets cached and sometimes it does not. See the sql below to see a few of the queries that are not being cached. Hibernate version: 3.0.2 The generated ... |
61. Query cache forum.hibernate.orgI haven't found any specific documentation that details this, just pieces that allude to it. Say I have a report object that is mapped in Hibernate with a composite primary key. The key is report number and a report version. If I have the second level cache enabled, the report object will be cached in a disassembled state with the composite ... |
62. selecting pooling implementations and caching implementation forum.hibernate.org |
63. the query cache forum.hibernate.orgSet hibernate.show_sql true and try to execute your method. You'll find that Hibernate generates a SQL statement (and executes it) to fulfill your request, in your example getting all Blog objects. If you execute the same method another time, no SQL is executed and data is simply taken from cache. You don't have to worry about cache management. |
64. Hibernate Query Caching forum.hibernate.org |
65. Query & Second level Cache forum.hibernate.orgHibernate version: 3.0.4 Second level Cache Provider: EHCache Hi, 1) I am executing a query with setCacheable(true) and a specific cache region namely "entity". I have enabled query cache as well. Am I right in thinking that all that this action does is store the sql string with the id's of the entities returned ? 2) If I want to take ... |
66. Caching and querying strategies for reference tables forum.hibernate.orgI am trying to come up with the best strategy for handling reference data. We have several small read-only tables (10-100) records that are frequently accessed by the application. We need to be able to query those tables sometimes joined with other tables for sorting purposes, so the data has to be in the database. However, often times we just need ... |
67. Cached queries in SessionFactoryImpl.softQueryCache forum.hibernate.orgHi, Our application is deployed a little bit differently than usual. Hibernate is loaded and initialized by the main container classloader and the actual application is loaded by a child classloader (like a web application). The problem arises when the application is reloaded by discarding the child classloader and creating another one. The problem is that when using scalar queries with ... |
68. Query cache? forum.hibernate.orgHi all, I have a application suffering query cache problem. My env: Win2k pro hibernate2 tomcat5.0 mysql4.1.9 When I changed the column's value via mysql client, but read the original data from hibernate, seems that hibernate cached the data. And I have changed hibernate.cache.use_query_cache to false. So,,, which config parameter control this? |
69. Second level cache and query caching forum.hibernate.orgHi there, I have a problem getting second level caching working together with query caching. I am using a second level cache with clustered invalidation (OSCache). The problem I am experiencing are manifested as follows: 1 A node believes a entry in the StandardQueryCachis up to date as long as the UpdateTimestampsCache says it is so. 2 UpdateTimestampsCache says a entry ... |
70. How to use the L2 object (not query) cache? forum.hibernate.orgNeed help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: 3.0.5 Mapping documents: |
71. How to handle dirty check without select or cache? forum.hibernate.orgI am new to hibernate so i want to discuss with the hibernate community the best way to implement following solution to handle ditry check without select before update or force action to be in the same transaction. // object which extends by all the pojos PersistObject // 0 = new // 1 = unmodified // 2 = updated // 3 ... |
72. Query cache invalidation from dependant table forum.hibernate.orgHibernate version: 3.1rc2 I'm using query cache in an application that gets values from a view, but writes changes on tables. The query of the view V1 is something like that: SELECT A.SOMETHING, B.SOMETHING_ELSE FROM A, B WHERE ... The problem rises when I try to use query cache. The UpdateTimestampsCache of V1 is never updated (obviously, as it's a read-only ... |
73. Querying from the cache - is this possible? forum.hibernate.orgHi, I'm a newbie to Hibernate, so I'm not sure if I have all the fundamental concepts right, but I did try to read as much documentation as I could that seemed relevant to my problem. My understanding is that when you start a new session and perform an save a new model object (i.e. change an object from being transient ... |
74. Disable query cache forum.hibernate.orgHi all. I have an application that collects a collection of objects, and other that inserts elements in this collection. I want to refresh the items of this collection every time I consult these, while this other application inserts other items. I tryed some stuff like these: Code: public static Session getSession() throws Exception { ... |
75. setting query cache regions forum.hibernate.org |
76. LazyInitializationError on enabling query cache forum.hibernate.orgBeginner Joined: Tue Jul 20, 2004 1:53 am Posts: 43 Location: India I have two domain objects - Employee and Department - and there is a 1:N relationship from Department to Employee. When I join fetch an Employee with its Department, without query cache enabled, it works fine. If I enable query cache for this same query, it bombs with a ... |
77. Hibernate Query Cache !! forum.hibernate.org |
78. Statistics of query cache forum.hibernate.orgHi, I configured everything to use query cache... here is my code... Query query1 = session.createQuery("from salegroup where id=123") .setCacheable(true) .setCacheMode(CacheMode.NORMAL) .setCacheRegion("salegrp"); and to test .... Statistics stats = sessionFactory.getStatistics(); double queryCacheHitCount = stats.getQueryCacheHitCount(); double queryCacheMissCount = stats.getQueryCacheMissCount(); double queryCachePutCount = stats.getQueryCachePutCount(); and the cofig file entry ... |
79. "Selective" query caching? forum.hibernate.orgHi, I've looked around in forums and the HIA book without luck. I'm wondering if it is possible to only cache a query given a set of conditions, for example, only if the result set is not empty. What I would expect HB to do would be to: for a given a query Q: lookup Q's result set in cache region ... |
80. can anybody explaing query cache, first level and second l forum.hibernate.org |
81. Query Cache And L2 Cache Behavior forum.hibernate.orgHi all! I have Hibernate program with use_query_cache ON and use_second_level_cache ON. I have problem describet follow example. 1 Moment When I execute some query createQuery("from Orders where status in (1,2) ") the Orders's Ids will saved Query Cache, and Orders's object will saved in SecondLevel Cache. The query returned 10 Orders (there are Orders with Id = 12345 (for example). ... |
82. "cheap query" cache invalidation forum.hibernate.orgHi, Cache invalidation based on a cheap query result, like "select max(timestamp)", before an optimistic transaction or a cached reporting query can be quite useful technique sometimes : in clustered environement or when the same DB is concurrently updated by non-hibernate applications. It this possible with Hibernate today? Is it the responsibility of the application to do the job, or do ... |
83. Select IN criteria query and caching forum.hibernate.org |
84. Cache troubles when using queries ? forum.hibernate.orgAre you actually commiting the transaction and closing the session? Changes in other transactions are not supposed to be visible in your current transaction. One of the design patterns in Hibernate is to use long running transactions that can encompass several http screens (a conversation). Maybe you are misusing this pattern here? I hope this helps :) Marius |
85. Query Cache not working forum.hibernate.orgHibernate version: 3.1.3 Mapping documents: Code: |
86. How to setup Hibernate query cache. forum.hibernate.orgHi, I have setup hibernate query cache. But when I execute the same query multiple times, it still go and query the database (from the hibernate sql out in the console, it still executes mysql query). Can you please tell me what am i missing? Here is why I did in my hibernate.cfg.xml file: Add these: |
87. Query Caching forum.hibernate.orgFull stack trace of any exception that occurs: java.lang.reflect.InvocationTargetEx ception |
88. unable to locate HQL query plan in cache forum.hibernate.org |
89. plain SQL queries and caching forum.hibernate.org |
90. Distributed query cache forum.hibernate.orgHibernate version: 3.2.2 Hibernate configuration: (with Spring support) Code: |
91. How to avoid query cache invalidation forum.hibernate.orgHi, I have a question about using hibernate. I'm using Hibernate 3.1. I have queries on my web site that shows the most viewed videos, for example. Despite the fact I'm using query caching, since number of views change all the time, those caches will get invalidated almost instantly. I'm wondering if there are any way for me to just use ... |
92. Clearing a query out of cache forum.hibernate.org |
93. Can JBC REPL_SYNC be used with query caching? forum.hibernate.org |
94. Using Query Cache & Second-level cache forum.hibernate.orgHi, I would like to know if the following is possible to achieve using query cache mechanism. Being a fresher to Hibernate, I understood the basic purpose of using query cache, ie, to fetch the data from the cache instead of fetching from the DB each and every time which increases the performance. My requirement is as follows- I fetch a ... |
95. Query cache reloading forum.hibernate.orgNewbie question: I'm loading a small set of non-associated data into the hibernate cache (using ehcache), but every time I update or delete any entity in the set, the cache is completely invalidated. For this reason, on the next query (after the update or delete), hibernate reads all the data from the database. Why doesn't it just update or delete from ... |
96. Select subset of query cache forum.hibernate.org |
97. duplicate second level caching on queries forum.hibernate.orgHello, I'm using hibernate 3. I have a question about using second level caching. Currently I use ehcache. I have noticed that my objects are being recached pretty often when there are no changes to them. After some debugging, I found that each time I run a read-only query, any objects that are returned in the query somehow get re-put into ... |
98. OSCache hiberate query cache forum.hibernate.orgCode: [com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache] - [oscache] Exception persisting sql: select ticket0_.ticketId as ticketId1_, ticket0_.ticketType as ticketType1_, ticket0_.active as active1_ from TICKET ticket0_ where ticket0_.peopleId = ? and ticket0_.active=0; parameters: 1, ; named parameters: {}.org.hibernate.cache.StandardQueryCache com.opensymphony.oscache.base.persistence.CachePersistenceException: Unable to write 'c:\myapp\cache\application\sql__select_ticket0__ticketId_as_ticketId1_,_ticket0__ticketType_as_ticketType1_,_ticket0__active_as_active1__from_TICKET_ticket0__where_ticket0__peopleId_=_?_and_ticket0__active=0__parameters__1,___named_parameters__{}_org_hibernate_cache_StandardQueryCache.cache' in the cache. Exception: java.io.FileNotFoundException, Message: c:\myapp\cache\application\sql__select_ticket0__ticketId_as_ticketId1_,_ticket0__ticketType_as_ticketType1_,_ticket0__active_as_active1__from_TICKET_ticket0__where_ticket0__peopleId_=_?_and_ticket0__active=0__parameters__1,___named_parameters__{}_org_hibernate_cache_StandardQueryCache.cache (The filename, directory name, or volume label syntax is incorrect) at com.opensymphony.oscache.plugins.diskpersistence.AbstractDiskPersistenceListener.store(AbstractDiskPersistenceListener.java:350) ... |
99. Query Cache doesn't work as expected forum.hibernate.orgDear guru, I am trying to use query cache and have found it not working in my configuration. Below are details. Mapping: Code: |
100. Object and query cache inconsistencies. forum.hibernate.orgAuthor Message seilnacht Post subject: Object and query cache inconsistencies. Posted: Thu Aug 16, 2007 2:46 pm Newbie Joined: Thu Aug 16, 2007 1:34 pm Posts: 3 I have a test case that isolates a caching problem I am experiencing. 1. I use a query (setCacheable==true) to retieve a BillingMethod object from the database, for which I see the ... |
I think, implement hibernate ...