Hello,

For my question I'll first explain a test environment:
- Two tables: "users" and "groups"
- One MySQL view: union of "users" and "groups" named "mailaddresses"

I use this view to give people a list of all addresses an e-mail can be sent to. That includes users and they can be sent to groups.

I don't know of a way to do this nicely in JPA and so I just created an entity MailAddress and removed the underlying table and replaced it with a view. Problem is that hibernate keeps on trying to update the schema of this entity. But is is a view and so I get the errors:


There are two possible ways of solving this (for which I don't know how to do that):
- Use something in JPA/Hibernate to make the union
- Disable SchemaUpdate for this specific Entity and leave it on for all others

Any advise?

Thanks,
Milo

Worked around it by using a named native query. Together with @Loader this solved my problem. Could be simpler but at least I got rid of the error messages.