解决报错：ERROR: column is of type json but expression is of type character varying...

使用Logstash向Mysql的json类型字段插入时报错。

[ERROR] 2022-09-26 16:55:50.316 [[main]>worker3] jdbc - JDBC - Exception.
 Not retrying {:exception=>org.postgresql.util.PSQLException: ERROR: column "test_column" is of type json but expression is of type character varying

解决办法： 将sql语句中json字段对应的  ?  改为  ?::jsonb

例如：

INSERT INTO xxx (id, json_column) VALUES(?, ?)

改为如下

INSERT INTO xxx (id, json_column) VALUES(?, ?::jsonb)

参考自：https://stackoverflow.com/questions/38967373/logstash-output-plugin-for-jdbc-mysql