im trying to get all the users who have a specific book

i tryed all sorts of ways but i cant get anything but errors

i would think that something like
"from User u where u.bookshelf.booklines.book.isbn = 2222"

would work but i dosent.

a user have a bookshelf that contains booklines that contains a book

please help me get on from here


Mapping documents:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping package="dk.bytenbog.model.businessobject">
<class name="User" table="USER">

<id name="username" type="string" column="user_id">
<generator class="assigned"/>
</id>
<property name="password" type="string" column="password"/>
<set name="messages" table="MESSAGES">
<key column="user_id"/>
<composite-element class="Message">
<property name="type" type="string" />
<many-to-one name="book" class="Book" />
<many-to-one name="user" class="User" />
</composite-element>
</set>

<component name="bookshelf" class="Bookshelf">
<set name="booklines" table="BOOK_LINES" cascade="all">
<key column="user_id"/>
<composite-element class="Bookline">
<many-to-one name="book" class="Book">
<column name="isbn"/>
</many-to-one>
<property name="date" type="date" column="date"/>
</composite-element>
</set>

</component>
</class>
<class name="Book" table="BOOK">
<id name="isbn" type="string" column="isbn">
<generator class="assigned"/>
</id>
<property name="title" type="string" column="title"/>
</class>
</hibernate-mapping>

I am not sure but I think you need to include this in quotes since the isbn is a string hence not anythin about your design reqts, is should be isbn='2222'

Hope this works !!!