Hibernate Community • View topic - Need help from seniors on Hibernate Criteria Join

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Need help from seniors on Hibernate Criteria Join

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

jagpreetsingh83

Post subject: Need help from seniors on Hibernate Criteria Join

Posted: Thu Nov 12, 2009 7:13 am

Newbie

Joined: Sat Jun 27, 2009 12:20 am
Posts: 1

Hi,

I have two tables related with one - to - many association (One Invoice can have many Invoice States).

INVOICE (invoiceNum(PK),amount, date) and INVOICE_STATE (id(PK),invoiceNum, type, value)

The join is based on invoiceNum. I need all the invoices from table Invoice having type = "INVACC" and value = "2BP".

I tried following but i get all the results :(

Code:

        return getSession().createCriteria(Invoice.class).createCriteria("invoiceStateList", "state").add(
                Expression.eq("state.type", "INVACC")).add(
                        Expression.eq("state.value", "2BP")).list();

Please help.

Top

Rober2D2

Post subject: Re: Need help from seniors on Hibernate Criteria Join

Posted: Thu Nov 12, 2009 11:32 am

Beginner

Joined: Tue Oct 30, 2007 7:57 am
Posts: 47

You may try this. You create the inner criteria, and add conditions to it. Then execute list() over the outer criteria