View instead of Table

[Xavier George]

I am planning to use database View instead of base table. I know there will be problem with insert/update with view (depends how view is ceated).
But, I want to use view only for select and not for insert/update/delete.

Does Hibernate place any restriction using Database Views instead of Table?

[Jaikiran Pai]

Does Hibernate place any restriction using Database Views instead of Table?

We have been using views with Hibernate without any issues.
[ August 04, 2006: Message edited by: jaikiran pai ]

[Ghulam Rashid]

View can be used in hibernate without issues, TRUE. But, I beleive its more appropriate for SELECT and not for INSERT/UPDATE/DELETE. Again, it all depeneds how view is created.