{"record":{"id":"64b030f880e9f1ca","repo":"hibernate/hibernate-orm","slug":"can-t-emulate-on-error-clause-for-query-within-jso","errorCode":null,"errorMessage":"Can't emulate on error clause for query within json_table() on SQL server","messagePattern":"Can't emulate on error clause for query 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":126,"sourceCode":"\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( \"'['+\" );\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( queryColumnDefinition.name() );\n\t\t\t\tif ( queryColumnDefinition.wrapMode() == JsonQueryWrapMode.WITH_WRAPPER ) {\n\t\t\t\t\tsqlAppender.appendSql( \"+']'\" );\n\t\t\t\t}\n\t\t\t\tif ( queryColumnDefinition.emptyBehavior() == JsonQueryEmptyBehavior.EMPTY_ARRAY ) {\n\t\t\t\t\tsqlAppender.appendSql( \",'[]')\" );","sourceCodeStart":108,"sourceCodeEnd":144,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/dialect/function/json/SQLServerJsonTableFunction.java#L108-L144","documentation":"Error \"Can't emulate on error clause for query 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 query 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 query 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"}