{"record":{"id":"3fea4fd0afb30c59","repo":"hibernate/hibernate-orm","slug":"xml-array-columnexpression-in-aggr-3fea4f","errorCode":null,"errorMessage":"\"XML array '\" + columnExpression + \"' in '\" + aggregateParentReadExpression + \"' is not supported with legacy format enabled.\"","messagePattern":"\"XML array '\" \\+ columnExpression \\+ \"' in '\" \\+ aggregateParentReadExpression \\+ \"' is not supported with legacy format enabled\\.\"","errorType":"exception","errorClass":"IllegalArgumentException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/dialect/aggregate/HANAAggregateSupport.java","lineNumber":187,"sourceCode":"\t\t\t\t\t\t\t\tcaseExpression + \"hextobin(xmlextractvalue(\" + xmlParentPartExpression + columnExpression + \"')) end\"\n\t\t\t\t\t\t);\n\t\t\t\t\tcase DATE:\n\t\t\t\t\tcase TIME:\n\t\t\t\t\tcase TIMESTAMP:\n\t\t\t\t\tcase TIMESTAMP_UTC:\n\t\t\t\t\t\t// Cast from clob to varchar first\n\t\t\t\t\t\treturn template.replace(\n\t\t\t\t\t\t\t\tplaceholder,\n\t\t\t\t\t\t\t\tcaseExpression + \"cast(cast(xmlextractvalue(\" + xmlParentPartExpression + columnExpression + \"') as varchar(36)) as \" + xmlValueReturningType( column, getCastTypeName( column, typeConfiguration ) ) + \") end\"\n\t\t\t\t\t\t);\n\t\t\t\t\tcase SQLXML:\n\t\t\t\t\t\treturn template.replace(\n\t\t\t\t\t\t\t\tplaceholder,\n\t\t\t\t\t\t\t\tcaseExpression + XML_EXTRACT_READ_INVOCATION_START + xmlParentPartExpression + columnExpression + XML_EXTRACT_READ_END\n\t\t\t\t\t\t);\n\t\t\t\t\tcase XML_ARRAY:\n\t\t\t\t\t\tif ( typeConfiguration.getCurrentBaseSqlTypeIndicators().isXmlFormatMapperLegacyFormatEnabled() ) {\n\t\t\t\t\t\t\tthrow new IllegalArgumentException( \"XML array '\" + columnExpression + \"' in '\" + aggregateParentReadExpression + \"' is not supported with legacy format enabled.\" );\n\t\t\t\t\t\t}\n\t\t\t\t\t\telse {\n\t\t\t\t\t\t\treturn template.replace(\n\t\t\t\t\t\t\t\t\tplaceholder,\n\t\t\t\t\t\t\t\t\tcaseExpression + \"'<Collection>'||xmlextract(\" + xmlParentPartExpression + columnExpression + \"/*')||'</Collection>' end\"\n\t\t\t\t\t\t\t);\n\t\t\t\t\t\t}\n\t\t\t\t\tcase UUID:\n\t\t\t\t\t\tif ( SqlTypes.isBinaryType( column.getJdbcMapping().getJdbcType().getDdlTypeCode() ) ) {\n\t\t\t\t\t\t\treturn template.replace(\n\t\t\t\t\t\t\t\t\tplaceholder,\n\t\t\t\t\t\t\t\t\tcaseExpression + \"hextobin(replace(xmlextractvalue(\" + xmlParentPartExpression + columnExpression + \"'),'-','')) end\"\n\t\t\t\t\t\t\t);\n\t\t\t\t\t\t}\n\t\t\t\t\t\t// Fall-through intended\n\t\t\t\t\tdefault:\n\t\t\t\t\t\treturn template.replace(\n\t\t\t\t\t\t\t\tplaceholder,","sourceCodeStart":169,"sourceCodeEnd":205,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/dialect/aggregate/HANAAggregateSupport.java#L169-L205","documentation":"Error \"\"XML array '\" + columnExpression + \"' in '\" + aggregateParentReadExpression + \"' is not supported with legacy format enabled.\"\" thrown in hibernate/hibernate-orm.","triggerScenarios":"Triggered when the application calls a Hibernate dialect feature that the configured database dialect cannot provide: XML array is not supported with legacy format enabled (HANA).","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: XML array is not supported with legacy format enabled (HANA).","solutions":["Disable legacy XML format.","Avoid XML array aggregates on HANA."],"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"}