My Oracle Support Banner

REFRESH Hint On Object That Contains @JoinFetch Does Not Refresh Cache (Doc ID 1595690.1)

Last updated on MARCH 01, 2021

Applies to:

Oracle TopLink - Version to [Release 12c]
Information in this document applies to any platform.



NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


When REFRESH hint is set to true on a query for an object that contains @JoinFetch relationship, the related objects are not updated with changes from the database. For example:

Project -- ManyToOne --> Employee

The ManyToOne is also annotated with @JoinFetch. Query the Plan object and after that re-querying the Plan object with the REFRESH hint set to true you will not see any changes in the database from out of bounds update to the Service object (e.g. out of bounds update could be from another appserver or application).

Example Environment:

java version "1.6.0_43"
Oracle 11g with Oracle Thin JDBC Driver




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.