Hibernate multiselect with groupBy count Example
As multiple hibernate 5 API’s like createSQLQuery, Query and createCriteria deprecated, I have provided the below snippet which performs the multiselect with groupby count using Hibernate latest API’s.
Table of Contents
Multiselect in hibernate criteriaQuery
criteriaQuery.multiselect(Store.get("storeType"),criteriaBuilder.count(StoreRoot));
groupBy in Hibernate criteriaBuilder
criteriaQuery.groupBy(storeRoot.get("storeType"));
count in Hibernate criteriaBuilder
criteriaBuilder.count(StoreRoot);
Hibernate multiselect with groupBy count – Code Snippet
// if you have different way to get the session, just replace that with this line.
Session session = entityManager.getSession();
CriteriaBuilder criteriaBuilder = session.getCriteriaBuilder();
CriteriaQuery<Object[]> criteriaQuery = criteriaBuilder.createQuery(Object[].class);
Root<Store> storeRoot = criteriaQuery.from(Store.class);
criteriaQuery.multiselect(Store.get("storeType"),criteriaBuilder.count(StoreRoot));
criteriaQuery.groupBy(storeRoot.get("storeType"));
List<Object[]> result = session.createQuery(criteriaQuery).getResultList();
DreamJili21 is my go-to spot for a quick game after work. Keeps me entertained, that’s for sure! Give it a try! dreamjili21
I’ve been trying a few sites lately and this one really stands out. The interface is smooth and the payouts are fast. Definitely recommend checking out plataforma7brwin if you want a reliable spot.
Everything about this site screams quality. From the graphics to the overall flow, it is just a top notch experience. brricabet
The APK installation was a breeze. I was worried about the setup but it worked perfectly on my Android phone. Great experience so far. Get it at jeetbuzzdownloadapk
Best platform I have used in the Philippines so far. The variety of games is impressive and the payouts are fair. Give phbcgame a try, you won’t regret it.