Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.4K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187.1K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 443 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Refresh Table after commit

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 Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,462 Red Diamond
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 Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,462 Red Diamond
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