Hi,

For my current project i want to retrieve some data from a database view and show it to the user. I want to know whether i can do it with the help of hibernate.


the problem is in the view there is no column with a primary key or unique key, so i can not assign a <id> property in the hibernate mapping file.


If somebody can tell me how to map to a database view without the use of <id> property in the mapping file?


Thanx.

Use composite-id as in
http://www.hibernate.org/hib_docs/v3/re ... ompositeid

But take care, especially when doing "join" with this composite-id, there are some known limitations.

However, best way when possible, is to add a column to the view using for instance concat( col1, col2), assuming col1 and col2 are enough to determine a unique row.