String not converted to jsonb - Error: column is of type jsonb but expression is of type character varying

confluentinc / kafka-connect-jdbc

Kafka Connect connector for JDBC-compatible databases

Other

1.01k stars 953 forks source link

String not converted to jsonb - Error: column is of type jsonb but expression is of type character varying #1375

Open AmitSahar16 opened 6 months ago

AmitSahar16 commented 6 months ago

I’m getting an error- column is of type jsonb but expression is of type character varying, my version of Kafka connect is 10.6.4. I created stream with field of type string that in Postgres is in type Janine, every time I insert data to the Kafka the connector fails an I’m getting this error.