reading from view and insert/update to table?possible?

vish · **Posted:** Tue Sep 21, 2004 2:15 pm

2.1.5, 4.8.2004

Is it possible to populate a mapped object from a view but insert/update to the table.

The view and table would have same columns and type and the mapping same for both view and the table.

Any help or directions would be helpful.

Thanks
Vish

michael · **Posted:** Tue Sep 21, 2004 6:40 pm

No thats not possible (easily), at least not in Hibernate2 - Hibernate3 you could just define your own SQL for CRUD operations. Can't you just make the view updateable?

vish · **Posted:** Wed Sep 22, 2004 8:45 am

Thanks for replying Michael.

I can't .. the view is the union of two different tables. One table just consist of ids and foreingn keys to other tables. The second table is composed of names doesn't have any foreign keys.

So the view resolves the ids (foreign keys) to names and unions with the second table.

So if I make view updateble, it may add records in both the tables.

If its not possible, is there any hack I can use ?

christian · **Posted:** Wed Sep 22, 2004 8:46 am

Search for "INSTEAD OF" triggers.

vish · **Posted:** Wed Sep 22, 2004 9:05 am

search in the forums or at database level ?

vish · **Posted:** Wed Sep 22, 2004 9:10 am

I did some reading on that .. i guess my database guys are not going to like that :(

Is there any other possible way before i make 2 mapping one for view (select only) and other for the table ( that gets insert/update)