I tried to use Apache Cayenne to map to my PostgreSQL schema which has json and jsonb data types. The Apache Cayenne modeler does not have the data type and changed to "OTHER". When I execute the SQL to re-create the database (necessary for utmost compatibility), it threw errors.
I then tried to look for alternative, like DataNucleus, to map to PostgreSQL's json and jsonb data types, but only to find that the Java driver does not support PostgreSQL 9.x. (So I assume DataNucleus JPO does not support PostgreSQL json and jsonb types.)
So, what are the solutions to map to PostgreSQL's json and jsonb and interoperate with data writing/retrieval for a Java-based application?