我在JPA中有以下代码,用于使用本地查询插入后返回自动生成的ID:
Query q = em.createNativeQuery("insert into .... returning ID", Long.class);
q.executeUpdate();
然而,我遇到了以下错误:
A result was returned when none was expected
我在JPA中有以下代码,用于使用本地查询插入后返回自动生成的ID:
Query q = em.createNativeQuery("insert into .... returning ID", Long.class);
q.executeUpdate();
A result was returned when none was expected
好的,这很简单。我刚刚使用了q.getSingleResults(),并且它运行得很好!
Query q = em.createNativeQuery(sql);
BigInteger biid = (BigInteger) q.getSingleResult();
long id = biid.longValue();
long lastId = ((BigInteger) entityManager.get().createNativeQuery("SELECT LAST_INSERT_ID()").getSingleResult()).longValue();
请注意,这是一个代码片段,它的作用是获取最后插入的记录的ID值。 - Austin Cary