Cause: java.sql.SQLIntegrityConstraintViolationException: Column ‘name‘ cannot be null

最新推荐文章于 2024-06-22 11:32:51 发布
最新推荐文章于 2024-06-22 11:32:51 发布
阅读量5.3k 收藏 4
点赞数 3
文章标签： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_54163080/article/details/114635416
版权

Cause: java.sql.SQLIntegrityConstraintViolationException: Column ‘name’ cannot be null

Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'name' cannot be null
 The error may exist in file [D:\DevelopSoftware\id\ls-add\ls\ls-web\target\classes\mappers\MerchMapper.xml]
 The error may involve defaultParameterMap
 The error occurred while setting parameters
 SQL: insert into merch         (name,code,factory,packaging,price,stock)         values             (?,?,?,?,?,?)
 Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'name' cannot be null
; Column 'name' cannot be null; nested exception is java.sql.SQLIntegrityConstraintViolationException: Column 'name' cannot be null] with root cause

java.sql.SQLIntegrityConstraintViolationException: Column 'name' cannot be null
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) ~[mysql-connector-java-8.0.12.jar:8.0.12]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.12.jar:8.0.12]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.12.jar:8.0.12]
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:975) ~[mysql-connector-java-8.0.12.jar:8.0.12]
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:392) ~[mysql-connector-java-8.0.12.jar:8.0.12]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.5.jar:na]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) ~[mybatis-3.5.6.jar:3.5.6]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_251]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_251]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_251]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_251]
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) ~[mybatis-3.5.6.jar:3.5.6]
	at com.sun.proxy.$Proxy85.update(Unknown Source) ~[na:na]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184) ~[mybatis-3.5.6.jar:3.5.6]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_251]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_251]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_251]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_251]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.6.jar:2.0.6]
	at com.sun.proxy.$Proxy60.insert(Unknown Source) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) ~[mybatis-spring-2.0.6.jar:2.0.6]
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152) ~[mybatis-3.5.6.jar:3.5.6]
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85) ~[mybatis-3.5.6.jar:3.5.6]
	at com.sun.proxy.$Proxy61.insertSelective(Unknown Source) ~[na:na]
	at com.cy.service.MerchServiceImpl.saveAll(MerchServiceImpl.java:59) ~[classes/:na]
	at com.cy.controller.MerchController.saveMerch(MerchController.java:103) ~[classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_251]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_251]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_251]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_251]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197) ~[spring-web-5.3.4.jar:5.3.4]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141) ~[spring-web-5.3.4.jar:5.3.4]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) ~[spring-webmvc-5.3.4.jar:5.3.4]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:894) ~[spring-webmvc-5.3.4.jar:5.3.4]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.4.jar:5.3.4]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.4.jar:5.3.4]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1060) ~[spring-webmvc-5.3.4.jar:5.3.4]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:962) ~[spring-webmvc-5.3.4.jar:5.3.4]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.4.jar:5.3.4]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.3.4.jar:5.3.4]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) ~[tomcat-embed-core-9.0.43.jar:4.0.FR]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.4.jar:5.3.4]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.43.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.3.4.jar:5.3.4]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.4.jar:5.3.4]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.3.4.jar:5.3.4]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.4.jar:5.3.4]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.4.jar:5.3.4]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.4.jar:5.3.4]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_251]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_251]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.43.jar:9.0.43]
	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_251]

我的原因是因为 控制层没有拿到客户端提交的数据
但是为什么没有拿到呢？
所以，我向上溯源，发现我在导入的控制层，自己手写set，可以进行导入遍历到行数，但是遍历不到每列，于是在POI中发现了自己的错误，改完成功运行，顺利测通。
十分感谢 链接: https://www.cnblogs.com/Devin-d/p/13048883.html.
给我提供的帮助。

