Re: [eclipselink-users] Query Cache Issue

[Tom Ware <tom.ware@xxxxxxxxxx>]

The two refresh options are your best bet then.  Whenever you run a query that 
you wish to force to the db, just use the refresh query hint:

eclipselink.refresh=true

jz wrote:
> I do not want to disable cache completely just that the query interface 
> should not use cache.
>
> On Tue, Nov 2, 2010 at 6:35 PM, Tom Ware <tom.ware@xxxxxxxxxx 
> <mailto:tom.ware@xxxxxxxxxx>> wrote:
>
>     There are lots of cache settings in EclipseLink.
>
>     The simplest way to refresh from the cache is:
>
>     1. entityManager.refresh()
>     2. Our refresh query hint
>
>     You could also disable sharing of the cache with the persistence
>     unit property eclipselink.cache.shared.default = false.
>
>     -Tom
>
>     jz wrote:
>
>         Hi,
>
>         Please help. Thanks.
>
>
>         On Mon, Nov 1, 2010 at 3:23 PM, jz <jehanzeb.qayyum@xxxxxxxxx
>         <mailto:jehanzeb.qayyum@xxxxxxxxx>
>         <mailto:jehanzeb.qayyum@xxxxxxxxx
>         <mailto:jehanzeb.qayyum@xxxxxxxxx>>> wrote:
>
>            Hi,
>
>            I am using eclipselink jpa 2.1.1, and transactional scoped
>         em. When
>            i merge/update an entity in one transaction and then read it
>         using
>            select query in another transaction, it gives me the cached copy.
>            And not the one in db. How can i control this behavior from
>            persistence.xml.
>
>            I have tried     <property
>         name="eclipselink.query-results-cache" value="false"/>
>            But not working.
>
>
>
>            Thanks
>
>
>         ------------------------------------------------------------------------
>
>         _______________________________________________
>         eclipselink-users mailing list
>         eclipselink-users@xxxxxxxxxxx <mailto:eclipselink-users@xxxxxxxxxxx>
>         https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
>     _______________________________________________
>     eclipselink-users mailing list
>     eclipselink-users@xxxxxxxxxxx <mailto:eclipselink-users@xxxxxxxxxxx>
>     https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users