{"record":{"id":"fc783e630bee6283","repo":"hibernate/hibernate-orm","slug":"can-t-emulate-null-on-error-clause-on-postgresql","errorCode":null,"errorMessage":"Can't emulate null on error clause on PostgreSQL","messagePattern":"Can't emulate null on error clause on PostgreSQL","errorType":"exception","errorClass":"QueryException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/dialect/function/json/PostgreSQLJsonTableFunction.java","lineNumber":54,"sourceCode":"\n/**\n * PostgreSQL json_table function.\n */\npublic class PostgreSQLJsonTableFunction extends JsonTableFunction {\n\n\tpublic PostgreSQLJsonTableFunction(TypeConfiguration typeConfiguration) {\n\t\tsuper( typeConfiguration );\n\t}\n\n\t@Override\n\tprotected void renderJsonTable(\n\t\t\tSqlAppender sqlAppender,\n\t\t\tJsonTableArguments arguments,\n\t\t\tAnonymousTupleTableGroupProducer tupleType,\n\t\t\tString tableIdentifierVariable,\n\t\t\tSqlAstTranslator<?> walker) {\n\t\tif ( arguments.errorBehavior() == JsonTableErrorBehavior.NULL ) {\n\t\t\tthrow new QueryException( \"Can't emulate null on error clause on PostgreSQL\" );\n\t\t}\n\t\tsqlAppender.appendSql( \"(select\" );\n\n\t\trenderColumns( sqlAppender, arguments.columnsClause(), 0, walker );\n\n\t\tsqlAppender.appendSql( \" from jsonb_path_query(\" );\n\n\t\tfinal boolean needsCast = !arguments.isJsonType() && AbstractSqlAstTranslator.isParameter( arguments.jsonDocument() );\n\t\tif ( needsCast ) {\n\t\t\tsqlAppender.appendSql( \"cast(\" );\n\t\t}\n\t\targuments.jsonDocument().accept( walker );\n\t\tif ( needsCast ) {\n\t\t\tsqlAppender.appendSql( \" as jsonb)\" );\n\t\t}\n\t\tfinal SqlAstNode jsonPath = arguments.jsonPath();\n\t\tif ( jsonPath != null ) {\n\t\t\tsqlAppender.appendSql( ',' );","sourceCodeStart":36,"sourceCodeEnd":72,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/dialect/function/json/PostgreSQLJsonTableFunction.java#L36-L72","documentation":"Error \"Can't emulate null on error clause on PostgreSQL\" 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 null on error clause on PostgreSQL.","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 null on error clause on PostgreSQL.","solutions":["Remove the NULL ON ERROR clause for PostgreSQL."],"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"}