Current Position:Home > Problem with 2 View Objects based on One Entity -Probably a Bug in ADF BC

Problem with 2 View Objects based on One Entity -Probably a Bug in ADF BC

Update:10-11Source: network consolidation
Advertisement
Hi
I am using JDeveloper 10.1.3(SU5) and adf faces and ADF BC and to explain my problem I use HR schema.
First, I created 2 view objects based on countries table named as TestView1 and TestView2. I set TestView1 query where clause to region_id=1 and TestView2 query where clause to region_id!=1 in the view object editor and then I created 2 separated form on these 2 view objects by dragging and dropping from data control palette.
Now when I insert a record in the form based on TestView1 with region_id set to 1 and commit the record and go to the next form I can see the record in the second form which is completely wrong since it is against the where clause statement of the second form.
I am really confused and the situation is very wired and it seems to me something like bug in adf bc.Am I right.Is there any work around or solution for solving this problem.
Any help would be highly appreciated.
Best Regards,
Navid

The Best Answer

Advertisement
Dear Frank,
Thank you very much for your quick response.
Reading your helpful comments now I have some questions:
1- I have commited the record in the database so shouldn't the query of view objects be re-queried?
2- We try to use ClearVOCaches (entity_name,false) in afterCommit of the base entity object but unfortunately it does not work correctly. after that,We got root app module and used findViewObject method to find all the view of that entity (we have found them by using name not automaticlly) and called executeQuery of all views. From my point of view it has 2 big disadvantages. First suppose that this entity is an important entity and 4 or 5 viow objects are based on it. Now, For inserting one record we should re-execute 4 or 5 view which I think makes some performance issues. Besides, If during the development one programmer add a new view object based on this entity and don't add the executeQuery in the afterCommit for this view, again we have the same problem. Isn't there at least a way that automatically refresh all related view objects however the performance issue still exists.
3- You mentioned that this issue is handled in the developer guide. Could you kindly give me a refrence which developer guide you mean and which section I should read to overcome this problem.(I have ADF Developer's Guide for Forms/4GL Developer's Guide , however I search for clearVOCaches and surprisingly nothing was found!!!)
4- Could you please give me some hints that from your point of view what is the best method to solve this problem with minimum performance effect.
Any comment would be of some great help.
Thanks in advance,
Navid
  • Problem with 2 View Objects based on One Entity -Probably a Bug in ADF BC Update:10-11

    Hi I am using JDeveloper 10.1.3(SU5) and adf faces and ADF BC and to explain my problem I use HR schema. First, I created 2 view objects based on countries table named as TestView1 and TestView2. I set TestView1 query where clause to region_id=1 and

  • BC Archive - problem with opening view object based on entity from archive Update:11-30

    We have encountered a weird problem with a reusable BC library on different PCs. Library was imported into a project following steps in section 25.7 of the ADF guide. A view object was created using some of the entities from the library. Model tested

  • How to add row in multiple view object based on common entity object. Update:10-11

    Hi , I have Jdeveloper version - 10.1.3.3.0 Oracle Database - 11g R2 I have a situation where i have to show data from one table in three adf tables on jsf page depending on a flag value in a column in table. For this purpose i have done the followin

  • Separate App Module, View Object based on Select not EO: Best practice? Update:11-30

    Hi, I have a list of base tables(parameters) that are used everywhere in my application for selection components (List, Combo, Radio). I'm considering creating a separate app module with a view object based on query for each table. I have created a B

  • View objects referencing the same entity Update:10-11

    The behaviour occurs in every version of jdeveloper ADF BC i have tried so far (10g, 11g). I have 2 updatable view objects referencing the same entity object. When i create a new record using the first view object and before commiting the data to the

  • Problem in using View Object for validation Update:11-30

    Hi, I have defined a simple swing form to practice. It has one Entity Object and two View objects. One of these view objects is an updatable VO based on the EO and the other one has a simple "select count(*)" from a table. I defined a method val

  • Filter transient view object based SOC Update:11-30

    i have a SOC in a popup which is built on a Transient VO in a page on which popup is displayed. i need to filter contents of this SOC based on value selected in another SOC. both SOCs are based on same transient VO which is denormalized from a relati

  • Programmatically populate ADF BC view object based on user's JAZN roles Update:11-30

    I currently have a ADF BC read-only view object that is based on an sql query. I would like to assign values to the bind variables based upon the user's JAZN roles. My problem is that I am uncertain how to obtain the roles the user has. Any help woul

  • Problem with a View Object Update:11-30

    Hi, I am using ADF BC technology. I've got a curious for me problem... I get from a creation form a code that the user enter, a method in the app. module checks using the view object if the code exists or not... The code always Exist! Debugging I fou

  • Problems creating extension (View Object) in JDeveloper 9.0.3.5 Update:10-11

    Note: I originally posted this on the JDeveloper forum - but I was told to post it in this forum. This is on Windows XP Pro SP2 with JDeveloper 9.0.3.5 - patch 6469392 (appropriate for 11.5.10.6). I'm trying to create an extension for a view object f