How to retrieve jsonb column through JDBC

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to retrieve jsonb column through JDBC
Date: 2016-08-27 10:39:37
Message-ID: CAADeyWhNooe=vRm+8m6baTYg1uDEu3d5kfiNAnqDa1CrE3Dnig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

what do you use to retrieve a jsonb column using JDBC?

I have tried

Object last_tiles = rs.getObject("last_tiles");

and the resulting Object seems to be a String.

Then I have called (using Jetty JSON class here):

Object last_tiles = JSON.parse(rs.getString("last_tiles"));

And it seems to work ok... but I am still curious, what is the recommended
(or maybe planned for future) way for retrieving jsonb data in Java.

Also

List last_tiles = (List) JSON.parse(rs.getString("last_tiles"));

has not work for me even though the string is:

[{"col": 7, "row": 8, "value": 1, "letter": "A"}, {"col": 7, "row": 7,
"value": 2, "letter": "B"}, {"col": 7, "row": 9, "value": 2, "letter": "C"}]

but it is probably the problem of the Jetty class I am using and not of
JDBC...

Regards
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2016-08-28 01:16:58 Re: How to retrieve jsonb column through JDBC
Previous Message Merlin Moncure 2016-08-26 21:55:06 Re: a column definition list is required for functions returning "record"