【异常】java，2024年最新vb程序设计教程课后答案

最新推荐文章于 2024-07-10 21:37:49 发布

2401_84181253

最新推荐文章于 2024-07-10 21:37:49 发布

阅读量802

点赞数 25

分类专栏： 2024年程序员学习文章标签： java python windows

本文链接：https://blog.csdn.net/2401_84181253/article/details/137500531

版权

2024年程序员学习专栏收录该内容

72 篇文章 0 订阅

订阅专栏

The error occurred while setting parameters

### SQL: update t_trade set delete_status = 0 where order_id = ?
### Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
2019-04-25 18:12:04.014 [ ERROR ] ->* ; ]; Connection is read-only. Queries leading to data modification are not allowed; nested exception is java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed

查询资料后知道是事务配置的关系。报错的是接口方法名为：,

将get去掉后错误就没有了，原因是什么呢，原来是前辈在配置类中有这么一段代码：

// 创建事务通知
@Bean(name = “txAdvice”)
public TransactionInterceptor getAdvisor() throws Exception {
Properties properties = new Properties();
properties.setProperty(“get*”, “PROPAGATION_REQUIRED,-Exception,readOnly”);
properties.setProperty(“find*”, “PROPAGATION_REQUIRED,-Exception,readOnly”);
properties.setProperty(“query*”, “PROPAGATION_REQUIRED,-Exception,readOnly”);
properties.setProperty(“select*”, “PROPAGATION_REQUIRED,-Exception,readOnly”);
properties.setProperty(“list*”, “PROPAGATION_REQUIRED,-Exception,readOnly”);
properties.setProperty(“search*”, “PROPAGATION_REQUIRED,-Exception,readOnly”);
/*
* 关闭所有不符合以上命名的方法都开启事务
/
//properties.setProperty("", “PROPAGATION_REQUIRED,-Exception”);
TransactionInterceptor tsi = new TransactionInterceptor(transactionManager, properties);
return tsi;
}