File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 10289
    
168

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: http://aspose.com/file-tools
 
subject: View instead of Table