Re: Modeler Types

Andrus Adamchik <[email protected]> Fri, 5 Nov 2021 08:34:22 +0200

Newsgroups	gmane.comp.java.cayenne.user
Message-ID	<[email protected]>

Hi Tony,

Support for non-standard SQL types was added in 4.2:

https://lists.apache.org/thread/66nhvkzt1mqoh2h53h2x6sbx968kt2fy

We are mapping those types on the DB side as JDBC type OTHER. On the Java type it is mapped as org.apache.cayenne.value.Json.

Andrus


> On Nov 4, 2021, at 6:34 PM, Tony Giaccone <[email protected]> wrote:
> 
> So Postgres supports a json type in their database.  Clearly this isn't a
> type that's generally available, but it would be nice if the modeler
> supported the ability to add types, so in this way you could support the
> unusual types, that sometimes need to be used. Clearly I have no idea how
> hard this would be to implement in the modeler, but it sure would be a nice
> feature.
> 
> 
> Tony Giaccone