Loading JSON from Postgres Column via jdbc

Question

I have a postgres table that I am loading data out of for a java application. One of my columns is of type JSON. The problem is JDBC ResultSet does not have a loader for Json. Is my best bet to use resultSet.getString("COLUMN_NAME") or is there another option?

Andreas · Accepted Answer · 2015-09-18 22:29:17Z

8

To read from SQL using ResultSet? No other option (unless it's huge and defined as a CLOB).

To get JSON? Yes. You parse the JSON string you retrieved with getString(), using JSON parser of your choice, e.g. see this article: Top 7 Open-Source JSON-Binding Providers Available Today

Summary:

answered Sep 18, 2015 at 22:29

Andreas

160k13 gold badges164 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ford prefect Over a year ago

Thanks. Couldn't find another place where it was supported... Seemed like the kind of thing that would be implemented given it is a supported datatype in postgres

Andreas Over a year ago

But it's not a supported datatype in Java or JDBC.

ford prefect Over a year ago

Came back across this now many moons later and realized the difference. Thanks.

Collectives™ on Stack Overflow

Loading JSON from Postgres Column via jdbc

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related