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