Hello Hibernate users.

I need to do a search across several tables, lets call them A, B and C.

heres a pseudo database structure:



in jdbc sql I might write something like



Obviously I'd parse my result set and create my objects for A.

Now I'd like to do the same thing in Hibernate, but I don't know where to start.
If necessary I can create some tables, hbm.xml files, etc - but at this stage it would just complicate this post.
I'm sure this must be possible, I really just need a pointer or two.

Thanks

Martin

The tutorial in the Hibernate documentation is a good place to start: http://docs.jboss.org/hibernate/stable/ ... orial.html

So I do actually have Hibernate working for quite a few things.....I'm past the basic tutorials.
Selects using Hibernate Querys, inserts, updates, etc.
I'm just not sure how to go about a complicated join.

Do I do something like this?

If you have mapping files you'll need to post them. It is hard to help you otherwise.

Edit: There is a chapter about HQL in the documentation also: http://docs.jboss.org/hibernate/stable/ ... yhql-joins

Actually my crazy little joins seem to work...I was so sure that it would be hopeless and that it couldn't be that easy.

Another question, lets say I want to perform a query like this:



Can I do that?
Then somehow call a setCollection method?


or do I have to convert it into a string in the query first? or create a lot of



I haven't had any success so far....I had this same problem with JDBC too.
This can also get quite complicated if the id is a complex object - not just a simple object (like a string).

I'd appreciate any help here too.

The first example is the close... You need to use named parameters in the query.



Then, set the values with Query.setParameterList("list", thisIsMyCollection). This works as long as the collection of values is not empty. If it is empty, the where part of the query should be removed.

Ahh Thanks - that will make my life much easier!