首页 > 数据库技术 > 详细

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

时间:2021-05-18 16:11:36      阅读:47      评论:0      收藏:0      [点我收藏+]

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

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

原文:https://www.cnblogs.com/haolb123/p/14780335.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!