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 <johnth...@gmail.com> 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 <malcolm.ed...@gmail.com> > 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 > > >
