blocks|key|1828650|text|您的查询似乎返回多个结果，检查数据库。在query.uniqueResult()文档中，您可以阅读：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1828651|抛出:+org.hibernate.NonUniqueResultException+-如果有多个匹配结果|blockquote|1828652|如果您希望避免此错误，并且仍然使用唯一的结果请求，则可以使用这种解决方法query.setMaxResults(1).uniqueResult();。|1828653|entityMap^0|K|K|0|0|10|12|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$]]|$1|I|3|J|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|K|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|L|$]]

It seems like your query returns more than one result check the database. In documentation of <code>query.uniqueResult()</code> you can read:

<blockquote>
 Throws: org.hibernate.NonUniqueResultException - if there is more
 than one matching result
</blockquote>

If you want to avoid this error and still use unique result request, you can use this kind of workaround <code>query.setMaxResults(1).uniqueResult();</code>

blocks|key|1828728|text|Hibernate可选findTopByClientIdAndStatusOrderByCreateTimeDesc(Integer+clientId，整数状态)；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1828729|"findTop"！唯一的结果！|1828730|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Hibernate 
 Optional findTopByClientIdAndStatusOrderByCreateTimeDesc(Integer clientId, Integer status);

"findTop"!! The only one result!

blocks|key|2825368|text|我不认为其他答案解释了关键的部分:为什么"COUNT(*)“返回多个结果？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2825369|我今天刚刚遇到了同样的问题，我发现如果您有另一个类扩展目标映射类(此处为"CustomerData")，Hibernate将执行此操作。|2825370|希望这能为其他不幸的人节省点时间。|2825371|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I don't think other answers explained the key part: why "COUNT(*)" returns more than one result?

I just encountered the same issue today, and what I found out is that if you have another class extending the target mapped class (here "CustomerData"), Hibernate will do this magic.

Hope this will save some time for other unfortunate guys.

blocks|key|222684|text|这意味着您编写的查询返回多个元素(结果)，而您的代码需要一个结果。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|222685|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

It means that the query you wrote returns more than one element(result) while your code expects a single result.

blocks|key|222826|text|在执行其他更正hibernate查询时收到此错误。问题是，当有一个类扩展时，另一个hibernate将两者都计算在内。通过向存储库类添加一个方法，可以“修复”此错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|222827|通过重写类计数，您可以手动确定计数的方式。|222828|@Override+
public+Integer+count(Page<MyObject>+page)+{
+++//+manual+counting+method+here
}|code-block|syntax|javascript|222829|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Received this error while doing otherwise correct hibernate queries. The issue was that when having a class extend another hibernate was counting both. This error can be &quot;fixed&quot; by adding a method to your repository class.
By overriding the class count you can manually determine the way this is counted.
<pre><code>@Override 
public Integer count(Page&lt;MyObject&gt; page) {
 // manual counting method here
}
</code></pre>

blocks|key|222838|text|我正在使用JPQL，并希望返回Map。在我的例子中，原因是我想获得Map<String,+String>，但不得不期望List<Map<String,+String>>+:)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|222839|entityMap^0|F|3|X|J|1N|P|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

I was using JPQL and wanted to return <code>Map</code>. In my case, the reason was that I wanted to get <code>Map&lt;String, String&gt;</code>, but had to expect <code>List&lt;Map&lt;String, String&gt;&gt;</code> :)

blocks|key|2825563|text|我发现了问题的核心：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2825564|选择COUNT(*)的结果可以是一个列表，如果查询中有组BY，则为|offset|length|style|BOLD|2825565|有时Hibernate重写您的HQL并将一个组放入其中，只是为了好玩。|2825566|entityMap^0|0|B|M|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I have found the core of the problem:
result of SELECT COUNT(*) can be a list, if there is a GROUP BY in the query,
and sometimes Hibernate rewrite your HQL and put a GROUP BY into it, just for fun.

blocks|key|2825379|text|基本上，您的查询返回多个结果集。在API中，uniqueResult()方法表示，方便地返回与查询匹配的单个实例，如果查询不返回结果，则返回null|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2825380|uniqueResult()方法只产生单个结果集|2825381|entityMap^0|15|P|0|0|E|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

Basically your query returns more than one result set.
 In API Docs uniqueResult() method says that 
 Convenience method to return a single instance that matches
 the query, or null if the query returns no results

uniqueResult() method yield only single resultset

blocks|key|1828743|text|该异常是否会在未完成的事务中抛出，其中您的应用程序试图创建一个包含重复字段的实体，用于查找单个实体所使用的标识符？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1828744|在这种情况下，新的(重复的)实体将在数据库中不可见，因为事务不会有，而且永远不会提交给db。但是，异常仍将被抛出。|1828745|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Could this exception be thrown during an unfinished transaction, where your application is attempting to create an entity with a duplicate field to the identifier you are using to try find a single entity?

