如何在本机查询插入后在JPA中返回ID [英] How to get returning ID in JPA after native query insert

问题描述

在JPA中，我使用以下代码在使用本机查询插入后返回自动生成的ID：

I have the following code in JPA to return an auto generated ID after inserting using native query:

Query q = em.createNativeQuery("insert into .... returning ID", Long.class);
q.executeUpdate();

但是，我收到以下错误：

However, I'm getting the following error:

A result was returned when none was expected

推荐答案

好的，这很简单。我刚刚使用q.getSingleResults（），它工作得很好！

OK that was an easy one. I have just used q.getSingleResults() and it worked fine!

Query q = em.createNativeQuery(sql);
BigInteger biid = (BigInteger) q.getSingleResult();
long id = biid.longValue();

这篇关于如何在本机查询插入后在JPA中返回ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！