hibernate mapping a view no primary key

[andy kumar]

I have a view which comprises of joining 4 table and it does not have a primary keys, this view is just used for display purpose. I want it to be managed by hibernate, I did some search and found that it is not able to have a view mapped to a pojo with out a primary key, one solution is to create a composite key with all the columns in the view and then use @Embeddable annotation, I did this and it worked fine for me. But is there a way to tell hibernate that this POJO is a select only kind of POJO and I will never do a insert/update so no need of a primary key. Or are there any other options that I can try. thanks

[Arun Kumarr]

Andy, Did you take a look at "ResultSetTransformers" in Hibernate.
Check for some examples here.

[robert walker]

one way to accomplish this is to use constructor expression in your JPQL, so for example, you could do a

 
List result =
em.createQuery("SELECT NEW example.EmpMenu(e.name, e.department.name) " +
"FROM Project p JOIN p.employees e " +
"WHERE p.name = ?1 " +
"ORDER BY e.name")
.setParameter(1, projectName)
.getResultList();

in this example, example.EmpMenu class does not have to be an entity, it can be just a pojo, it must have proper constructor to match the constructor expression
in the JPQL.