I am new to Hibernate. I read the document without find the solution for the following scenerio.

I have two tables:
table A_main:
for_date (pk)
keyf (pk)
other columns

and A_sub:
begin_date (pk)
keyf (pk)
end_date
other columns

now I want to create an entity A which is actually a view:
select * from A_main m inner join A_sub s on m.keyf=s.keyf and m.for_date between s.begin_date and s.end_date

The sure thing is that the view to A_main is one-to-one, and table A_sub has far fewer rows than A_main.

how to write A.hbm.xml for this mapping?

My idea is along the line using the following mapping:

...

<class name="A" ...>
.... (columns in A_main)

<many-to-one name="asub" class="A_sub"> (or maybe one-to-one)
<column name="keyf"/>
<formula>
?how to write it?
</formula>
</many-to-one>

But I don't know how to write the formula to represent the "m.for_date between s.begin_date and s.end_date" query string...

Any help? Thanks.

I am newbie, but if I understand you, you could use a named query

<query name="yourQueryName">
<![CDATA[
from A
where keyf=asub.keyf and asub.for_date between asub.begin_date and asub.end_date
]]>
</query>

To test:

Query namedQuery = new Query("yourQueryName")

List list = nameQuery.list()

Sorry, you must replace
asub.for_date between asub.begin_date and asub.end_date

with

for_date between asub.begin_date and asub.end_date

Thanks. Your method is one of the possible solution. But since I'd like to have a java class mapped to this entity, I have to use a hbm.xml mapping.

I kind of solving my problem by create a view with the join and map this view to a java class. Since I only need to fetch the rows, never do remove and update on it directly, it works for my purpose.