我也来问问题了# Java - 爪哇娇娃
B*g
1 楼
spring注入以后怎么执行DML语句或者run一个stored procedure
import javax.persistence.Query;
@PersistenceContext
private EntityManager em;
public void updateValue() {
Query qr = em.createNativeQuery("DELETE FROM table WHERE id = 1688");
qr.executeUpdate();
}
Error:
org.springframework.dao.InvalidDataAccessApiUsageException: Executing an
update/delete query; nested exception is javax.persistence.
TransactionRequiredException: Executing an update/delete query
注入是成功的,因为可以进行select操作。加了@Modifying @Transactional,也不太
行。
谢谢
import javax.persistence.Query;
@PersistenceContext
private EntityManager em;
public void updateValue() {
Query qr = em.createNativeQuery("DELETE FROM table WHERE id = 1688");
qr.executeUpdate();
}
Error:
org.springframework.dao.InvalidDataAccessApiUsageException: Executing an
update/delete query; nested exception is javax.persistence.
TransactionRequiredException: Executing an update/delete query
注入是成功的,因为可以进行select操作。加了@Modifying @Transactional,也不太
行。
谢谢