how to insert record using native query in entitymanager code example

Example: update insert raw query JPA

@Transactional
public void updateActiveStatus(String criteriaId) {
  String updateQuery = "update table_name set status = false where criteria_id = :criteriaId ";
  EntityManager em = emf.createEntityManager();
  try {	
    em.joinTransaction();
    Query q =  em.createNativeQuery(updateQuery).setParameter( "criteriaId", criteriaId );
    q.executeUpdate();
  }finally{
  	em.close();
  }
}
//adding transation is neccesary in delete/update queries.

Tags:

Misc Example