VO Joining 2 EOs: Conditionally updating only 1 EO.
I've got a View Object that joins 2 DB tables/EOs, primarily to display joined data in an ADF Faces table.
However, I now have a user request to be able to update the joined data. The user would have the option of updating data that would go into either or both of the DB tables.
Now, let's say that in a given ADF Faces table row, a user updates data that goes into DB Table A, but leaves the DB Table B data untouched. It appears that when the task flow's Commit operation executes, the framework commits data to both DB Table A and B. That's not functionality I can introduce to our application - without going into detail, it has to do with the BEFORE UPDATE and AFTER UPDATE DB triggers.
So, is there a way to either configure or code so that the update occurs only upon the DB Table for which data was actually changed? in other words, in the example above, since no data for Table B was changed, I'd like the DB to be updated only for Table A.
i know an alternate approach is just to not use the joined VO; however, it'd be much more productive if there's a way to do so, hence the question.
Am using 11g.
Thanks for your help.