When using Oracle database, resources are encoded as JSONC by default instead of JSON

[simone-lungarella]

I have executed the same test using Oracle and Postgres database. It seems to me that when using Oracle, the resources are encoded as JSONC by default even if they should have been encoded as JSON as stated in the following line:

    private EncodingEnum default_encoding = EncodingEnum.JSON;

Here what I see on Postgres table: hfj_res_ver

| res_published            | res_updated 	      | res_encoding | 
| ------------------------ | ------------------------ | ------------ |
| 2025-05-06 19:29:57.149  | 2025-05-06 19:29:57.149  |	JSON         |
| 2025-05-06 19:29:27.940  | 2025-05-06 19:29:27.940  |	JSON         |

Here what I see on Oracle table: HFJ_RES_VER

| RES_PUBLISHED            | RES_UPDATED 	      | RES_ENCODING | 
| ------------------------ | ------------------------ | ------------ |
| 2025-05-06 19:35:37.949  | 2025-05-06 19:35:37.949  |	JSONC        |
| 2025-05-06 19:35:37.949  | 2025-05-06 19:35:37.949  |	JSONC        |

Is this the intended behavior? I don't see any option to override this setting through properties, is there a particular reason for that? I noticed that the Oracle solution is much slower (3x at least) than the Postgres one, I feel that compression might by the reason. Thanks!