suppose I have

class A : Long id, B b

class B: Long id, String name

table A: ID

table B: ID, A_ID, Name

where A_ID is the foreign key references A.

here I want to move from class A with a lazy loading of matched B object
session. find("Select from A");


mapping filez:
<class name = "A" table= "A" ...>
<id.....
</class>

</class name ="B" table "B" ...>
<id.......
</class>

Here in mapping files where and how I have to put one-to-one or many-to-one association to load A objects and matching B's(lazy) when I query on A;

session. find("Select new A(a.id) from A a");

will only return the ID column when you do the find and not load the B Object which it wud if you enter ur original query.

Hope this is what u are looking for

Cheers
Raja

No raja, that is not the one I am looking for.
Thanks still

I think that your DB model is not correct : your foreign key should be on table A.

class A : Long id, B b
and class B: Long id, String name

should give the following tables :

table A: ID, B_ID
table B: ID, Name