How hibernate retrieve data from existing database view?

Question

I'm new to hibernate. My problem is that I have an Oracle database. I have a view in the database. Now I want to use hibernate to retrieve data in that view. Is there any possible solutions?

Answer 1

we can achieve this by using @ Immutable annotation in entity class to map database view with Hibernate

For example : I have created one database view user_data which have 2 columns (id and name) and mapped user_data view in the same way as database tables.

@Entity
@Table(name = "user_data")
@Immutable
public class UserView {

    @Id
    @Column(name = "ID")
    private int ID ;

    @Column(name = "NAME")
    private String name ; 
}