This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "View instead of Table" Watch "View instead of Table" New topic
Author

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
Marshal

Joined: Jul 20, 2005
Posts: 9957
    
163

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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: View instead of Table
 
Similar Threads
Merge statement for merging data of tables from two different databases
Is it Possible...
Enabling links according to user's authorization
Can I use prep.execute to update a record?
Choice of Implementation