记录一次解决springboot jpa 问题过程exception is org.springframework.transaction.UnexpectedRollbackException: T

最新推荐文章于 2024-05-09 14:10:12 发布
最新推荐文章于 2024-05-09 14:10:12 发布
阅读量529 收藏
点赞数
分类专栏： java springboot mysql 文章标签： 前端 apache java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/fly19920602/article/details/120914923
版权
java 同时被 3 个专栏收录
56 篇文章 0 订阅
订阅专栏
mysql
12 篇文章 1 订阅
订阅专栏
springboot
9 篇文章 0 订阅
订阅专栏

exception is org.springframework.transaction.UnexpectedRollbackException: Transaction silently rolled back because it has been marked as rollback-only

报错信息

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.UnexpectedRollbackException: Transaction silently rolled back because it has been marked as rollback-only
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.mb.framework.web.filter.RequestLogFilter.doFilter(RequestLogFilter.java:112)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.transaction.UnexpectedRollbackException: Transaction silently rolled back because it has been marked as rollback-only


at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)

报错信息比较多，首先找到Caused by报错信息如下

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)

Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'merchanten0_.merchant_uuid' in 'field list'

找到关键字merchant_uuid ，意思是找不到该字段

到数据库中找到如下

箭头所示位置有一个空格，一般通过工具直接设计表手动敲下的，去掉即可

 

