Column 'view_count' cannot be null

Question

Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Column ‘view_count’ cannot be null

The error may exist in file [D:\zhishi\target\classes\mapper\EbookSnapshotMapperCust.xml]

The error may involve defaultParameterMap

The error occurred while setting parameters

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

在Docservice中 doc.setViewCount(0);
doc.setVoteCount(0);依旧报错 。 求解决

Answer 1

rarukuchaser 2023-11-17 14:13:31

不用那么麻烦的，sql改写成：

update doc set view_count = ifnull(view_count, 0) + 1 where id = #{id}

就好

Answer 2

甲蛙 2021-11-29 16:05:13

ebook表也有view_count字段，创建ebook时也setViewCount(0)试试