Swap Table for Database view: Possible?

javamac · **Joined:** Mon Feb 16, 2004 11:28 pm **Posts:** 16

Hibernate version: 2.1.6

Is it possible to treat a database view in oracle as if it's a table to hibernate? Basically I want to create a view for a complex legacy database(read only) and use it in HQL queries. Is this possible to just specify the columns that are present in the view and in the class element of the mapping specify the view name where table name goes?

Thanks

max · **Posted:** Mon Mar 28, 2005 10:10 am

yes a view is accessed in jdbc the same way as a table - no diff for hibernate.

why dont you just try it ? ,)

javamac · **Joined:** Mon Feb 16, 2004 11:28 pm **Posts:** 16

I have tried it but Im running into some errors. I was wondering if it was even possible before looking into it further :)

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

you have to make id - choose all view's columns if you doesn't know id for view

regards