{"record":{"id":"6f8d472890296a9e","repo":"hibernate/hibernate-orm","slug":"this-dialect-does-not-support-query-pagination","errorCode":null,"errorMessage":"this dialect does not support query pagination","messagePattern":"this dialect does not support query pagination","errorType":"exception","errorClass":"UnsupportedOperationException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/dialect/Dialect.java","lineNumber":2286,"sourceCode":"\t * Does this database support primary keys for temporary tables?\n\t *\n\t * @return true by default, since most do\n\t * @deprecated Moved to {@link TemporaryTableStrategy#supportsTemporaryTablePrimaryKey()}\n\t */\n\t@Deprecated(forRemoval = true, since = \"7.1\")\n\tpublic boolean supportsTemporaryTablePrimaryKey() {\n\t\t// Most databases do\n\t\treturn true;\n\t}\n\n\t// limit/offset support ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n\t/**\n\t * Obtain a {@link LimitHandler} that implements pagination support for\n\t * {@link Query#setMaxResults(int)} and {@link Query#setFirstResult(int)}.\n\t */\n\tpublic LimitHandler getLimitHandler() {\n\t\tthrow new UnsupportedOperationException(\"this dialect does not support query pagination\");\n\t}\n\n\n\t// lock acquisition support ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n\t/**\n\t * Access to various details and operations related to this\n\t * Dialect's support for pessimistic locking.\n\t */\n\tpublic LockingSupport getLockingSupport() {\n\t\treturn LockingSupportSimple.STANDARD_SUPPORT;\n\t}\n\n\n\t/**\n\t * Whether this dialect supports {@code for update (of)}\n\t *\n\t * @deprecated See notes on {@linkplain LockingSupport.Metadata#supportsForUpdate()}","sourceCodeStart":2268,"sourceCodeEnd":2304,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/dialect/Dialect.java#L2268-L2304","documentation":"Error \"this dialect does not support query pagination\" thrown in hibernate/hibernate-orm.","triggerScenarios":"Triggered when the application calls a Hibernate dialect feature that the configured database dialect cannot provide: this dialect does not support query pagination.","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: this dialect does not support query pagination.","solutions":["Remove pagination calls or switch to a dialect that supports LIMIT/OFFSET.","Implement a custom dialect overriding getLimitHandler."],"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"}