[OPENJPA-208] NoResultException and NonUniqueResultException are not thrown when expected

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.6
• Fix Version/s: 0.9.7
• Component/s: jpa
• Assignee: Marc Prud'hommeaux
• Reporter: Marc Prud'hommeaux
• Created: 06/Apr/07 22:25
• Updated: 09/Mar/10 18:32
• Resolved: 09/Apr/07 17:06

Description

When calling Query.getSingleResult() on a query that either has no result or multiple results, either a NoResultException and NonUniqueResultException (respectively) should be thrown in accordance with section 3.6.1 of the JPA spec. Instead, we appear to throw a org.apache.openjpa.persistence.InvalidStateException:

org.apache.openjpa.persistence.InvalidStateException: The query on candidate type "class com.sun.ts.tests.ejb30.persistence.query.apitests.Department" with filter "select d.name from Department d where d.id > 1" was configured to have a unique result, but more than one instance matched the query.
at org.apache.openjpa.kernel.QueryImpl.singleResult(QueryImpl.java:1282)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1207)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:982)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:791)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:761)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:757)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:514)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:225)
at org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:287)