<insert id="insertSmsInfo">
insert into t_sms_info(business_key,task_name,task_id,task_info_id,received_user_id,received_user_name,received_number,template_title,content,book_time,send_time,send_type,status,response_info,send_count,send_priority,sms_sequence_id,msg_id,create_user,create_time,update_user,update_time,remark,statistics_id,condition_set_name,contact_group_name)
values
<foreach collection="smsInfos" item="smsInfo" separator=",">
(#{smsInfo.businessKey},#{smsInfo.taskName},#{smsInfo.taskId},#{smsInfo.taskInfoId},#{smsInfo.receivedUserId},#{smsInfo.receivedUserName},#{smsInfo.receivedNumber},#{smsInfo.templateTitle},#{smsInfo.content},#{smsInfo.bookTime},#{smsInfo.sendTime},#{smsInfo.sendType},#{smsInfo.status},#{smsInfo.responceInfo},#{smsInfo.sendCount},#{smsInfo.sendPriority},#{smsInfo.smsSequenceId},#{smsInfo.msgId},#{smsInfo.createUser},#{smsInfo.createTime},#{smsInfo.updateUser},#{smsInfo.updateTime},#{smsInfo.remark},#{smsInfo.statisticsId},#{smsInfo.conditionSetName},#{smsInfo.contactGroupName})
</foreach>
</insert>
com.huawei.opengauss.jdbc.util.PSQLException: [10.18.103.117:42078/10.18.103.101:30100] ERROR: null value in column "id" violates not-null constraint
详细：Failing row contains (null, null, null, 1871117981122347008, 9wu6bQQSLCnB93NBEHGPZA==, YfvTwEI7V8b17+RRYaXtEQ==, 20251110测试04, null, null, null, WAIT, null, 0, null, null, null, 1, 2025-11-10 17:43:48.051, 1, 2025-11-10 17:43:48.051, null, 20251110测试04, 1987818462717689856, 20251110测试04, null, null, 全选测试).
; [10.18.103.117:42078/10.18.103.101:30100] ERROR: null value in column "id" violates not-null constraint
详细：Failing row contains (null, null, null, 1871117981122347008, 9wu6bQQSLCnB93NBEHGPZA==, YfvTwEI7V8b17+RRYaXtEQ==, 20251110测试04, null, null, null, WAIT, null, 0, null, null, null, 1, 2025-11-10 17:43:48.051, 1, 2025-11-10 17:43:48.051, null, 20251110测试04, 1987818462717689856, 20251110测试04, null, null, 全选测试).; nested exception is com.huawei.opengauss.jdbc.util.PSQLException: [10.18.103.117:42078/10.18.103.101:30100] ERROR: null value in column "id" violates not-null constraint
详细：Failing row contains (null, null, null, 1871117981122347008, 9wu6bQQSLCnB93NBEHGPZA==, YfvTwEI7V8b17+RRYaXtEQ==, 20251110测试04, null, null, null, WAIT, null, 0, null, null, null, 1, 2025-11-10 17:43:48.051, 1, 2025-11-10 17:43:48.051, null, 20251110测试04, 1987818462717689856, 20251110测试04, null, null, 全选测试).
org.springframework.dao.DataIntegrityViolationException:
### Error updating database. Cause: com.huawei.opengauss.jdbc.util.PSQLException: [10.18.103.117:42078/10.18.103.101:30100] ERROR: null value in column "id" violates not-null constraint
详细：Failing row contains (null, null, null, 1871117981122347008, 9wu6bQQSLCnB93NBEHGPZA==, YfvTwEI7V8b17+RRYaXtEQ==, 20251110测试04, null, null, null, WAIT, null, 0, null, null, null, 1, 2025-11-10 17:43:48.051, 1, 2025-11-10 17:43:48.051, null, 20251110测试04, 1987818462717689856, 20251110测试04, null, null, 全选测试).
### The error may exist in cn/gov/sz/tyjr/sms/mapper/SmsInfoMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
最新发布
本文详细解析了nullvalueincolumn“id”violatesnot-nullconstraint错误的原因，通常由插入语句中的主键Id为空引起，并提供了检查和修复的方法。
扫一扫
1258
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