In this case the new (duplicate) entity will not be visible in the database as the transaction won't have, and will never be committed to the db. The exception will still be thrown however.

blocks|key|222802|text|虽然这可能对某些人有帮助，但发生这种情况是因为“当数据查询的数量大于1”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|222803|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Thought this might help to someone, it happens because "When the number of data queries is greater than 1".<a href="http://www.programmersought.com/article/1864419699/" rel="nofollow noreferrer">reference</a>

blocks|key|2825498|text|正如伊恩·王所说的，我怀疑你在使用春季的仓库。几天前，您只是复制了一个类，然后忘了在它最终未使用时删除它。检查该存储库，看看是否存在多个相同的表类。计数不是行的计数，而是表问题的计数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2825499|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

As what Ian Wang said, I suspect you are using a repository from spring. And a few days ago you just copy past a class and forgot to delete it when it is finally unused. Check that repository, and see if there is multiple same class of table you use. The count is not the count of rows, but the count of the table problem.

blocks|key|1828770|text|这意味着orm技术没有预先编程来给出您正在寻找的结果，因为数据库中有太多相同的结果。例如，如果我的数据库中有多个相同的值，并且我希望得到它，那么您将遇到select查询所得到的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1828771|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This means that orm technology is not preprogrammed to give you which results you are looking for because there are too many of the same results in the database. for example If there is more than one same value in my database and I want to get it back, you will encounter the error you get with the select query.

blocks|key|222886|text|对我来说，错误是由spring.jpa.hibernate.ddl-auto=update在application.properties文件中替换为spring.jpa.hibernate.ddl-auto=create解决了问题，但它仍然取决于您需要决定您需要在您的项目中的配置，以获得更多关于主题检查这的见解。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|222887|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/42135114/how-does-spring-jpa-hibernate-ddl-auto-property-exactly-work-in-spring#:%257E:text=%2522spring.-,jpa.,database%2520table%2520instance%2520is%2520droped.^0|9|10|22|10|48|1|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@$9|S|A|T|1|U]]|E|$]]|$1|F|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

For me the error is caused by
<code>spring.jpa.hibernate.ddl-auto=update</code>
in application.properties file replacing it with
<code>spring.jpa.hibernate.ddl-auto=create</code> solved the issue, but it still depends on your needs to decide which configuration you need in your project, for more insights on the topic check <a href="https://stackoverflow.com/questions/42135114/how-does-spring-jpa-hibernate-ddl-auto-property-exactly-work-in-spring#:%7E:text=%22spring.-,jpa.,database%20table%20instance%20is%20droped.">this</a>.

blocks|key|2825325|text|首先，必须测试查询列表的大小；下面是一个示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2825326|long+count;
if+(query.list().size()+>+0)
++++count=(long)+criteria.list().get(0);+++
else
++++count=0;++++++++++++
return+count;|code-block|syntax|javascript|2825327|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

First you must test the query list size; here a example:

<pre><code>long count;
if (query.list().size() &gt; 0)
 count=(long) criteria.list().get(0); 
else
 count=0; 
return count;
</code></pre>

I have below code in my DAO:
<pre><code>String sql = &quot;SELECT COUNT(*) FROM CustomerData &quot; +
 &quot;WHERE custId = :custId AND deptId = :deptId&quot;;
Query query = session.createQuery(sql);
query.setParameter(&quot;custId&quot;, custId);
query.setParameter(&quot;deptId&quot;, deptId);
long count = (long) query.uniqueResult(); // ERROR THROWN HERE
</code></pre>
Hibernate throws below exception at the marked line:
<blockquote>
org.hibernate.NonUniqueResultException: query did not return a unique result:
</blockquote>
I am not sure whats happening as <code>count(*)</code> will always return only one row.
Also when i run this query on db directly, it return result as 1. So whats the issue?

org.hibernate.NonUniqueResultException: query did not return a unique result: 2?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我的DAO中有以下代码：String sql = "SELECT COUNT(*) FROM CustomerData " +             "WHERE custId = :custId AND deptId = :deptId";Query query = session.createQuery(sql);query.setParameter("custId", custId);qu

问org.hibernate.NonUniqueResultException:查询没有返回唯一的结果: 2？
EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问org.hibernate.NonUniqueResultException:查询没有返回唯一的结果: 2？EN

回答 14

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问org.hibernate.NonUniqueResultException:查询没有返回唯一的结果: 2？
EN