Is there a Java library to directly access PLJSON Types returned from PLSQL procedures / functions which would be more performant than returning a CLOB and using another Java library like GSON to deserialize the JSON CLOB to Java POJOs?
My usecase is that I have an PLSQL procedure which constructs two separate PLJSON objects from relational data and returns those objects as two distinct CLOB OUT parameters, calling PLJSONs to_clob() function. In Java, I use GSON to deserialize those two CLOBs to two different Java classes.
I haven't found a library which supports such a direct type mapping via java.sql.SQLData and registering types via
java.util.Map map = con.getTypeMap();
map.put("mySchemaName.ATHLETES", Class.forName("Athletes"));
con.setTypeMap(map);
Would such a thing even be worth considering for performance or would it solely be a quality of life improvement?
