{"record":{"id":"0b90bd0c35543198","repo":"hibernate/hibernate-orm","slug":"json-not-supported","errorCode":null,"errorMessage":"JSON not supported!","messagePattern":"JSON not supported!","errorType":"exception","errorClass":"IllegalStateException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/dialect/aggregate/OracleAggregateSupport.java","lineNumber":433,"sourceCode":"\t\t\t\treturn aggregateParentAssignmentExpression + \".\" + columnExpression;\n\t\t}\n\t\tthrow new IllegalArgumentException( \"Unsupported aggregate SQL type: \" + aggregateColumnTypeCode );\n\t}\n\n\tprivate String jsonCustomWriteExpression(\n\t\t\tString customWriteExpression,\n\t\t\tSelectableMapping column,\n\t\t\tTypeConfiguration typeConfiguration) {\n\t\tswitch ( jsonSupport ) {\n\t\t\tcase OSON:\n\t\t\tcase MERGEPATCH:\n\t\t\tcase QUERY_AND_PATH:\n\t\t\tcase QUERY:\n\t\t\t\tStringBuilderSqlAppender sqlAppender = new StringBuilderSqlAppender();\n\t\t\t\tappendJsonWriteExpression( sqlAppender, () -> sqlAppender.appendSql( customWriteExpression ), column.getJdbcMapping(), typeConfiguration );\n\t\t\t\treturn sqlAppender.toString();\n\t\t}\n\t\tthrow new IllegalStateException( \"JSON not supported!\" );\n\t}\n\n\tpublic void appendJsonWriteExpression(\n\t\t\tSqlAppender sqlAppender,\n\t\t\tRunnable renderFunction,\n\t\t\tJdbcMapping jdbcMapping,\n\t\t\tTypeConfiguration typeConfiguration) {\n\t\tfinal int sqlTypeCode = jdbcMapping.getJdbcType().getDefaultSqlTypeCode();\n\t\tswitch ( sqlTypeCode ) {\n\t\t\tcase CLOB:\n\t\t\t\tsqlAppender.append( \"to_clob(\" );\n\t\t\t\trenderFunction.run();\n\t\t\t\tsqlAppender.append( \")\" );\n\t\t\t\tbreak;\n\t\t\tcase UUID:\n\t\t\t\tsqlAppender.append( \"regexp_replace(lower(rawtohex(\" );\n\t\t\t\trenderFunction.run();\n\t\t\t\tsqlAppender.append( \")),'^(.{8})(.{4})(.{4})(.{4})(.{12})$','\\\\1-\\\\2-\\\\3-\\\\4-\\\\5')\" );","sourceCodeStart":415,"sourceCodeEnd":451,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/dialect/aggregate/OracleAggregateSupport.java#L415-L451","documentation":"Error \"JSON not supported!\" thrown in hibernate/hibernate-orm.","triggerScenarios":"Triggered when the application calls a Hibernate dialect feature that the configured database dialect cannot provide: JSON not supported!.","commonSituations":"Common when running against a database whose dialect lacks this capability, when a mapping or HQL/Criteria query requests unsupported functionality, or when the wrong dialect is configured for the database in use. Error: JSON not supported!.","solutions":["Enable JSON support / upgrade Oracle.","Avoid JSON aggregate mappings."],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"fad1729dce015f908198d57a8d80274a30f905a5","analyzedAt":"2026-08-22T04:13:57.527Z","schemaVersion":2},"datasetVersion":"2026-08-22T09:17:25.309Z"}