Little problem with a criteria

Flash31186 · **Joined:** Thu Dec 21, 2006 11:01 am **Posts:** 12

So, I have a problem with my criteria

There are 2 classes : Request and Enterprise

Request :
private Integer idRequest;
private Enterprise enterprise;

Enterprise :
private Integer idEnterprise;
private String enterName;

I would like to make a criteria to find the Request id from the Enterprise id.

Code:

Criteria criter = this.Session.createCriteria(Request.class).createCriteria("enterprise").add(Restrictions.eq("idEnterprise", new Integer(idEnter)))

This is the code that I make but it return nothing ! Whereas there is a lot of record in the db ...

Thanks

fortknox · **Joined:** Sun Nov 16, 2003 3:04 pm **Posts:** 24

Turn on 'showSQL' and post the sql being generated. A great way to debug hibernate queries...

batmat · **Posted:** Wed Jan 03, 2007 5:04 pm

Flash31186 wrote:

I would like to make a criteria to find the Request id from the Enterprise id.

Code:

Criteria criter = this.Session.createCriteria(Request.class).createCriteria("enterprise").add(Restrictions.eq("idEnterprise", new Integer(idEnter)))

fortknox is right. You should activate the show_sql property to debug those kind of problem.

Regarding your query, when comparing ids, use the idEq() method instead. Maybe that's the problem.

Flash31186 · **Joined:** Thu Dec 21, 2006 11:01 am **Posts:** 12

Oh right ! I didn't know this property, I'll try it ...

Flash31186 · **Joined:** Thu Dec 21, 2006 11:01 am **Posts:** 12

oh ... sorry it's an error when I acquire the enterprise id... but now I know that my query is right ... and the 'show_SQL' property is a very good thing !

thanks for your replies !