O'Reilly logo

Java Hibernate Cookbook by Vishal Ranapariya, Yogesh Prajapati

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Performing aggregate operations

Next to the common SQL databases, hibernate allows us to perform an aggregate operation using a hibernate API. We can perform an aggregation operation such as sum, avg, min, max, count, and so on.

We will discuss the use of some aggregate functions by example.

Getting ready

To perform an aggregation operation, we will consider a predefined table structure with the data so that it's easy to understand how the aggregate functions work.

The predefined table and class structure we mentioned earlier can be found in two different classes, product and category, with their relationship. The following code and script can be used to create a Java class and a database table.

Creating the tables

Use the following script to create ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required