This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes View instead of Table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "View instead of Table" Watch "View instead of Table" New topic

View instead of Table

Xavier George
Ranch Hand

Joined: Jul 29, 2005
Posts: 39
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

Joined: Jul 20, 2005
Posts: 9915

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 ]

[My Blog] [JavaRanch Journal]
Ghulam Rashid
Ranch Hand

Joined: Jan 14, 2002
Posts: 278
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.
I agree. Here's the link:
subject: View instead of Table
Similar Threads
Is it Possible...
Enabling links according to user's authorization
Can I use prep.execute to update a record?
Choice of Implementation
Merge statement for merging data of tables from two different databases