com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException问题分析及个人案例分享

最新推荐文章于 2025-07-13 05:45:00 发布

原创最新推荐文章于 2025-07-13 05:45:00 发布 · 2.4k 阅读

0 ·

CC 4.0 BY-SA版权

个人笔记专栏收录该内容

96 篇文章

订阅专栏

个人案例:

异常:

{success=false, errMsg=addShop error:
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'owner_id' cannot be null
### 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: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'owner_id' cannot be null

; SQL []; Column 'owner_id' cannot be null; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'owner_id' cannot be null}

分析解决

实际情况为数据库有onwer_id值前端尚未设置通过session获取

在目前开发阶段仍然为手动设置只是设置的时候误删了设置owner_id 这个命令导致每次提交无owner_id信息显示错误