javax.persistence.TransactionRequiredException: Executing an update/delete query

使用Spring Data JPA时，使用EntityManager进行原生SQL语句插入，出现javax.persistence.TransactionRequiredException: Executing an update/delete query的异常，使用@javax.transaction.Transactional和@org.springframework.transaction.annotation.Transactional都不行，最后发现可以使用如下方法进行事务管理：

@PersistenceUnit
private EntityManagerFactory    entityManagerFactory;

private void saveByEm(String sql) {


    EntityManager entityManager =entityManagerFactory.createEntityManager();

    Query query = entityManager.createNativeQuery(sql);

    entityManager.getTransaction().begin();

    query.executeUpdate();

    entityManager.getTransaction().commit();

    entityManager.close();

}
复制代码

参考链接：stackoverflow.com/questions/11016268/why-is-my-transaction-not-active-javax-persistence-transactionrequiredexception