Hi,

I have an existing database view that has no primary key. Since <Id> is a manadatory element for <class> in the mapping file, I am not sure of how to map this view. I know that as far as Hibernate is concerned view is mapped in the same way that a table is.

Is there a way to map a view that has no primary key?

Thanks a lot,
Jade.

Jade,

Yes <id> is a mandatory element, still you can assign id to a non-primary key column and mention the generator class as assigned.

HTH,
Raza Naqvi

Sample code

<id name="id" column="any column" type="java.lang.Integer">
<generator class="assigned" />
</id>

Handle duplicate entry exceptions.

HTH,
Raza Naqvi

Hi Thanks for your reply. I am aware that, any column with unique values can be mapped as Id.

But the existing legacy view doesn't have an unique values including compisite id.

So my question is how do we handle when View doesn't have any unique columns including compisite columns?

Thanks,
Jade.