Changed behaviour of getSingleResult?

[heinrich]

Hi,

i have a question concerning the method "getSingleResult()".
The intended behaviour of the method was up to today, that if the underlying query returns more than one result, the mthod returns the first of them.
Only in case of no results, a NoResultFound Exception is thrown.

But, as we found out today, when there are at least two results we get a NonUniqueResultException.
Is this new? Our JBoss is 4.0.5-GA.
And why can't this method just behave as expected?

the workaround would be

 em.createQuery("SELECT Object(o) FROM MyEntity o").setMaxResult(1).getSingleResult();

any ideas?


martin

[colineberhardt]

I cannot comment on what the behaviour was preior to the latest version of JBoss. However it would appear that it is currently operatibng as per the spec:

http://java.sun.com/javaee/5/docs/api/javax/persistence/Query.html#getSingleResult()

Therefore it is behaving as expected!

Regards,
Colin E.

[mbrunnert]

I have also notice a diffrence. For results containing only one null result, the old version thew a NoResultFoundException, but 4.0.5GA doesn't. Is this behaviour also expected?