请告诉他
关注
专栏目录
成功解决.orm.jpa.EntityManagerHolder cannot be cast to org.springframework.orm.hibernate5.SessionHolder
十三月的博客
12-14 366
偶然遇到一个报错：java.lang.ClassCastException: org.springframework.orm.jpa.EntityManagerHolder cannot be cast to org.springframework.orm.hibernate5.SessionHolder。不加@EnableAutoConfiguration(exclude = { HibernateJpaAutoConfiguration.class })的话，怎么都执行报错，加上就可以了。
JPA-org.springframework.ObjectOptimisticLockingFailureException
zym_1321的博客
10-14 989
最近日志出现一个报错 2021-09-09 22:20:21,483 ERROR [ConsumeMessageThread_16] [middle,,,] [CarAssignFailedHandle.handle] [CarAssignFailedHandle.java:58] - Object of class [com.trip.engine.bean.OrderEntity] with identifier [356202191582900224]: optimistic locking fa
Spring事务回滚报错：org.springframework.transaction.UnexpectedRollbackException
⭐【World of Yeeking】⭐
05-08 680
Spring事务回滚报错：org.springframework.transaction.UnexpectedRollbackException
spring事务管理UnexpectedRollbackException
yidianfengfan的专栏
12-17 197
在使用spring事务管理时，程序报如下： [code="java"]org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only[/code] 程序的代码为： [code="java"] s...
Spring事务报错： org.springframework.transaction.UnexpectedRollbackException
u012045045的博客
07-04 1万+
异常信息：出现了不可预知的回滚异常，因为事务已经被标志位只能回滚，所以事务回滚了。 org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only at org.springframework.transaction.support.AbstractPlatformTransactionManager.com.
使用Spring data Jpa 时遇到 java.lang.ClassNotFoundException: org.springframework.core.ReactiveTypeDescrip...
dianyanxi7965的博客
01-16 654
背景 　　原本项目是使用SSM+Maven进行开发，而后想同时使用Jpa（即mybatis和jpa混用），配置好相关文件后，使用Junit做测试时，出现以下错误。 主要： ERROR - Caught exception while allowing TestExecutionListener [org.springframework.test.context.support.De...
Caused by: java.lang.ClassNotFoundException: org.springframework.data.repository.config.BootstrapMod...
weixin_30444105的博客
07-12 955
1、起因，启动SpringBoot2.0的时候报了这个错误。说找不到类，咱也是刚学SpringBoot2.0，咱也不懂，咱也不知道问谁，研究一翻，找不到原因就百度了。 参考链接：https://blog.csdn.net/sswqzx/article/details/87432287 报错如下所示： 1 "C:\Program Files\Java\jdk1.8.0_161\bin\...
记录一次很坑的报错----jpa中@Query注解传参是对象时，报错org.springframework.dao.InvalidDataAccessApiUsageException:
PiaoYoung's blog of CSDN
11-16 1819
2020-07-14 21:21:23.423 INFO 17292 --- [erListUpdater-0] c.netflix.config.ChainedDynamicProperty : Flipping property: YSS-BASE-BILLOWS.ribbon.ActiveConnectionsLimit to use NEXT property: niws.loadbalancer.availabilityFilteringRule.activeConnectionsLimi..
org.springframework.transaction.UnexpectedRollbackException意外回滚解决方法，亲测有效，已解决，嘿嘿嘿
PythonAigc的博客
05-09 2072
`org.springframework.transaction.UnexpectedRollbackException` 异常通常发生在 Spring 框架管理的事务中，当某个事务预期会被提交，但实际上却发生了回滚时。这通常是由于以下原因之一导致的： ### 问题分析 1. **事务管理配置**：检查是否所有涉及事务的组件（如 `@Service`、`@Repository` 等）都已正确配置以支持事务管理。 2. **事务传播行为**：确认事务的传播行为（propagation behavior）是
Spring 事务异常 UnexpectedRollbackException
howeres的博客
06-25 759
Spring 框架的默认事务传播方式是 PROPAGATION_REQUIRED (内层事务加入外层事务中)在内层事务因异常结束时, Spring 会把事务标记为“rollback-only”。这时如果外层事务 catch 捕捉了异常 e, 那么, 直到外层事务结束.Spring 发现事务已经被标记为 “rollback-only”, 外层方法却正常执行成功, 这时 Spring 就会抛出。
解决org.springframework.transaction.UnexpectedRollbackException: Transaction silently rolled back beca
念兮为美
03-02 8416
解决org.springframework.transaction.UnexpectedRollbackException: Transaction silently rolled back because it has been marked as rollback-only的问题，并通过该错误来分析来分析spring boot的事务机制。
完美解决org.springframework.transaction.UnexpectedRollbackException
热门推荐
05-14 6万+
该异常通常在以下情况下抛出： 如果一个方法被标记为 @Transactional，并且发生了未被捕获的 RuntimeException 或其他不受检查的异常，事务会自动回滚。如果不希望方法回滚，可以在方法上使用 @Transactional(noRollbackFor = Exception.class) 注解来指定不回滚的异常。 如果在事务方法中手动调用了 setRollbackOnly() 方法来标记事务为回滚状态，那么在事务结束时就会抛出 UnexpectedRollbackException
Spring事务：UnexpectedRollbackException:
sdonoman11的博客
05-13 1783
java.lang.reflect.InvocationTargetException InvocationTargetException是一种包装由调用方法或构造方法所抛出异常的受查异常。这个异常并不是Eclipse插件开发特有的，而是标准JDK中的，它定义在 java.lang.reflect包下。在进行Java开发的时候很少会接触到这个异常，不过在进行Eclipse插件开发中则不同，很多API都声明抛出此类异常，因此必须对此异常进行处理。 A→B→C 产生原因：举例说明 下面ABC代表三个类..
已解决org.springframework.transaction.UnexpectedRollbackException意外的回滚异常的正确解决方法，亲测有效！！！
小明的Java问道之路
02-28 2320
已解决org.springframework.transaction.UnexpectedRollbackException意外的回滚异常的正确解决方法，亲测有效！！！
org.springframework.transaction.UnexpectedRollbackException 解决
xixingzhe2的博客
05-20 2270
1、异常 org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransact
spring事务之UnexpectedRollbackException异常
weixin_46020146的博客
06-20 87
spring事务之UnexpectedRollbackException异常
JAVA08_org.springframework.transaction.UnexpectedRollbackException
所得皆惊喜
06-17 268
org.springframework.transaction.UnexpectedRollbackException
Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarExceptio
最新发布
06-26
nested exception is org.springframework.jdbc.BadSqlGrammarException" 这样的错误，它通常发生在使用Spring框架处理HTTP请求时，数据库操作（如SQL查询）出现了语法错误。Spring JDBC的`BadSqlGrammarException`...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值