Ask Your Question

JDBC Lookup doesn't support for jsonb type

asked 2020-01-10 03:15:16 -0500

shixinbao gravatar image

I use jdbc lookup to query postgresql's table,the table has a column type of jsonb, jdbc lookup processor is failure

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2020-01-10 15:50:31 -0500

metadaddy gravatar image

JSONB is a Postgres-specific type; we don't support it in the JDBC Lookup processor. You could try writing the SELECT query to convert JSONB to a VARCHAR? Something like

SELECT CAST(jsonb_column AS VARCHAR) FROM table_name WHERE ...
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-10 03:15:16 -0500

Seen: 37 times

Last updated: Jan 10