Hi,

Is there a way for using Hibernate to map a class to a view for query and to a table if doing update, delete and insert?

I tried to create two mappings and set the entity-name, however everytime I do a query based on the class it execute the same SQL twice. I cannot simply using entity-name in the Criteria since I have mapping table per subclass.

This is the kind of what i'm trying to do:

MyObject
|- insert (into table my_object)
|- delete (from table my_object)
|- update (table my_object)
|- select (from my_valid_object_view)



MySubclass extends MyObject
|- insert, delete, update, select (from my_subclass_table)

Thanks for any help beforehand

Hello,

did you find any solution for your question? We have a similar problem and so i am interested

Hi there,

I ended up mapping the superclass to my view and create my own <sql-delete> statement



and by having cascade delete I have all the subclass working perfectly on delete.