ADF Synchronize with Database
We may have change the database table structure after created the Entity and View Object in the model project. After any changes made to the table, we need to synchronize the Entity object back from the database table. ADF Synchronize with Database provides this exact functionality
ADF Synchronize Entity Object – Example
I have created an Entity Object of Country table and created App module Java classes. After those objects had been created, I added a column called ‘Extra Column’ of varchar datatype. Now I want to synchronize the extra column to my Entity object.
Restart the JDeveloper after you made any changes to the database table.
Right-click on the Entity object you want to sync and select Synchronize with Entity Object. As you see in the below image, the country EO object has only three attributes.
It displays the list of changes going to happen to the EO. Click the button ‘Synchronize All‘; Click ‘Yes’ or ‘Ok’ for the next upcoming popups
As see the entity object below, an extra column was added to it
Time to Synchronize View Object
The ADF synchronization won’t affect the View objects. We have to do it manually by opening the view object and select ‘Add attribute from Entity’ as shown below
Move the column you need from left to right and click Ok.
See the below view object; the extra column is added to it
If you have created any App Module Java class or EO/VO Java class. Manipulate the methods manually. For example, if a column was deleted after the entity object was created then delete the getter setter methods manually.
The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.
Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
Latest posts by Govind
- Is it possible to logout Primavera P6 through SQL Query? - February 16, 2018
- How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server - February 15, 2018
- Configure Windows Firewall for Microsoft SQL Server 2017 – Part 4 - February 14, 2018