@Transactional(readOnly = false)

最新推荐文章于 2023-11-20 10:18:37 发布
最新推荐文章于 2023-11-20 10:18:37 发布
阅读量1k 收藏
点赞数
分类专栏： 工作Bug jeesite
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ASZJBGD/article/details/86583119
版权 
org.springframework.dao.TransientDataAccessResourceException: 
### Error updating database.  Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: update customer_order_doc   set customer_card_id = null   where id = ?
### Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
; SQL []; 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
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:108)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:399)
	at com.sun.proxy.$Proxy57.update(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:269)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:54)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
	at com.sun.proxy.$Proxy95.deleteCard(Unknown Source)
	at com.thinkgem.jeesite.modules.lanstech.his.service.CustomerOrderDocBusinessService.deleteCard(CustomerOrderDocBusinessService.java:225)
	at com.thinkgem.jeesite.modules.lanstech.his.service.CustomerOrderDocBusinessService$$FastClassBySpringCGLIB$$fffcc622.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:718)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
	at com.thinkgem.jeesite.modules.lanstech.interceptor.GlobalInterceptor.intercept(GlobalInterceptor.java:45)
	at sun.reflect.GeneratedMethodAccessor242.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
	at com.thinkgem.jeesite.modules.lanstech.his.service.CustomerOrderDocBusinessService$$EnhancerBySpringCGLIB$$f05f0085.deleteCard(<generated>)
	at com.thinkgem.jeesite.modules.lanstech.his.service.CustomerOrderDocBusinessService$$FastClassBySpringCGLIB$$fffcc622.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:718)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
	at com.thinkgem.jeesite.modules.lanstech.his.service.CustomerOrderDocBusinessService$$EnhancerBySpringCGLIB$$bf94c855.deleteCard(<generated>)
	at com.thinkgem.jeesite.modules.lanstech.his.web.CustomerInterrogationController.deleteFlag(CustomerInterrogationController.java:1022)
	at com.thinkgem.jeesite.modules.lanstech.his.web.CustomerInterrogationController$$FastClassBySpringCGLIB$$b4510299.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:649)
	at com.thinkgem.jeesite.modules.lanstech.his.web.CustomerInterrogationController$$EnhancerBySpringCGLIB$$c914a8d9.deleteFlag(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:775)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:965)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:856)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:841)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1236)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)
	at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:62)
	at com.sun.proxy.$Proxy272.execute(Unknown Source)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
	at sun.reflect.GeneratedMethodAccessor305.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
	at com.sun.proxy.$Proxy270.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
	at sun.reflect.GeneratedMethodAccessor380.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)
	... 102 more
