{"record":{"id":"670b17193e3e711f","repo":"hibernate/hibernate-orm","slug":"can-t-emulate-on-error-clause-for-value-within-jso","errorCode":null,"errorMessage":"Can't emulate on error clause for value within json_table() on SQL server","messagePattern":"Can't emulate on error clause for value within json_table\\(\\) on SQL server","errorType":"exception","errorClass":"QueryException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/dialect/function/json/SQLServerJsonTableFunction.java","lineNumber":116,"sourceCode":"\t\t\t\trenderColumnDefinitions( sqlAppender, nestedColumnDefinition.columns(), nextClauseLevel, walker );\n\t\t\t\tsqlAppender.appendSql( \" t\" );\n\t\t\t\tsqlAppender.appendSql( nextClauseLevel );\n\t\t\t\tsqlAppender.appendSql( \") t\" );\n\t\t\t\tsqlAppender.appendSql( nextClauseLevel );\n\t\t\t\tcurrentClauseLevel = renderNestedColumnJoins( sqlAppender, nestedColumnDefinition.columns(), nextClauseLevel, walker );\n\t\t\t}\n\t\t}\n\t\treturn currentClauseLevel;\n\t}\n\n\tprotected void renderColumnSelects(SqlAppender sqlAppender, JsonTableColumnsClause jsonTableColumnsClause, int clauseLevel, SqlAstTranslator<?> walker) {\n\t\tint currentClauseLevel = clauseLevel;\n\t\tchar separator = ' ';\n\t\tfor ( JsonTableColumnDefinition columnDefinition : jsonTableColumnsClause.getColumnDefinitions() ) {\n\t\t\tsqlAppender.appendSql( separator );\n\t\t\tif ( columnDefinition instanceof JsonTableValueColumnDefinition valueColumnDefinition ) {\n\t\t\t\tif ( valueColumnDefinition.errorBehavior() != null && valueColumnDefinition.errorBehavior() != JsonValueErrorBehavior.ERROR ) {\n\t\t\t\t\tthrow new QueryException( \"Can't emulate on error clause for value within json_table() on SQL server\" );\n\t\t\t\t}\n\t\t\t\tsqlAppender.appendSql( 't' );\n\t\t\t\tsqlAppender.appendSql( clauseLevel );\n\t\t\t\tsqlAppender.appendSql( '.' );\n\t\t\t\tsqlAppender.appendSql( valueColumnDefinition.name() );\n\t\t\t\t// todo: empty behavior?\n\t\t\t}\n\t\t\telse if ( columnDefinition instanceof JsonTableQueryColumnDefinition queryColumnDefinition ) {\n\t\t\t\tif ( queryColumnDefinition.errorBehavior() != null && queryColumnDefinition.errorBehavior() != JsonQueryErrorBehavior.ERROR ) {\n\t\t\t\t\tthrow new QueryException( \"Can't emulate on error clause for query within json_table() on SQL server\" );\n\t\t\t\t}\n\t\t\t\tif ( queryColumnDefinition.emptyBehavior() == JsonQueryEmptyBehavior.EMPTY_ARRAY\n\t\t\t\t\t\t|| queryColumnDefinition.emptyBehavior() == JsonQueryEmptyBehavior.EMPTY_OBJECT ) {\n\t\t\t\t\tsqlAppender.appendSql( \"coalesce(\" );\n\t\t\t\t}\n\t\t\t\t// SQL Server only supports no wildcard in JSON paths, so wrapper can be added statically\n\t\t\t\tif ( queryColumnDefinition.wrapMode() == JsonQueryWrapMode.WITH_WRAPPER ) {\n\t\t\t\t\tsqlAppender.appendSql( \"'['+\" );","sourceCodeStart":98,"sourceCodeEnd":134,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/dialect/function/json/SQLServerJsonTableFunction.java#L98-L134","documentation":"Error \"Can't emulate on error clause for value within json_table() on SQL server\" thrown in hibernate/hibernate-orm.","triggerScenarios":"Triggered when the application calls a Hibernate dialect feature that the configured database dialect cannot provide: Can't emulate on error clause for value within json_table() on SQL server.","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: Can't emulate on error clause for value within json_table() on SQL server.","solutions":["Remove the ON ERROR clause from the json_table column."],"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"}