请稍等 ...
×

采纳答案成功！

向帮助你的同学说点啥吧！感谢那些助人为乐的人

Column 'owner_id' cannot be null

输入


碰到一个奇怪的错误


org.springframework.dao.DataIntegrityViolationException: 

### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'owner_id' cannot be null

### The error may exist in file [E:\eclipse-workspace2\o2o\target\classes\mapper\ShopDao.xml]

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: INSERT INTO   tb_shop(owner_id,area_id,shop_category_id,shop_name,shop_desc,   shop_addr,phone,shop_img,priority,create_time,last_edit_time,   enable_status,advice)   VALUES   (?,?,?,   ?,?,?,?,   ?,?,?,?,   ?,?)

### Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'owner_id' cannot be null

; Column 'owner_id' cannot be null; nested exception is java.sql.SQLIntegrityConstraintViolationException: Column 'owner_id' 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:73)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)

at com.sun.proxy.$Proxy21.insert(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)

at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)

at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)

at com.sun.proxy.$Proxy25.insertShop(Unknown Source)

at com.imooc.o2o.dao.ShopDaoTest.testUpdateShop(ShopDaoTest.java:52)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)

at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)

at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)

at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)

at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)

at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)

at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)

at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)

at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)

at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)

at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)

at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)

at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)

at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)

at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)

at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)

at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)

at org.junit.runners.ParentRunner.run(ParentRunner.java:363)

at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)

at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89)

at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:541)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:763)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:463)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:209)

Caused by: java.sql.SQLIntegrityConstraintViolationException: Column 'owner_id' 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:955)

at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:372)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:67)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)

at com.sun.proxy.$Proxy27.execute(Unknown Source)

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:197)

at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)

... 37 more


提示说错误在ShopDao.xml：

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.imooc.o2o.dao.ShopDao">

<insert id="insertShop" useGeneratedKeys="true"

keyColumn="shop_id" keyProperty="shopId">


INSERT INTO

tb_shop(owner_id,area_id,shop_category_id,shop_name,shop_desc,

shop_addr,phone,shop_img,priority,create_time,last_edit_time,

enable_status,advice)

VALUES

(#{owner.userId},#{area.areaId},#{shopCategory.shopCategoryId},

#{shopName},#{shopDesc},#{shopAddr},#{phone},

#{shopImg},#{priority},#{createTime},#{lastEditTime},

#{enableStatus},#{advice})


</insert>

<update id="updateShop" parameterType = "com.imooc.o2o.entity.Shop">

update tb_shop

<set>

<if test="shopName != null">shop_name=#{shopName},</if>

<if test="shopDesc != null">shop_desc=#{shopDesc},</if>

<if test="shopAddr != null">shop_addr=#{shopAddr},</if>

<if test="phone != null">phone=#{phone},</if>

<if test="shopImg != null">shop_img=#{shopImg},</if>

<if test="priority != null">priority=#{priority},</if>

<if test="lastEditTime != null">last_edit_time=#{lastEditTime},</if>

<if test="enableStatus != null">enable_status=#{enableStatus},</if>

<if test="advice != null">advice=#{advice},</if>

<if test="area != null">area_id=#{area.areaId},</if>

<if test="shopCategory != null">shop_category_id=#{shopCategory.shopCategoryId}</if>

</set>

where shop_id=#{shopId}

</update>

</mapper>


里面这个owner_id我也没看明白错误在哪

正文
qq_i漫游音乐中倾听你我_0 2020-05-26 11:36:04
源自：4-2  Dao层之更新店铺
1901
收起

正在回答

1回答

翔仔 回答被采纳获得+3积分 2020-05-27 00:30:10

同学好，主要是你insert tb_shop信息的时候，插入的owner_id为空，但是你建立了owner_id和tb_person_info的主外键映射，所以需要有owner_id并且owner_id需要和tb_person_info的某个user_id相等。这样才能标识店铺是属于哪个店家的

0 回复 有任何疑惑可以回复我~
收起回答
取消 回复

相似问题

提示owner_id不能为空
1707 0 13
console不显示错误 在页面显示错误 看不到 求老师传授方法
518 0 2
django.db.utils.IntegrityError: (1048, "Column 'category_id' cannot be null")
2802 0 7
测试批量添加商品图片方法出错，提示Column 'img_addr' cannot be null
665 0 1
IntegrityError at /alipay/return/ (1048, "Column 'pay_status' cannot be null")
1234 0 7

登录后可查看更多问答，登录/注册

问题已解决，确定采纳
还有疑问，暂不采纳
Java双版本（SSM到SpringBoot）校园商铺全栈开发
  • 参与学习       5113    人
  • 解答问题       8144    个

SSM商铺V1.0，解决毕设痛点；SpringBoot商铺V2.0，满足工作刚需

了解课程

本课精华内容

问答 作业

无法进入DEBUG模式

1.9k 47

getshopbyid不能返回数据显示在前端

1.8k 41

停止访问网页问题已解决，但是扫码又出现scope不能为空的错误。。。。。

2.5k 40

request.getParameter()取出的值为空

1.8k 39

老师，操作台报错说类似这样的，数据库的字段和输入的数据库的数据类型不匹配，查了半天没发现有错啊

1.5k 37

查看更多本课问答
意见反馈 帮助中心 APP下载
官方微信