修改的方法上忘了加@Transactional(readOnly = false)
飞来的贼
关注
专栏目录
@Transactional-隔离级别-二级缓存的扯谈
PeterWei 光波
04-07 2998
引子今天下班后，以前同事小胖问我Spring  Service类中的注解@Transactional readOnly=true的作用。做为他眼中的高人，我自然要装下A-C。居然想都没有想就说是注解事务控制，然后给他扯了一通数据库的隔离级别，什么read uncommit之类的,说readOnly是隔离级别最低的，在spring查询方法里用，性能最高。 ps:之前的项目多数基于xml，亲自用annotation的机会很少，都是小弟们在实战。 示例：Java代码  @Component("channelSer
junit 测试保存 未加@Modifying，@Transactional(readOnly=false)报错
g454005696的博客
03-22 1624
修改 添加删除都需要加上事务，按业务事务也需要加上    未加Modifying @Query("update Employee e set e.email=:email where e.id=:id") public int updateEmailByID(@Param("id")Long id,@Param("email")String email); org.springfram
@Transactional的readOnly、timeout
weixin_30367543的博客
08-27 487
1、@Transactional的readOnly在使用@Transactional注解的时候，有一个属性是readOnly，默认值是falsereadOnly的意思就是当前的方法是只读的，也就是说当前的方法中没有需要处理事务（insert,update,delete）的操作。则可以加上readOnly=true使用它的好处是Spring会把你优化这方法，使用了readOnly=true，也就是使...
关于@Transactional(readOnly = false)注解，数据新增修改Connection is read-only
sgj110的博客
04-23 3625
关于@Transactional(readOnly = false)注解，数据新增修改Connection is read-only 有时你新增或修改会报Connection is read-only Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not...
关于@Transactional(readonly = false)注解不起作用的可能性
weixin_43832166的博客
11-21 3455
readOnly=true表明所注解的方法或类只是读取数据。 readOnly=false表明所注解的方法或类是增加，删除，修改数据。 通常添加事务回滚注解都是在service层中，可以在类上，也可以在方法上： 注意点： service类标签(一般不建议在接口上)上添加@Transactional，可以将整个类纳入spring事务管理，在每个业务方法执行时都会开启一个事务，不过这些事务采用相同...
@Transactional(readOnly = false)事务
博客
10-23 2522
@Transactional(readOnly = false) 和 @Transactional(readOnly = true)
03-08
@Transactional(readOnly = false)和@Transactional(readOnly = true)是Spring框架中的注解，用于声明事务的属性。 @Transactional(readOnly = false)表示该方法需要在一个事务中执行，并且该事务是可读写的。也...
@Transactional(readOnly = false)的优缺点
07-23
@Transactional(readOnly = false) 是一个用于标记方法或类的注解，用于控制事务的行为它有以下优点和缺点： 优点： 1. 提供了对事务的编程式控制：通过 @Transactional(readOnly = false)，可以明确地设置方法或类...
@Transactional(readOnly=false) readOnly变红
最新发布
08-02
`@Transactional(readOnly=false)` 是Spring框架中的一个事务管理注解，主要用于指定在一个方法执行期间是否开启只读事务（ReadOnly）。当`readOnly`属性设为`false`时，意味着该事务将允许对数据进行修改操作，比如...
@Transactional(readOnly = false)和try catch
cxl964的博客
04-12 295
在方法上加上注解 @Transactional(readOnly = false) 可以在抛异常的时候回滚 但如果需要用上 try catch 那么异常会被捕获 这时候事务不能起到作用 所以需要在catch中捕获异常后手动回滚 TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); ...
spring 事务管理之只读事务@Transactional(readOnly = true)
热门推荐
南国樱花祭
08-01 1万+
我们可以使用 @Transactional(readOnly = true) 来设置只读事务 在将事务设置成只读后，当前只读事务就不能进行写的操作，否则报错。如下 Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed; 需不需要在只有查询的方法上加上@Transactional注解？ 需要分为两种情况来看 若一个事务里只发出一条s
spring事务@Transactional(readOnly = true)及隔离级别实验
u010772230的专栏
01-19 3731
先写结论：第一：@Transactional(readOnly = true) 1.那么方法里面，必须是读的操作，当有写的操作的时候会报错提示。 2.读到的数据，从进入方法开始，以后即使其他客户端修改了数据，读到的数据还是进入方法那刻的数据。即不会去读取更新的数据。 第二：不指定事务，即不加@Transactional 1.那么读到的数据，都是数据库最新的数据。 第三：@Transactional...
@Transactional(readOnly=true) 真的是提高性能的灵丹妙药吗？
犬小哈
11-18 282
来源：medium.com 丛林（Java知音）???? 欢迎加入小哈的星球，你将获得:专属的项目实战/ Java 学习路线 / 一对一提问 / 学习打卡/ 赠书福利目前, 正在星球内部带小伙伴做第一个项目：全栈前后端分离博客，手摸手，后端 + 前端全栈开发，从 0 到 1 讲解每个功能点开发步骤，1v1 答疑，直到项目上线。目前已更新了151小节，累计23w+字，讲解图：972张，还在持续爆肝中...
只读事务（@Transactional(readOnly = true)）的一些概念（装）
weixin_42410730的博客
12-26 1551
https://www.cnblogs.com/jpfss/p/9151797.html（感谢）
Connection is read-only @Transactional(readOnly = false)不管用
m0_51892907的博客
07-04 744
Connection is read-only @Transactional(readOnly = false)不管用
面试官：@Transactional(readOnly=true) 有什么用？还有谁不会？！
Java技术栈，分享最主流的Java技术
11-20 618
在Session接口中，通过将readOnly属性设置为true，将不会对只读实体进行脏检查，也不会维护持久状态的快照。因此，当服务层的方法有需要大量时间的逻辑时要小心，因为它可以长时间持有数据库连接，这可能会导致数据库连接匮乏。当您需要将只读查询仅仅作为一个事务执行时，请毫不犹豫选择的在服务层的方法中使用。让我们看看用于事务管理器的。中，它是 Jpa Respitory 的默认实现，在类的顶部有。，如果你的服务层的方法中有大量其他逻辑方法时，就要做取舍了！在服务层的方法中直到服务层的方法结束才释放连接。
spring事务注解@Transactional不生效、不回滚原因
r939126607的博客
06-04 2240
一般情况下在方法上直接添加@Transactional即可，但是极有可能会达不到我们想要的效果，这时就需要添加相应的参数，参数如下。 @Transactional(propagation=Propagation.REQUIRED) //控制事务传播。默认是Propagation.REQUIRED @Transactional(isolation=Isolation.DEFA...
设置readonly变成了false为什么还是不能编辑呢
肖肖肖丽珠的博客
12-24 3985
<input type="text" :readonly="isreadonly" /> 我是这样写的通过一个变量来确定是是否添加readonly属性。 computed:{ isreadonly(){ return this.$route.query.from=='detail'?'true':'false'; } }, 但是在true的时候的确是变成了不可编辑的，但是false的时候...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值