jpa

Spring JPA报错：InvalidDataAccessResourceUsageException: could not extract ResultSet;

Spring JPA调用时报错InvalidDataAccessResourceUsageException: could not extract ResultSet错误，详细如下：org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nest

2020.03.31 23:32

Spring JPA报错：InvalidDataAccessApiUsageException: Executing an update/delete query

集成Spring JPA，在执行delete，update时需要添加事务。错误信息：org.springframework.dao.InvalidDataAccessApiUsageException: Executing an update/delete query; nested exception is javax.persistence.TransactionRequiredExcepti

2020.03.31 23:29

Spring JPA报错：Not supported for DML operations

在一个Spring JPA项目中，执行更新或删除是报错：Not supported for DML operations解决方法：只需要添加注解@Modifying即可。@Modifying@Query(value = "update User user set user.address = :address where user.id = :id ")void updateUserAddress

2020.03.31 11:10

Spring Boot 配置MySQL数据库重连

使用jdbc连接MySQL，如果连接失效，可能会报类似的错误：com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 84,371,623 milliseconds ago. The last packet sent suc

2018.04.18 16:07