问题描述

{roles, typeHandler=com.yexuejc.guansc.core.mybatis.handler.JsonTypeHandler}::jsonb, 这种带::jsonb的怎么组装

重现步骤 @TableField(el = "roles, typeHandler=com.yexuejc.guansc.core.mybatis.handler.JsonTypeHandler") private List roles;

报错信息 SQL: INSERT INTO consumer ( consumer_id, "mobile", "is_enable", "is_non_expire", "is_non_lock", "nickname", "is_layer", "head", "roles", "pay_pwd" ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) Cause: org.postgresql.util.PSQLException: ERROR: column "roles" is of type jsonb but expression is of type character varying 建议：You will need to rewrite or cast the expression. 位置：232 ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "roles" is of type jsonb but expression is of type character varying 建议：You will need to rewrite or cast the expression.

Comment From: qmdx

如果解决确定问题欢迎反馈 or pr

Comment From: myskybeyond

how to solve it?

Comment From: MohnSnow

how to solve it?