# Hibernate Projections Introduction

So far in criteria, we are able to load complete object right….! let us see how to load the partial objects while working with criteria. The projections concept is introduced in hibernate 3.0 and mainly we can do the following 2 operations using the projection

- We can load partial object from the database
- We can find the Result of Aggregate functions

*Projection* is an Interface given in “org.hibernate.criterion” package, *Projections* is an class given in same package, actually Projection is an interface, and Projections is an class and is a factory for producing projection objects.

In Projections class, we have all static methods and each method of this class returns Projection interface object.

If we want to add a Projection object to Criteria then we need to call a method **setProjection()**

**Remember**, while adding projection object to criteria, it is possible to add one object at a time. It means if we add 2nd projection object then this 2nd one will overrides the first one (first one wont be work), so at a time we can only one projection object to criteria object.

Using criteria, if we want to load partial object from the database, then we need to create a projection object for property that is to be loaded from the database

**Example:**

1 2 3 4 5 6 7 8 9 |
Criteria crit = session.createCriteria(Products.class); crit.setProjection(Projections.proparty("proName")); List l=crit.list(); Iterator it=l.iterator(); while(it.hasNext()) { String s = (String)it.next(); // ---- print ----- } |

If we add multiple projections to criteria then the last projection added will be considered to execute see…

**Example:**

1 2 3 4 5 6 7 8 9 10 |
Criteria crit = session.createCriteria(Products.class); Projection p1 = Projection.property("proName"); Projection p2 = Projection.property("price"); crit.setProjection(p1): crit.setProjection(p2): List l=crit.list(); -------------- ---- ------- - --- ---- |

Here collections list l, is going to contain the price in the form of Double objects, but product names are over ridden, second projection over rides the first one, i mean p2 only will works p1 will not works, actually there is a way to add multiple projections to criteria to select more than one column from the database i will tell you in the next example

Excellent information

Hi Java4s,

Actually partial objects means fetching some of the columns from table instead of fetching all. That is what you mean to say right!

here in 2nd case..it should be like pojections.property(“proName”)

or projection.property(“proName”)

because property is a static method of Projections class

do help me out on this

spelling mistake at

crit.setProjection(Projections.proparty(“proName”));

that is property not proparty

In the 2nd example, on 3rd and 4th line i have noticed a mistake. Kindly change it @SivaTeja sir.

Instead of,

Projection’s’.property(“proName”);

Projection’s’.property(“price”);

you have used,

Projection.property(“proName”);

Projection.property(“proName”);

Your tutorial is really interesting. All the best

We cannot create objects to an interface. Pls explain what the projections class return then and how?

Good Explanation. and good Example.