This discussion is archived
1 Reply Latest reply: Apr 30, 2012 11:33 AM by ShaunSmith RSS

Grid Entity configuration. DBHint Grid READ config

934103 Newbie
Currently Being Moderated
In TopLink Grid/Entity configuration, if I write a JQL to select objects from a entity (select * from Executions where ….) and I use DB hint to force TopLink to load data from database, after JPA/Toplink reads the object/data from database, will it put the objects into the coherence cache?
How to design a coherence cache reload for TopLink Grid configuration?
  • 1. Re: Grid Entity configuration. DBHint Grid READ config
    ShaunSmith Explorer
    Currently Being Moderated
    Yes, objects read from the database will be placed into the cache. This is true when using Coherence with TopLink Grid or the built in TopLink shared cache.

    You can warm the cache by simply issuing a query with a hint forcing the query to disk. In the case of a cache warming process you can also query with a read-only hint to improve performance. Also, you can avoid later database queries by performing join queries to load related objects.

    --Shaun                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points