Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationExcepti

最新推荐文章于 2024-07-08 16:16:09 发布
最新推荐文章于 2024-07-08 16:16:09 发布
阅读量5.3w 收藏 1
点赞数 1
分类专栏： Spring Java MyBatis Exception 文章标签： Java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hc1017/article/details/79155745
版权
Java 同时被 3 个专栏收录
57 篇文章 0 订阅
订阅专栏
Spring
10 篇文章 0 订阅
订阅专栏
Exception
7 篇文章 0 订阅
订阅专栏

Type Exception Report

Message Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: 
### Error querying database.  Cause: java.sql.SQLException: Field 'scene_name' doesn't have a default value
### The error may exist in com/travel/dao/SceneDao.java (best guess)
### The error may involve com.travel.dao.SceneDao.insertScene-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO travel_scenes  (scene_level, city) VALUES (?, ?)
### Cause: java.sql.SQLException: Field 'scene_name' doesn't have a default value
; SQL []; Field 'scene_name' doesn't have a default value; nested exception is java.sql.SQLException: Field 'scene_name' doesn't have a default value
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Root Cause

org.springframework.dao.DataIntegrityViolationException: 
### Error querying database.  Cause: java.sql.SQLException: Field 'scene_name' doesn't have a default value
### The error may exist in com/travel/dao/SceneDao.java (best guess)
### The error may involve com.travel.dao.SceneDao.insertScene-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO travel_scenes  (scene_level, city) VALUES (?, ?)
### Cause: java.sql.SQLException: Field 'scene_name' doesn't have a default value
; SQL []; Field 'scene_name' doesn't have a default value; nested exception is java.sql.SQLException: Field 'scene_name' doesn't have a default value
	org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
	org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
	com.sun.proxy.$Proxy49.selectOne(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:167)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
	com.sun.proxy.$Proxy64.insertScene(Unknown Source)
	com.travel.service.impl.SceneServiceImpl.addScene(SceneServiceImpl.java:94)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:497)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
	com.sun.proxy.$Proxy65.addScene(Unknown Source)
	com.travel.controller.SceneController.addScene(SceneController.java:84)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:497)
	org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:111)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:806)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:729)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Root Cause

java.sql.SQLException: Field 'scene_name' doesn't have a default value
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
	com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307)
	com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:823)
	org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
	org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
	org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:497)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
	com.sun.proxy.$Proxy49.selectOne(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:167)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
	com.sun.proxy.$Proxy64.insertScene(Unknown Source)
	com.travel.service.impl.SceneServiceImpl.addScene(SceneServiceImpl.java:94)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:497)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
	com.sun.proxy.$Proxy65.addScene(Unknown Source)
	com.travel.controller.SceneController.addScene(SceneController.java:84)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:497)
	org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:111)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:806)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:729)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Note The full stack trace of the root cause is available in the server logs.

再一次由于本人的粗心，导致一个bug.......

在数据库中设置属性为not null，在此处本想判断非空，手残忘加"!"。。。

粗心啊！！！


