Oracle ADF Composite Primary Key

Oracle ADF Composite Primary Key


In this Post discuss about Oracle ADF Composite Primary Key Bug,


There is a bug in Oracle ADF when we have a composite primary key in table and we want to insert into to this column, especially when one of the primary key columns is foreign key,


 Problem:

 I made a sample for this problem.

 1. We have two Table Organisation for Master Table and Bemerkung for Detail Table,(Master-Detail)


2. also there are two pages with one task flow.
Oracle ADF Composite Primary Key


3. In The Master page, there is a form for organization and table for bemerkung. via Edit button we go to the Detail page for edit the Bemerkung(Detail)
Oracle ADF Composite Primary Key


4.after click to Edit button we go to the Detail page. In this, via + Button we want to Insert into Bemerkung. Here Onr and Seite is Composite primary Key,
Oracle ADF Composite Primary Key


5.After insert automatically onr set with number becauase is master and get form master .
Oracle ADF Composite Primary Key


6. So we Enter the data for Seite and Name column.
Oracle ADF Composite Primary Key


7. After commit we see Exception like this two pictures,
Oracle ADF Composite Primary Key

Oracle ADF Composite Primary Key




This is the bug from ADF to support Composite Key.

Solution:

8.In viewobject Bemerkung we generate the viewimpl class.
Oracle ADF Composite Primary Key


9.In the findByKey method from this class we should Override it like below picture.
Oracle ADF Composite Primary Key


Again run the project and we can insert into Detail table without exception.
Location: Hannover, Deutschland

Comments

  1. UnknownJuly 26, 2017 at 9:59 AM

    this is not working same problem

    ReplyDelete
    Replies
    1. Hamed RoknizadehAugust 19, 2017 at 12:46 AM

      you should enable refresh after insert and after update for the fields

      Delete
  2. Joe The JetSeptember 15, 2018 at 12:27 AM

    I believe it should actually be this
    Key correctKey =
    new Key(new Object[] { getCurrentRow().getAttribute("CnfrIntrNo"),
    getCurrentRow().getAttribute("CnfrDocNam") });
    return super.findByKey(correctKey, maxNumOfRows);

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle JET with Firebase Realtime Database (Part 1)

Image
Oracle JET with Firebase Realtime Database (Part 1) With Firebase Realtime Database we can store and sync data in NoSQL database.  It is a cloud database and data store as JSON.  There are SDKs for iOS, Android and JavaScript.  you can find information about Firebase in this link: https://firebase.google.com/docs/database/ In this post, I want to explain how can we use firebase database as backend and Oracle JET as frontend. 1. Firstly we need to login in Firebase Cloud console.  https://firebase.google.com/ 2. After login to Firebase on the first page, there is "Add Project". I click on Add project". 3. display a popup for creating a project: Project name: JetApplication ProjectId: - Country/region: Germany 4. After creating the project, I am in Start page on Firebase Cloud. There are three icons for iOS, Android, Web. 5. I click on the "Add Firebase to your web app". Display popup with some informat...
Read more

ADF Filter LOV View Object , af:selectOneChoice Programmatically

Image
Filter LOV and populate selectOneChoice Programmatically In This post, I want to filter LOV View object before loading to the page, 1. I have main.xml as taskflow, frag1.jsff frag2.jsff as fragment and index.jsf as page. 2. drag main.xml taskflow and drop into the index.jsf page als region. 3.there is a employee list in frag1.jsff and employee form in frag2.jsff for editing. 4.with edit button in frag1.jsff we navigate to the frag2.jsff . 5. drag a af:selectonechoice component and drop into the frag2.jsff . 6. set #{bindings.DepartmentId.inputValue} as value and #{pageFlowScope.EmployeeBean.customList} for the selectItems component. 7.the EmployeeBean managebean is as blow. 8. in Department viewobject there is viewceriteria that I initialse bind variabale and apply viewceriteria with the code, and set the resultl into the lov .
Read more