Postgres Pro
Downloads
Home   >   mailing lists

Re: best way to convert JSONB object from result - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: best way to convert JSONB object from result
Date
Msg-id CADK3HHLeZ30U3Af6v0E3+C+0U1+RU51cebvGcYS591Cs67m0vg@mail.gmail.com
Whole thread Raw
In response to best way to convert JSONB object from result  (Tom Smith <tomsmith1989sk@gmail.com>)
List pgsql-jdbc
Tree view
Use boon,jackson or some other json parser to parse it into an object. 

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 19 August 2015 at 15:20, Tom Smith <tomsmith1989sk@gmail.com> wrote:
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

pgsql-jdbc by date:

Previous
From: dmp
Date:
Subject: Re: sql type reported for enum
Next
From: Mikko Tiihonen
Date:
Subject: Re: best way to convert JSONB object from result