Fetching data from a Database Vew with no primary key

baskaralingam · **Joined:** Thu Nov 04, 2004 9:41 am **Posts:** 1

I have a Database View based on multiple tables . I can't have a primary key for a view(since it is virtual). I map through composite key. When I try to fetch data from the Database View using 'distinct' clause, I get only first record of every group but repeated n times(i.e total no of rows of that group)
1.view contains the following records (e.g)

AREA CITY ZIPCODE
-----------------------------------
A CHENNAI 600001
X BANGALORE 500002
B CHENNAI 600004
B MUMBAI 400003
Z MUMBAI 400002
C CHENNAI 600002

Help me out in fetching data from the above view which has no primay key. (Take care that all the column values can be repeated)
My HQL will be: select distinct ... from ...

Also provide me a generalized solution to map any Database View which has no primary key
Also provide me the mapping file(.hbm)

emmanuel · **Posted:** Sat Nov 06, 2004 7:08 am

Quote:

(Take care that all the column values can be repeated)

So this is not really an composite PK. You can't associate them to the session.
What you can do is

Code:

select new MyObject(view1.name, ...) from View view1