不舍，不得
关注
  • 3
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 4
    评论
Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row:
12-14
网上查了很多，都说不满足主键约束啥的等等都没解决，我的问题主要是删除记录的时候删不了，最后发现是中间表的外键默认删除时是RESTRICT，   当取值为No Action或者Restrict时，则当在父表（即外键的来源表）中删除对应记录时，首先检查该记录是否有对应外键，如果有则不允许删除。   当取值为Cascade时，则当在父表（即外键的来源表）中删除对应记录时，首先检查该记录是否有对应外键，如果有则也删除外键在子表（即包含外键的表）中的记录。   当取值为Set Null时，则当在父表（即外键的来源表）中删除对应记录时，首先检查该记录是否有对应外键，如果有则设置子表中该外键值为null（不
Caused by: java.sql.SQLException: Field 'create_time' doesn't have a default value
tfy1332的专栏
03-10 5836
Caused by: java.sql.SQLException: Field 'create_time' doesn't have a default value Hibernate: insert into operator_org_logistics (operator_id, org_logistics_id) values (?, ?) 2016-03-10 20:20:05
Column ‘列名‘ cannot be null —— servlet 500常见错误
最新发布
weixin_64208498的博客
06-22 588
servlet常见错误之500
报错：java.sql.SQLException: Field ‘create_time‘ doesn‘t have a default value解决办法
m0_59281987的博客
06-15 1812
解决办法测试。
Field ‘create_time‘ doesn‘t have a default value问题解决
will59634788的博客
05-15 1177
学习瑞吉外卖时，实体类的属性没有设置自动填充策略，就会报字段不存在的错误，页面也会报错500。
java.sql.SQLIntegrityConstraintViolationException: Column ‘username‘ cannot be null
weixin_42407684的博客
09-02 7584
错误类型 java.sql.SQLIntegrityConstraintViolationException: Column ‘username’ cannot be null Caused by: java.sql.SQLIntegrityConstraintViolationException: Column 'username' cannot be null at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.ja
Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'name' cannot be null
08-20
这个错误是由于在数据库中有一个名为'name'的列被设置为不允许为空，但在执行 SQL 语句时，该列的值未被正确地赋值或传递为 null 所引起的。你需要确保在插入或更新数据时，该列的值不为空。可能的解决办法包括： - ...
java 主键id Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'id' cannot be null
07-20
这个错误是由于插入数据时，主键id的值为null导致的。你可以通过以下几种方式解决这个问题： 1. 确保在插入数据之前，为每个用户生成一个唯一的id值。可以使用UUID类生成一个唯一的id，示例代码如下： ```java ...
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'goods_name' cannot be null
11-09
个错误提示表明在更新数据库时，goods_name列的值为空，而该列被设置为不允许为空。这可能是由于代码中没有正确设置goods_name的值或者传递给数据库的参数中缺少goods_name导致的。需要检查代码中是否正确设置了...
\n### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'create_name' cannot be null\
10-31
根据提供的引用内容，这个错误是由于在更新数据库时，create_name这一列被设置为了null，而这一列不允许为空，所以导致了SQLIntegrityConstraintViolationException异常。解决方案是在更新时确保create_name这一列有...
java.sql.SQLIntegrityConstraintViolationException: Column 'USER_NAME' cannot be null
08-17
- *3* [Cause: java.sql.SQLIntegrityConstraintViolationException: Column ‘name‘ cannot be null](https://blog.csdn.net/m0_54163080/article/details/114635416)[target="_blank" data-report-click={"spm":...
学习hadoop遇到的问题(Sqoop 2,遇到Field 'CREATE_TIME' doesn't have a default value)
小马哥的博客
01-04 4685
在MySQL 5.0.2之后对数据输入进行了强制性的加严处理，并且保留了以前的MySQL对非法或不当值并不严厉的行为，MySQL默认是对数据进行加严处理，但你可以为不良值选择更传统的处理方法，从而使得服务器能够拒绝并放弃出现不良值的语句。   MYSQL安装目录--->搜索打开my.ini，查找  sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE...
Cause: java.sql.SQLIntegrityConstraintViolationException: Column ‘businessName‘ cannot be null
Silly011的博客
08-10 2248
Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Column ‘businessName’ cannot be null The error may exist in OpBusinessMapper.xml The error may involve BusinessMapper.insertBusi-Inline The error occurred while setting par
瑞吉外卖 报错：java.sql.SQLException: Field ‘create_time‘ doesn‘t have a default value解决办法
2302_76795243的博客
01-23 633
报错原因是自动注入的时间未格式化 导致数据库类型不匹配。这几天在学习瑞吉外面报了这个错,我加了这个注解还是在报错。
Cause: java.sql.SQLIntegrityConstraintViolationException: Column ‘xxx‘ cannot be null
m0_64284147的博客
11-15 1万+
1、报错信息 2、定位报错的范围 ### SQL: insert into business (businessId,password,salt,businessName,businessAddress,businessExplain,starPrice,deliveryPrice) values (?,?,?,?,?,?,?,?) 3、从上述已知错误存在于SQL的insert into操作里，然后跳转到BuseineeMapper.xml里 4
# Error updating database. Cause: java.sql.SQLException: Field ‘create_time‘ doesn‘t have a default
weixin_53383146的博客
07-24 227
对应数据库表中给它设置默认值就好。
java column 设置非空,Column ‘列名’ cannot be null 问题解决
weixin_36205186的博客
03-13 5492
这个其实就是小错误，都怪自己的马虎。它这里提示字段不能为空**，是因为数据库里加了非null约束。**自己明明添加了数据，却没有进到数据库中。我就检查了一下代码。我这个是添加数据的方法，相信你们都能看出来吧，是的，没有返回值！！！虽然很简单，但是这个错误我觉得很常犯。写代码一定要找头脑清醒的时候写，不然只会给自己添麻烦！org.springframework.dao.DataIntegrityVi...
SQLIntegrityConstraintViolationException报错
热门推荐
weixin_46009444的博客
06-05 1万+
java.sql.SQLIntegrityConstraintViolationException: Column ‘XXX’ cannot be null 今天在写项目的时候出现500报错,提示我出现意外情况,我仔细检查输出了前台页面的数据以及controller中得到的数据,都能得到值,然后我去找我的mapper接口 结果发现 @Insert("insert into wms_customer (customer_name,customer_person,customer_tel,customer_e
【报错】MySQLIntegrityConstraintViolationException:Column cannot be null
陶洲川的博客
06-09 7699
今天报了一个新的错，原因是实体类中一个字段没有写进映射中: 就是图中注销的那一个，这个是后来错误重现时候注销的； console中报的错： 把没有写进mapper.xml文件的deleted属性和deleted表的列的映射写进去就好了；
评论 4
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值