Re: [GENERAL] How to retrieve jsonb column through JDBC

2016-08-29 Thread Alban Hertroys
> On 29 Aug 2016, at 20:23, Alexander Farber wrote: > On Mon, Aug 29, 2016 at 7:50 PM, Merlin Moncure wrote: > On Sat, Aug 27, 2016 at 5:39 AM, Alexander Farber > wrote: > > > > List last_tiles = (List)

Re: [GENERAL] How to retrieve jsonb column through JDBC

2016-08-29 Thread Alexander Farber
On Mon, Aug 29, 2016 at 7:50 PM, Merlin Moncure wrote: > On Sat, Aug 27, 2016 at 5:39 AM, Alexander Farber > wrote: > > > > List last_tiles = (List) JSON.parse(rs.getString("last_ > tiles")); > > > > has not work for me even though the

Re: [GENERAL] How to retrieve jsonb column through JDBC

2016-08-29 Thread Merlin Moncure
On Sat, Aug 27, 2016 at 5:39 AM, Alexander Farber wrote: > 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

Re: [GENERAL] How to retrieve jsonb column through JDBC

2016-08-27 Thread Dave Cramer
Unfortunately JSONB is output in text. So this is the way it is done. Dave Cramer da...@postgresintl.com www.postgresintl.com On 27 August 2016 at 06:39, Alexander Farber wrote: > Hello, > > what do you use to retrieve a jsonb column using JDBC? > > I have tried >

[GENERAL] How to retrieve jsonb column through JDBC

2016-08-27 Thread Alexander Farber
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 =