如何在mybatis和postgresql中更新记录忽略id

Question

现在我用mybatis更新PostgreSQL 13记录，我想用user id更新用户表中的apple purchase prouct id，这是我的代码：

Users users = new Users();
users.setId(payTransactionRecord.getUserId());
users.setAppleIapProductId(productId);

我给出了用户实体id和产品id，通过使用用户id更新产品id。这是使用mybatis的更新执行代码：

public int updateByPrimaryKey(Users user) {
        UsersExample example = new UsersExample();
        UsersExample.Criteria criteria = example.createCriteria();
        criteria.andIdEqualTo(user.getId());
        return userMapper.updateByExampleSelective(user,example);
    }

但是mybatis遗传sql会导致这样的错误：

Caused by: org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: column "id" can only be updated to DEFAULT
  Detail: Column "id" is an identity column defined as GENERATED ALWAYS.
### The error may exist in class path resource [mybatis/mapper/dolphin/UsersMapper.xml]
### The error may involve com.dolphin.soa.post.dao.UsersMapper.updateByExampleSelective-Inline
### The error occurred while setting parameters
### SQL: UPDATE users SET id = ?, apple_iap_product_id = ? WHERE (id = ?)
### Cause: org.postgresql.util.PSQLException: ERROR: column "id" can only be updated to DEFAULT
  Detail: Column "id" is an identity column defined as GENERATED ALWAYS.
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "id" can only be updated to DEFAULT
  Detail: Column "id" is an identity column defined as GENERATED ALWAYS.

我该怎么做才能修好它？

Answer 1

SQL语句定义错误。您声明，您只想更新用户条目的苹果购买产品ID。但是在该语句中，它还试图更新用户条目本身的ID。错误消息指出总是生成其值，因此不允许手动更新users ID列中的值。尝试从SET部分删除ID，只在WHERE部分应用它。