I want to create one mapping document(hbm) for subselect(or view) which doesn't have unique identifier.How do i do this?

What is been done for above question?
--------------------------------------------
Map one non unique column (from view) to <id>

Result:
--------
When the duplicate value comes for that column(which is mapped to id) then the hibernate used first level cache(session) to fetch the record.

Note : When duplicate values comes for <id> column hibernate automatically treat it as same record, so fetch from first level cache(session)

What is Required?
--------------------
1. I want to supress the duplicate record which is fetched from session(cache).
(or)
2. Fecth the two(same value for id column) record as different.

Thanks in Advance,
Shanmugam

Shanmugam,

So you have a class C { Integer id; String somedata } that is mapped to a table in the database. The table contains multiple records for the same ID and you want to be able to read them all in memory.

Is this correct?

If so then you can either add a synthetic ID to the table or use a composite ID if id+somedata uniquely identify a row.

Please add more details if the above does not help :)

Marius