This discussion is archived
3 Replies Latest reply: Feb 15, 2013 3:45 AM by 969835 RSS

QBE on uncommitted data in af:table

969835 Newbie
Currently Being Moderated
Hi,
I am using Jdev v11.1.1.7.0.
I have an af:table in which I can insert, delete or save data.
I also have QBE enabled on this table.
If I add some rows and save the data before doing some query using QBE it works fine. But if add some rows and without clicking save I do QBE then it behaves erratically i.e. search results get lost when I remove the query criteria.
But if try to add a row with same primary key (which a lost row had), it gives me error. So it means that row is still there.

Does anyone has any idea about this? I can explain in more detail if you want. Is this adf default behavior i.e. it doesn't support qbe on uncommitted data?
  • 1. Re: QBE on uncommitted data in af:table
    Frank Nimphius Employee ACE
    Currently Being Moderated
    Hi,

    as an Oracle employee you can use the internal JDeveloper mailing list and internal forums (especially when you work with internal builds of JDeveloper)

    To answer your question (assuming the VO to query is based on an EO), set the query mode of the VO to also look into the entity cache. If the QBE is based on a custom ViewCriteria, then you can set this on the View Criteria (see the second tab in teh View Criteria editor). If you use the "all queryable attributes" default view criteria, use the following Java code to set the VO query mode

    vo.setQueryMode(ViewObject.QUERY_MODE_SCAN_ENTITY_ROWS | ViewObject.QUERY_MODE_SCAN_DATABASE_TABLES);

    Frank
  • 2. Re: QBE on uncommitted data in af:table
    969835 Newbie
    Currently Being Moderated
    Hi Frank,
    That works, but I still have further problems with this.
    As you have suggested I have posted about this further in internal forums. Can you please take a look here if you know about the issue- http://myforums.oracle.com/jive3/thread.jspa?threadID=1191023

    Appreciate your help,
    Thanks.
  • 3. Re: QBE on uncommitted data in af:table
    969835 Newbie
    Currently Being Moderated
    I can post the question here if you want..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points