使用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
