{"record":{"id":"db75eba42cb4d152","repo":"hibernate/hibernate-orm","slug":"query-result-set-caching-disallowed-for-historical","errorCode":null,"errorMessage":"Query result set caching disallowed for historical query","messagePattern":"Query result set caching disallowed for historical query","errorType":"exception","errorClass":"IllegalStateException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/query/internal/AbstractCommonQueryContract.java","lineNumber":535,"sourceCode":"\t\t\t\tcase HINT_QUERY_DATABASE:\n\t\t\t\t\tqueryOptions.addDatabaseHint( (String) value );\n\t\t\t\t\treturn true;\n\t\t\t\t// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\t\t\t\t// sometimes relevant\n\t\t\t\tcase HINT_QUERY_PLAN_CACHEABLE:\n\t\t\t\t\tapplyQueryPlanCachingHint( hintName, value );\n\t\t\t\tcase HINT_READ_ONLY:\n\t\t\t\t\tapplyReadOnlyHint( hintName, value );\n\t\t\t\t\treturn true;\n\t\t\t\tcase HINT_FETCH_SIZE:\n\t\t\t\t\tapplyFetchSizeHint( hintName, value );\n\t\t\t\t\treturn true;\n\t\t\t\tcase HINT_LIMIT_IN_MEMORY:\n\t\t\t\t\tqueryOptions.setLimitInMemory( getBoolean( value ) );\n\t\t\t\t\treturn true;\n\t\t\t\tcase HINT_CACHEABLE:\n\t\t\t\t\tif ( isHistorical() ) {\n\t\t\t\t\t\tthrow new IllegalStateException( \"Query result set caching disallowed for historical query\" );\n\t\t\t\t\t}\n\t\t\t\t\tapplyResultCachingHint( hintName, value );\n\t\t\t\t\treturn true;\n\t\t\t\tcase HINT_CACHE_REGION:\n\t\t\t\t\tqueryOptions.setResultCacheRegionName( (String) value );\n\t\t\t\t\treturn true;\n\t\t\t\tcase HINT_CACHE_MODE:\n\t\t\t\t\tapplyResultCacheModeHint( hintName, value );\n\t\t\t\t\treturn true;\n\t\t\t\tcase HINT_JAVAEE_CACHE_RETRIEVE_MODE:\n\t\t\t\t\tDEPRECATION_LOGGER.deprecatedHint( HINT_JAVAEE_CACHE_RETRIEVE_MODE, HINT_SPEC_CACHE_RETRIEVE_MODE );\n\t\t\t\t\t//fall through to:\n\t\t\t\tcase HINT_SPEC_CACHE_RETRIEVE_MODE:\n\t\t\t\t\tapplyResultCachingRetrieveModeHint( hintName, value );\n\t\t\t\t\treturn true;\n\t\t\t\tcase HINT_JAVAEE_CACHE_STORE_MODE:\n\t\t\t\t\tDEPRECATION_LOGGER.deprecatedHint( HINT_JAVAEE_CACHE_STORE_MODE, HINT_SPEC_CACHE_STORE_MODE );\n\t\t\t\t\t//fall through to:","sourceCodeStart":517,"sourceCodeEnd":553,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/query/internal/AbstractCommonQueryContract.java#L517-L553","documentation":"Error \"Query result set caching disallowed for historical query\" thrown in hibernate/hibernate-orm.","triggerScenarios":"Query caching is used in an unsupported way: Query result set caching disallowed for historical query","commonSituations":"Enabling result-set caching on historical (audit) queries, or using cache modes the query does not support.","solutions":["Result-set caching cannot be used with a historical (audit) query. Remove setCacheable(true) / the cache hint from the historical query."],"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"}