Mapping JPA Entity to View Object
727941Oct 26 2009 — edited Oct 26 2009Hi,
I want to map JPA entity to view object. In detail: I have extracted data from DB and placed it into view object (ADF Business Component). Now I want to map this view object to JPA entity, so when I want to manage data I have to do it via JPA entity.
More detail:
I have 10 tables in my database. All of them are presented in my model as JPA entities so I could work with it (create data controls and drag and drop it to the page). Beside this, I have one complex query written in plsql (uses case) which result I need to display in table (ADF component). There are several ways to do this, but the easiest one is to create view object and then create data controls out of it.
Now, that big BUT: this is ok for me, cause I can do everything I want, but my superior wants to have JPA entity that represent that view object (consistency of architecture). I could make view in database and then just create JPA entity, but I can't do this cause the query have some parameters
Is this even possible and how can I do it?
Thanks!