Caused by: java.sql.SQLException: Column ‘某个字段‘ cannot be null

最新推荐文章于 2024-01-24 11:21:41 发布

想养一只！

最新推荐文章于 2024-01-24 11:21:41 发布

阅读量3.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： mybatis

本文链接：https://blog.csdn.net/weixin_45151960/article/details/109002109

完整报错提示：

2020-10-10 18:14:00.139  INFO 13760 --- [nio-8082-exec-9] biz.xcj.conf.db.DataSourceAspect         : 切换至master!
2020-10-10 18:14:00.170 DEBUG 13760 --- [nio-8082-exec-9] b.x.m.C.insertComparison                 : ==>  Preparing: insert into comparison_manager (comparison_name, comparison_id_card, comparison_witness_score, comparison_entrance_score, comparison_witness_result, comparison_entrance_result) values (?,?,?, ?,?,?) 
2020-10-10 18:14:00.176 DEBUG 13760 --- [nio-8082-exec-9] b.x.m.C.insertComparison                 : ==> Parameters: 李四(String), 12547865125486612(String), 95.0(Double), 85.0(Double), true(Boolean), null
org.springframework.dao.DataIntegrityViolationException: 
### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=41) Column 'comparison_entrance_result' cannot be null
### The error may exist in biz/xcj/mapper/ComparisonManagerDao.xml
### The error may involve biz.xcj.mapper.ComparisonManagerDao.insertComparison-Inline
### The error occurred while setting parameters
### SQL: insert into comparison_manager (comparison_name, comparison_id_card,          comparison_witness_score, comparison_entrance_score,          comparison_witness_result, comparison_entrance_result)         values (?,?,?,         ?,?,?)
### Cause: java.sql.SQLIntegrityConstraintViolationException: (conn=41) Column 'comparison_entrance_result' cannot be null
; (conn=41) Column 'comparison_entrance_result' cannot be null; nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=41) Column 'comparison_entrance_result' cannot be null
	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:87)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	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:440)
	at com.sun.proxy.$Proxy141.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
	at com.sun.proxy.$Proxy185.insertComparison(Unknown Source)
	at biz.xcj.service.ComparisonManagerService.insertComparison(ComparisonManagerService.java:23)
	at biz.xcj.service.ComparisonManagerService$$FastClassBySpringCGLIB$$8bc7c514.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)