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 >
