Using Views instead Tables

Michel777 · **Joined:** Fri Jul 04, 2008 7:52 am **Posts:** 8

is it possible to use database views for maping instead tables ?

twentyseven · **Joined:** Fri May 14, 2004 9:50 am **Posts:** 28

Extract from the Hibernate doc "There is no difference between a view and a base table for a Hibernate mapping, as expected this is transparent at the database level (note that some DBMS don't support views properly, especially with updates). "

You can directly use the configuration of a table with a view.

Cameron McKenzie · **Posted:** Mon Jul 14, 2008 10:34 am

Indeed, mapping to views is supported!

Cameron McKenzie · **Posted:** Mon Jul 14, 2008 10:37 am

If you're not updating or creating new rows in the view, you can simply map an entity to it. That's usually the easiest thing to do.

And while views don't have primary keys it is very easy to define a view that has a surrogate key. I'd recommend this to easy the pain of mapping it.

Here's some info from Hibernate.org:

Quote:

Does Hibernate support database views?

Of course. From the point of view of Hibernate, a view is just like any other table (except that you might not be able to update or insert to a view). You can easily map a class to a view by specifying table="view_name".

In Hibernate3, you may even map an entity class to a SQL query result set using the <subselect> mapping element. This is useful if you are unable to define new views in your database.

Using Hibernate and Database Views