difference between 'detach' and 'remove' entityManager's methods

jpa jpql entitymanager
ThunderPhoenix picture ThunderPhoenix · Aug 29, 2013 · Viewed 15.7k times · Source

I would like to know what's the real difference between em.detach(entity), em.remove(entity) and using a JPQL request like :

em.createQuery("DELETE FROM Country").exceuteUpdate();

thanks.

Answer

JGutierrezC picture JGutierrezC · Aug 29, 2013 
void detach(java.lang.Object entity)

Remove the given entity from the persistence context, causing a managed entity to become detached. Unflushed changes made to the entity if any (including removal of the entity), will not be synchronized to the database. Entities which previously referenced the detached entity will continue to reference it.

void remove(java.lang.Object entity)

Remove the entity instance. The database is affected right away.

em.createQuery("DELETE FROM Country").exceuteUpdate();

Does the Delete directly to database, if you have that object, for example, saved in any list or it is a simple referenced object, it wont get the changes, and surely raise an error if you try to merge, or do something with that. Trust me, don't do a delete like this, unless it is your last choice.

Hope this to be a clear answer!

Best regards!

Related questions

Adding IN clause List to a JPA Query

I have built a NamedQuery that looks like this: @NamedQuery(name = "EventLog.viewDatesInclude", query = "SELECT el FROM EventLog el WHERE el.timeMark >= :dateFrom AND " + "el.timeMark <= :dateTo AND " + "el.name IN (:inclList)") What I want to do is …

Read More
JPQL IN clause: Java-Arrays (or Lists, Sets...)?

I would like to load all objects that have a textual tag set to any of a small but arbitrary number of values from our database. The logical way to go about this in SQL would be to build an "…

Read More
IN-clause in HQL or Java Persistence Query Language

I have the following parametrised JPA, or Hibernate, query: SELECT entity FROM Entity entity WHERE name IN (?) I want to pass the parameter as an ArrayList<String>, is this possible? Hibernate current tells me, that java.lang.ClassCastException: …

Read More