Get all updates of Java4s
Follow Us: Email Newsletter

Example On Hibernate Criteria With Multiple Projections

Hibernate » On Jul 13, 2011 { 12 Comments } By Sivateja

If we want to load partial object, with multiple columns using criteria then we need to create the ProjectionList with the multiple properties and then we need to add that ProjectionList to the criteria

files required…

  • Product.java(POJO class)
  • Product.hbm.xml
  • hibernate.cfg.xml
  • ForOurLogic.java (For writing our business logic)

 

Product.java

Product.hbm.xml

hibernate.cfg.xml

ForOurLogic.java

Notes:

  • See line numbers 27,28,29, for using multiple projections we must create this ProjectionList object then we have to add all of our projections to ProjectionList, then finally add this ProjectionList object to criteria (see line number 31)
  • Now see line number 39, Finally we have to typecast into object array
  • Remember, we have to typecast into our pojo class type if we load complete object from the database,  we have to typecast into that property type if we load partial object (single column), we have to typecast into object array if we load partial object (more than single column)

hibernate projections, hibernate multiple projections, example on hibernate projections, projections in hibernate,

You Might Also Like

  ♦ About Author ♦

Java4s_Author
sivateja@java4s.com
Full Stack( Java/J2EE & UI/UX ) Developer and founder of Java4s - Get It Yourself, A popular Java/J2EE Programming Blog. Sign-up for the Email Newsletter for your daily dose of Java tutorials.

Comments

12 Responses to “Example On Hibernate Criteria With Multiple Projections”
  1. Raju Kapadne says:

    hi java4s team ,
    u have given excellent explaination . i got it , thanks a lot .

  2. vimal says:

    can you please send some interview questions based on “versioning in hibernate” ………..

  3. Anasuya says:

    Please give some real time interview questions on Hibernate…
    Thanks a million for the good tutorial…

  4. Tipu Swain says:

    Hi Dude,

    Really brilliant explanation.

    Thanks a lot.

  5. Don says:

    Easy to understand Thanks for sharing

  6. karthick says:

    u r really genius …best explanation…:)

  7. karthick says:

    nice tips in the remember section…..

  8. appesh says:

    Insted of Iterating Object we can type case into Specifed Object eg: p1.add(Projections.property(“price”).setResultTransformer(Transformers.aliasToBean(XXXX.class));

  9. Evyavan says:

    First of all let me say that the post is a nice one. I am here. shamelessly, to ask for a helping hand. I need to figure out something and if you can and time permits please give me an answer for this question. http://stackoverflow.com/questions/27099693/will-aliastobean-work-when-a-dto-has-a-list-of-another-dto-and-fields-set-with

    I am 95% sure this cannot be done how I have coded it, but I sure hope there is a way around. Please excuse my ignorance as I am still learning the ropes of hibernate.

  10. srikanth says:

    I thought, found one bug in this post or i did not understand properly.

    In previews example (adding one prjection to criteria) used below statement,
    crit.setProjection(Projections.property(“proName”));
    i.e, crit.setProjection() with action one Projections object.

    Now, again you used same criteria method to add projectionList like below

    ProjectionList p1=Projections.projectionList();
    p1.add(Projections.property(“proName”));
    p1.add(Projections.property(“price”));

    crit.setProjection(p1);

    p1 is projectionList one projections, so how this crit.setProjection() method accept that,

    This is my doubt.

  11. shgy says:

    Thanks!
    Very nice Article!

  12. suryas says:

    I have learnt hibernate f/w with your articles.
    it is too good.heartly thanksful to you.

Name*
Mail*
Website



By posting your answer, you agree to our comments policy.
What would you like to learn today?
Browse these popular technologies
Hibernate spring struts Servlets ajax Log4j jQuery Json Core Java Web Services AngularJs
Most Recent Tutorials
Hibernate_Logo Hibernate Recent Posts Spring_Logo Spring Recent Posts Struts_Logo Struts Recent Posts
Useful Links Current & UpComing Tutorials
Upcoming
  Web Services [ SOAP ], JSP
Contact | About Us | Privacy Policy | Advertise With Us

© 2010 - 2016 Java4s - Get It Yourself.
The content is copyrighted to Sivateja Kandula and may not be reproduced on other websites.