Does Hibernate work with Database Views?

nohwal · **Joined:** Thu Dec 09, 2004 7:41 am **Posts:** 4

Hibernate version: ANY

Name and version of the database you are using: Postgres

Hi,

Is anyone aware if Hibernate works with DB views and how? If you can point me to an example then it would be great.

Thanks.
+Deepak.

michael · **Posted:** Thu Dec 09, 2004 7:55 am

Just map to it like a normal table.

nohwal · **Joined:** Thu Dec 09, 2004 7:41 am **Posts:** 4

Thanks Michael for the prompt response. However, I guess I have stated my question incorrectly. Let me try to put the question in place.

I have to execute a monster query which will have links between multiple tables (abt 5-6 tables). Executing it using HQL may not be a good idea. Hence it was suggested that I should create a view to help us running queries on that model. My question is how can Hibernate help in this type of situation?

michael · **Posted:** Thu Dec 09, 2004 8:05 am

I dont get what you are talking about. Just create your view and map an object to it.

anthony · **Posted:** Thu Dec 09, 2004 8:24 am

Quote:

I have to execute a monster query which will have links between multiple tables (abt 5-6 tables). Executing it using HQL may not be a good idea. Hence it was suggested that I should create a view to help us running queries on that model. My question is how can Hibernate help in this type of situation?

1- be sure you cannot do it in hql, give an example to see why hql cannot solve your query.
If you aren't able to execute this query in hql, maybe that mean that this query isn't oo which isn't bad. But in this case why don't you use a stored procedure and call it in a DAOJBDC method?

2- if you simplify this query using a view and really want to use this view with mapped objets, just map an object to it, what is difficult?