Tutorial :Can javax.persistence.Query.getResultList() return null?



Question:

And if so, under what circumstances?

Javadoc and JPA spec says nothing.


Solution:1

You are right. JPA specification says nothing about it. But Java Persistence with Hibernate book, 2nd edition, says:

If the query result is empty, a null is returned

Hibernate JPA implementation (Entity Manager) return null when you call query.getResultList() with no result.

UPDATE

As pointed out by some users, it seems that a newest version of Hibernate returns an empty list instead.


Solution:2

If the specs said it could't happen, would you belive them? Given that your code could conceivably run against may different JPA implementations, would you trust every implementer to get it right?

No matter what, I would code defensively and check for null.

Now the big question: should we treat "null" and an empty List as synonymous? This is where the specs should help us, and don't.

My guess is that a null return (if indeed it could happen) would be equivalent to "I didn't understand the query" and empty list would be "yes, understood the query, but there were no records".

You perhaps have a code path (likely an exception) that deals with unparsable queries, I would tend to direct a null return down that path.


Solution:3

Contrary to Arthur's post, when I actually ran a query which no entities matched I got an empty list, not null. This is using Hibernate and is what I consider correct behaviour: an empty list is the correct answer when you ask for a collection of entities and there aren't any.


Solution:4

Of course, if you test the result set with Jakarta's CollectionUtils.isNotEmpty, you're covered either way.


Solution:5

If you take a close look at the org.hibernate.loader.Loader (4.1) you will see that the list is always initialized inside the processResultSet() method (doc, source).

protected List processResultSet(...) throws SQLException {     final List results = new ArrayList();       handleEmptyCollections( queryParameters.getCollectionKeys(), rs, session );     ...     return results;    }  

So I don't think it will return null now.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »