What do REFRESH and MERGE mean in terms of databases?

André Chalella picture André Chalella · May 7, 2009 · Viewed 66.5k times · Source

I'm curious and need to find this answer quick. Google won't help much.

The Java Persistence API has these properties that tell the framework to cascade operations on associated entities:

CascadeType.PERSIST
CascadeType.DELETE
CascadeType.MERGE
CascadeType.REFRESH

I know what the first two mean: when I persist object A which has B, persist B as well, and when I delete A, delete B as well.

But I can't make any sense of what the other two accomplish. Help?

Answer

cgp picture cgp · May 7, 2009

JPA Annotation Meaning for Many to Many relationships:

  • ALL - all possible cascading operations performed on the source entity are cascaded to the target of the association.
  • MERGE - if the source entity is merged, the merge is cascaded to the target of the association.
  • PERSIST - if the source entity is persisted, the persist is cascaded to the target of the association.
  • REFRESH - if the source entity is refreshed, the refresh is cascaded to the target of the association.
  • REMOVE - if the source entity is removed, the target of the association is also removed.

I myself see them this way (more readable):

  • MERGE - for existing objects, to merge the existing data in the table with the data in my object. (sync to database)
  • PERSIST - is create new records from object in the database.
  • REFRESH - is to refresh the data in the object. Perhaps there was a change on the database which needs to be synced. (sync from database)
  • REMOVE - is, well, delete.