Forum Stats

  • 3,827,853 Users
  • 2,260,831 Discussions
  • 7,897,398 Comments

Discussions

Refresh Table after commit

ChristianM0147
ChristianM0147 Member Posts: 35 Red Ribbon

Hello

im currently working with JDeveloper version 12.2.1.4.0.

I have an entitybased ViewObject with a corresponding oracle database table.

I dragged the data control on my .jsf page to create a editable table. I can edit the records in the table and execute/commit the changes to the database table.

The problem is: the database table has a trigger that changes some values of the record in the database but it does not refresh the values of the table on my .jsf page.

I tried to set the 'CacheResults' property to false on the Iterator of the table in the Pagedefinition and set the 'partialTriggers' property of the table to the id of the commit button. But it does not work.

Any ideas?

Best Answer

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,462 Red Diamond
    Answer ✓

    Two things you can try

    1) you go to the EO and for each attribute that is changed during commit by triggers, you set the checkbox 'Refresh on insert' and 'Refresh on update'

    2) if 1) doesn'T work, you can execute the query behind the table again.


    Timo

Answers

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,462 Red Diamond
    Answer ✓

    Two things you can try

    1) you go to the EO and for each attribute that is changed during commit by triggers, you set the checkbox 'Refresh on insert' and 'Refresh on update'

    2) if 1) doesn'T work, you can execute the query behind the table again.


    Timo