Hi

Trying out my HQL against a one-to-many and not having much luck. I'm trying to select all the 'messages' for a given 'MessageStore'. The message has a FK column called inbox_id pointing back to the MessageStore table.

My Hib' querry is (which does work):
from net.simtext.server.core.domain.Message as message where message.id>? and message.inbox_id = ?

My SQL querry which does what I want would be:
SELECT * FROM `message` where inbox_id = ?;

The exception is:
net.sf.hibernate.QueryException: could not resolve property: inbox_id of: net.simtext.server.core.domain.Message [from net.simtext.server.core.domain.Message as message where message.id>? and message.inbox_id = ?]

My mapping is:
<hibernate-mapping>
<class name="MessageStore" table="message_store" >
<id name="id" column="id" type="long" unsaved-value="0">
<generator class="native"/>
</id>

<list name="inboxMessages">
<key column="inbox_id" />
<index column="position"/>
<one-to-many class="Message" />
</list>
...

</class>
</hibernate-mapping>

<hibernate-mapping>
<class name="Message" table="message" >
<id name="id" column="id" type="long" unsaved-value="0">
<generator class="native"/>
</id>

<property name="text" type="string" length="320" >
<meta attribute="use-in-tostring">true</meta>
</property>

...

</class>
</hibernate-mapping>


Hib 2.1.4
MySQL 4.0.18

Hope you can help

Cheers

Nick

Sorry, that should read


My Hib' querry is (which does NOT work):
from net.simtext.server.core.domain.Message as message where message.id>? and message.inbox_id = ?