Mybatis操作PgSQL的JSON类型(org.postgresql.util.PSQLException: ERROR: column "destination" is of type json but expression is of type character varying) JSON问题

Mybatis操作PgSQL的JSON类型


Mybatis在保存json类型字段时报错：

SQL: UPDATE viewing_angle  SET name=?, destination=?, orientation=?  WHERE id=?
### Cause: org.postgresql.util.PSQLException: ERROR: column "destination" is of type json but expression is of type character varying
  建议：You will need to rewrite or cast the expression.
  位置：48
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "destination" is of type json but expression is of type character varying
  建议：You will need to rewrite or cast the expression.


解决方法：可以再jdbc连接后面增加stringtype=unspecified来把JSON类型当STRING类型存储

spring.datasource.url=jdbc:postgresql://192.168.8.190:5432/oyz_3d_server?stringtype=unspecified
posted @ 2021-05-18 11:52  我命由我不由天—hao  阅读(4039)  评论(0)  编辑  收藏  举报