I've gotten confused about what I thought was implicit in Hibernate...

If I have a table of books with types:

Title BookType
About cats non-fiction
About rats non-fiction
About tats fiction

I then normalize it so that the types link to another table, type-table:

ID BookType
1 non-fiction
2 fiction

Then the book table is

Title BookType
About cats 1
About rats 1
About tats 2

I create classes

public class Books {
private String title;
private BookType type;
...
}

public class BookType {
private int id;
private String booktype;
...
}

I create an HBM mapping for Books with
<property
name="title"
type="string"
column="Title">
</property>

<many-to-one name="booktype"
class="model.Books"
column="category" />

and a mapping for BookType with
<property
name="id"
type="integer"
column="id">
</property>

<property
name="booktype"
type="string"
column="booktype">
</property>

Now, I am expecting that a Books object will automatically have the BookType filled in. Finding all books should do that:

List books = session.find("from Books");
System.out.println(books.get(0).getType()) should be "non-fiction".

I've confirmed that I can get that to work.

Now I'm confused about finding all of one type:

List fiction =session.find("from Books as book where book.type='fiction'")

I expected that the booktype would already be filled in which what it
refers to so that I could search on the text and not have to explicitly do a join. Isn't that how it works?

Do I have to do a join, or a where someting = something-else?

Hope this makes sense. The code may not be precise in my example. Sorry.

==Leonard

You can only use the . navigation in querys for one ended associations. To do what you want use