Hello!

I have a problem to convert hql query to criteria query
HQL query:



it quite easy for associated classes (User and Group in my case) - you just create subcriteria and add expressing.
But i have NO ASSOCIATION between classes.
How can i write such criteria?

Thank you!

or even more- how to write Theta-style join criteria query for hql query like


Except from Hibernate in Action

Hey fuzebest

I have got nearly the same problem. I my design I associate classes via id like:

class Item
id:Long
name:String

class Bid
id:Long
itemId:Long
amount:BigDecimal

Where the Bid::itemId is a foreign-key to Item::id in database.

My problem is how do I/ can I make a serch criteria which joins the two classes?
Something like?

List result = session.createCriteria(Bid.class)
.createAlias("items", "ITEM").
.add( Expression.eq( "ITEM.id", "42" ) )
list();

Where do I tell the criteria the association between the table ITEM and BID? Can it be done in the creiteria it self or is there a way to put the association in the hbm file?

that is not supported

Thanks for the fast and prompt reply and I promise to be more carefull with typing correctly. I will have to implement the search in plain SQL then to work around the join-in-criteria-problem.

Do Hibernate have plans for such a feature in the future? Could come in handy when implementing Hibernate to support new features where Hibernate entities have to interact with non hibernated entities in existing systems running a different strategy towards the database.

This makes no sense. Hibernate would still need to know about these other entities.

and there are no support for Theta-style joins either?