Re: How to retrieve jsonb column through JDBC

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: How to retrieve jsonb column through JDBC
Дата
Msg-id CAADeyWjwtxOsikA_EqAG6s7fkehKVGjUsgT18PnSA-JjzQrgFg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to retrieve jsonb column through JDBC  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: How to retrieve jsonb column through JDBC  (Alban Hertroys <haramrae@gmail.com>)
Список pgsql-general


On Mon, Aug 29, 2016 at 7:50 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
On Sat, Aug 27, 2016 at 5:39 AM, Alexander Farber
<alexander.farber@gmail.com> wrote:
>
>          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...

huh.  what exactly is failing? are you getting a parse exception?


fails with:

java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to java.util.List

Regards
Alex

В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: How to retrieve jsonb column through JDBC
Следующее
От: Josh Berkus
Дата:
Сообщение: 9.6 Release: Call for Quotes