{"record":{"id":"a53bf4a90407f164","repo":"hibernate/hibernate-orm","slug":"unsupported-aggregate-sql-type-aggregatesqlt-a53bf4","errorCode":null,"errorMessage":"\"Unsupported aggregate SQL type: \" + aggregateSqlTypeCode","messagePattern":"\"Unsupported aggregate SQL type: \" \\+ aggregateSqlTypeCode","errorType":"exception","errorClass":"IllegalArgumentException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/dialect/aggregate/DB2AggregateSupport.java","lineNumber":423,"sourceCode":"\n\t@Override\n\tpublic WriteExpressionRenderer aggregateCustomWriteExpressionRenderer(\n\t\t\tSelectableMapping aggregateColumn,\n\t\t\tSelectableMapping[] columnsToUpdate,\n\t\t\tTypeConfiguration typeConfiguration) {\n\t\tfinal int aggregateSqlTypeCode = aggregateColumn.getJdbcMapping().getJdbcType().getDefaultSqlTypeCode();\n\t\tswitch ( aggregateSqlTypeCode ) {\n\t\t\tcase JSON:\n\t\t\t\tif ( jsonSupport ) {\n\t\t\t\t\treturn new RootJsonWriteExpression( aggregateColumn, columnsToUpdate );\n\t\t\t\t}\n\t\t\t\tbreak;\n\t\t\tcase SQLXML:\n\t\t\t\treturn new RootXmlWriteExpression( aggregateColumn, columnsToUpdate );\n\t\t\tcase STRUCT:\n\t\t\t\treturn new RootStructWriteExpression( aggregateColumn, columnsToUpdate, typeConfiguration );\n\t\t}\n\t\tthrow new IllegalArgumentException( \"Unsupported aggregate SQL type: \" + aggregateSqlTypeCode );\n\t}\n\n\tprivate static String castTypeName(Column udtColumn, TypeConfiguration typeConfiguration) {\n\t\treturn getCastTypeName(\n\t\t\t\tnew SqlTypedMappingImpl(\n\t\t\t\t\t\tudtColumn.getLength(),\n\t\t\t\t\t\tudtColumn.getArrayLength(),\n\t\t\t\t\t\tudtColumn.getPrecision(),\n\t\t\t\t\t\tudtColumn.getScale(),\n\t\t\t\t\t\tudtColumn.getTemporalPrecision(),\n\t\t\t\t\t\tudtColumn.getType()\n\t\t\t\t),\n\t\t\t\ttypeConfiguration\n\t\t);\n\t}\n\n\tinterface AggregateWriteExpression {\n\t\tvoid append(","sourceCodeStart":405,"sourceCodeEnd":441,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/dialect/aggregate/DB2AggregateSupport.java#L405-L441","documentation":"Error \"\"Unsupported aggregate SQL type: \" + aggregateSqlTypeCode\" thrown in hibernate/hibernate-orm.","triggerScenarios":"Triggered when the application calls a Hibernate dialect feature that the configured database dialect cannot provide: Unsupported aggregate SQL type (DB2).","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: Unsupported aggregate SQL type (DB2).","solutions":["Map the aggregate with a supported SQL type.","Avoid the unsupported aggregate type on DB2."],"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"}