{"record":{"id":"0086b7a933bb4df9","repo":"hibernate/hibernate-orm","slug":"no-result-found-for-query-getquerystring-0086b7","errorCode":null,"errorMessage":"No result found for query [{getQueryString()}]","messagePattern":"No result found for query \\[(.+?)\\]","errorType":"exception","errorClass":"NoResultException","httpStatus":null,"severity":"error","filePath":"hibernate-core/src/main/java/org/hibernate/query/internal/AbstractQuery.java","lineNumber":235,"sourceCode":"\tpublic T uniqueResult() {\n\t\t// note: throws different exception type\n\t\t//       to getSingleResultOrNull()\n\t\treturn uniqueElement( getResultList() );\n\t}\n\n\t@Override\n\t@SuppressWarnings(\"removal\")\n\t@Nonnull\n\tpublic Optional<T> uniqueResultOptional() {\n\t\treturn ofNullable( uniqueResult() );\n\t}\n\n\t@Override @SuppressWarnings(\"removal\")\n\tpublic T getSingleResult() {\n\t\ttry {\n\t\t\tfinal var list = getResultList();\n\t\t\tif ( list.isEmpty() ) {\n\t\t\t\tthrow new NoResultException( \"No result found for query [\" + getQueryString() + \"]\" );\n\t\t\t}\n\t\t\treturn uniqueElement( list );\n\t\t}\n\t\tcatch ( HibernateException e ) {\n\t\t\tthrow getExceptionConverter().convert( e, getQueryOptions().getLockOptions() );\n\t\t}\n\t}\n\n\t@Override @SuppressWarnings(\"removal\")\n\t@Nullable\n\tpublic T getSingleResultOrNull() {\n\t\ttry {\n\t\t\treturn uniqueElement( getResultList() );\n\t\t}\n\t\tcatch ( HibernateException e ) {\n\t\t\tthrow getExceptionConverter().convert( e, queryOptions.getLockOptions() );\n\t\t}\n\t}","sourceCodeStart":217,"sourceCodeEnd":253,"githubUrl":"https://github.com/hibernate/hibernate-orm/blob/fad1729dce015f908198d57a8d80274a30f905a5/hibernate-core/src/main/java/org/hibernate/query/internal/AbstractQuery.java#L217-L253","documentation":"Error \"No result found for query [{getQueryString()}]\" thrown in hibernate/hibernate-orm.","triggerScenarios":"getSingleResult() is called but the query returns no row: No result found for query [<value>]","commonSituations":"Expecting exactly one result when the query matches none; use getResultList() or catch NoResultException.","solutions":["getSingleResult() found no row. Ensure the query matches at least one row, or use a result list / null-tolerant retrieval."],"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"}