Message Title

Marko Bekhta created an issue

HHH-12040

Issue Type:	Improvement
Assignee:	Unassigned
Created:	18/Oct/2017 09:10 AM
Labels:	criteria
Priority:	Trivial
Reporter:	Marko Bekhta

Found that when creating a `CriteriaQuery` with having clause that has a parameter in it and with missing `groupBy` ambiguous `NullPoinerException` is thrown. Like for example:

 
                                                                Root<Event> event = criteriaQuery.from( Event.class );
ParameterExpression<Long> minAttendeesCount = cb.parameter( Long.class, "min_attendees_count" );
criteriaQuery.select( event.get( "type" ) )
	.having( cb.ge( cb.sum( event.get( "attendees" ) ), minAttendeesCount ) );

session.createQuery( criteriaQuery )
	.setParameter( minAttendeesCount, 2L )
	.getResultList();
 
                                                            

In my case a query was bigger and it took me a while to figure out what the problem really was. Stack trace of current behavior in such situation as above is next:

 
                                                                java.lang.NullPointerException
	at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.setParameter(CriteriaQueryTypeQueryAdapter.java:375)
	at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.setParameter(CriteriaQueryTypeQueryAdapter.java:57)

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira