Mybatis操作PgSQL的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.
spring.datasource.url=jdbc:postgresql://192.168.8.190:5432/oyz_3d_server?stringtype=unspecified
原文:https://www.cnblogs.com/haolb123/p/14780335.html