What is the difference between
entitymanager.merge
query.executeUpdate
@Entity
@Table(name="ORDERS",schema ="AMZ")
public class Orders {
@Id
@SequenceGenerator(name = "pk_sequence", sequenceName = "ORDERS_SEQ", schema = "AMZ", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "pk_sequence")
@Column(name = "ORDERS_ID")
private long id;
@Column(name = "STATUS")
private Status status;
@Repository
@Transactional
public class InvoiceDAO {
@PersistenceContext
private EntityManager entityManager;
public void update(Order order){
updateInvoice();
mergeInvoice(Order order);
}
public void updateInvoice(){
entitymanager.createQuery("update Orders set status = 'ERROR' where id=12").executeUpdate();
}
public void mergeInvoice(Order order){
entitymanager.merge(order);
}
}
executeUpdate();
entityManager.flush();
I resolved this by calling the update and merge methods from service layer. I found that for the transaction to get commit I have to return out of my DAO.
public void update(Order order){
orderDao.updateInvoice();
orderDao.mergeInvoice(Order order);
}