hf寒沨
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
解决org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a];
FenGuo6Sheng的博客
11-05 9806
，在同一代码块内逻辑删除数据，在添加一条数据时，在同一事物内，出现异常 org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [uni_payuuid]; nested exception is org.hibernate.excep...
Request processing failed; nested exception is org.springframework.transaction.
luguangrui_520_123的博客
04-13 4663
Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLExcepti...
Request processing failed； nested exception is org.springframework.dao.DataIntegrityViolationExcept
m0_52298903的博客
04-10 4179
异常报告： Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolati
cn.hutool.core.io.IORuntimeException: SSLException: Received fatal alert: internal_error 记录一次报错
最新发布
bei__liang的博客
07-08 542
所以产生问题首先和对方对接充分，合理运用好工具，以影响最小的方式推进项目进度是比较重要的。客户接入时需要检查客户端是否支持 TLS1.1， TLS1.2，如果不支持，调用开放接口可能导致失败，于是首先排查tls。此时用hutool的方法调用其他外部系统没有问题，例如飞书API、抖音API都正常调用，唯独某外部系统m的接口报错。由于项目架构 升级JDK的影响较大，于是联系该对接公司m，经过排查，对方并没有遇到过jdk版本对接口的影响，业务场景：调用某外部系统m的API接口（ 本地成功调用，服务器端报错）
Request processing failed； nested exception is org.springframework.dao.DataIntegrityViolationExcepti
weixin_44337267的博客
02-01 1215
1.dao层设计有问题 2.pojo层类型不对 3.Application没有扫描dao层
Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageExce...
weixin_30723433的博客
03-31 1845
1、错误信息 Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: Multiple representations of the same entity 2、错误原因 因为试图给 某一个new 的Transient对...
idea报错-- Request processing failed； nested exception is org.springframework.jdbc.BadSqlGrammarExcep
alovelypeach的博客
07-28 2386
HTTP Status 500 – Internal Server Error Type 异常报告 消息 Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 描述 服务器遇到一个意外的情况，阻止它完成请求。 Exception org.springframework.web.util.NestedServletException: Request processing.
Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exc
Lele
03-06 2万+
HTTP Status 500 – Internal Server Error Type Exception Report Message Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.i...
消息：Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested
Z2Min_
05-10 5513
HTTP Status 500 – Internal Server Error Type 异常报告 消息 Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 描述 服务器遇到一个意外的情况，阻止它完成请求。 Exception org.spr
消息 Request processing failed; nested exception is org.springframework.dao.DuplicateKeyException:
01-28
nested exception is org.springframework.dao.DuplicateKeyException"异常的原因可能是在处理请求时发生了重复键异常。这可能是由于在数据库中插入了重复的键值对导致的。 为了解决这个问题，你可以采取以下步骤...
[Request processing failed； nested exception is org.springframework.dao.InvalidDataAccessApiUsageExc
waper97的博客
07-04 417
在项目中使用了Mybati-plus，同时使用了druid数据源，由于druid数据源的版本太低，不支持JDK8中的LocalDate、LocalTime、LocalDateTime等日期类型，所以解决方案就是下载新版本的druid依赖之前的版本是1.1.0太老了。
threw exception [Request processing failed； nested exception is org.springframework.data.redis.Redis
weixin_43700943的博客
09-16 5119
1.连接服务器查看redis情况发现该redis为从节点，没有写的权限。 2.info replication
错误提示：Request processing failed； nested exception is org.springframework.jdbc.BadSqlGrammarException:
热门推荐
qq_51515673的博客
04-12 4万+
错误提示： 类型 异常报告 消息 Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 描述 服务器遇到一个意外的情况，阻止它完成请求。 解决方案： 检查dao层xxxMapper.xml文件中的SQL语句是否有语法错误，特别是中英文标点问题 检查数据库的字段名是否和项目中的配置的设置的字段名（dao层xxxMapper.xml文件中的SQL语句字段名）.
异常：Request processing failed; nested exception is org.springframework.dao.TransientDataAccessResourc
qq_34677728的博客
08-22 7555
org.springframework.dao.TransientDataAccessResourceException 造成这个原因一般都是由于实体类和映射文件字段类型不一致，检查实体类和映射文件，修改过来即可!
错误之Request processing failed; nested exception is org.springframework.beans.factory.NoSuchBeanDefini...
weixin_34221773的博客
09-26 2123
HTTP Status 500 - Request processing failed; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'transactionManager' is defined type Exception report...
nested exception is org.springframework.dao.DataIntegrityViolationException问题的解决
dadan的博客
04-25 1万+
今天写程序出现了这个问题，HTTP Status 500 - Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested...
Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageExce
qq_34212546的博客
11-02 5517
记错：配置事物出现了错误，查看了网上的方法在web.xml中添加一些也无果，最后发现是，aop事物管理的路径配置写错了， abc.abcService..*.*(..))" id="mypointcut"/> 切记符合自己的包名类名。
【数据库连接报错】Request processing failed； nested exception is org.springframework.transaction.
weixin_45150516的博客
03-18 1万+
报错 打开下载的ssm文件报以下错误 Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException:Connections could not be acquired
Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:
09-20
Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException是一个异常报告，表示请求处理失败，并且发生了数据完整性违反的异常。这种异常通常是由于试图插入或更新数据库中的数据时，违反了数据表的约束条件所导致的。可能的原因包括插入了重复的数据、违反了唯一性约束、插入了无效的数据类型等。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值