Cause: java.sql.SQLException: Field ‘pay_no‘ doesn‘t have a default value

@DeleteMapping("/consumer/pay/del/{id}")
    public ResultData delPay(@PathVariable("id") Integer id) {
        restTemplate.delete(PaymentSrv_URL + "/pay/del/" + id);
        return ResultData.success("删除成功!");
    }

@PutMapping("/consumer/pay/update")
    public ResultData updateOrder(@RequestBody PayDTO payDTO) {
        HttpHeaders headers = new HttpHeaders();
        headers.setContentType(MediaType.APPLICATION_JSON);
        return restTemplate.exchange(PaymentSrv_URL + "/pay/update", HttpMethod.PUT, new HttpEntity<>(payDTO, headers), ResultData.class).getBody();
    }


Pay(id=null, payNo=null, orderNo=null, userId=null, amount=null, deleted=null, createTime=null, updateTime=null)
----come in GlobalExceptionHandler
2024-05-18T09:53:24.162+08:00 ERROR 10624 --- [cloud-payment-service] [nio-8001-exec-6] c.a.cloud.exp.GlobalExceptionHandler     : 全局异常信息exception:
### Error updating database.  Cause: java.sql.SQLException: Field 'pay_no' doesn't have a default value
### The error may exist in com/atguigu/cloud/mapper/PayMapper.java (best guess)
### The error may involve com.atguigu.cloud.mapper.PayMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO t_pay  ( id ) VALUES( ? )
### Cause: java.sql.SQLException: Field 'pay_no' doesn't have a default value
; Field 'pay_no' doesn't have a default value

注意请求方法是否匹配!方法参数里是否带上了请求体@RequestBody
  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值