Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VO Joining 2 EOs: Conditionally updating only 1 EO.

User757151-OracleOct 31 2012 — edited Nov 2 2012
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.
This post has been answered by Cvele_new_account on Nov 1 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2012
Added on Oct 31 2012
7 comments
277 views