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

最新推荐文章于 2024-07-18 09:01:28 发布

星~闪耀

最新推荐文章于 2024-07-18 09:01:28 发布

阅读量2.2k

点赞数

分类专栏： Java中的错误 mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/Silly011/article/details/119580160

版权

mybatis 同时被 2 个专栏收录

20 篇文章 0 订阅

订阅专栏

Java中的错误

10 篇文章 0 订阅

订阅专栏

在尝试更新数据库时遇到了一个问题，导致插入操作失败。错误信息指出'businessName'列不能为null。此问题可能与OpBusinessMapper.xml中的SQL映射有关，具体发生在设置参数时。已提供完整的堆栈跟踪以供进一步分析。

摘要由CSDN通过智能技术生成

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 parameters

SQL: insert into business(businessName, businessAddress, businessExplain, businessImg, orderTypeId, starPrice, deliveryPrice, remarks, password) values (?,?,?,?,?,?,?,?,?)

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

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:180)
at TestBusiness.main(TestBusiness.java:43)

Caused by: java.sql.SQLIntegrityConstraintViolationException: Column ‘businessName’ cannot be null
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
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:970)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:387)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
… 3 more

Process finished with exit code 1

在这里插入图片描述