Re: MySQL JSON Support

Thanks Andrus and John for the feedback.

It looks like Postgres has better JSON support than MySQL.

regards Malcolm

On Wed, May 6, 2020 at 12:32 AM John Huss <[email protected]> wrote:

> I have been using the Postgres JSONB type as an entity attribute (mapped as
> jdbc type OTHER) for some time, both with Lists and Maps. You can define an
> ExtendedType subclass to read the value as a string and parse into a
> map/list using Jackson's ObjectMapper.
>
> On Mon, May 4, 2020 at 11:23 PM Malcolm Edgar <[email protected]>
> wrote:
>
> > Hi All,
> >
> > I was hoping to use the JSON features in MySQL 5.7 and wondered if anyone
> > had used with with Cayenne.  I was hoping to use Named Queries to perform
> > JSON specific queries, but treat it as a String otherwise with the
> Cayenne
> > classes.
> >
> > Any comments or recommendations would be appreciated.
> >
> > regards Malcolm
> >
>