best way to convert JSONB object from result

From: Tom Smith <tomsmith1989sk(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: best way to convert JSONB object from result
Date: 2015-08-19 19:20:57
Message-ID: CAKwSVFGcWsupX6mhEgPaZmnAXcaELv7WY7souWbM7Czo3iCkCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi:

I am trying to convert to a Java or Map object
from resultset with a jsonb column.
Currently, I am using

String jsonString = resultSet.getString("jsonb_column_name")

then I convert from jsonString to a Map<String,Object> or a Java class
object.

This is obviously inefficient. What would be most efficient (not too
complicated)

Thanks in Advance

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2015-08-19 19:27:49 Re: sql type reported for enum
Previous Message rcohen 2015-08-19 18:16:39 Re: sql type reported for enum