Saturday, April 24, 2010

JDev/ADF sample - ADF Magic or Bad Database Design for Master-Detail - Editable Primary Keys

  • ADF Magic or Bad Database Design for Master-Detail - Editable Primary Keys. While helping Oracle Forms customers to modernize their systems into Oracle Fusion, sometimes we face interesting requirements. Together with my colleagues from Cape Town (South Africa) we are implementing Oracle Fusion system based on database design inherited from old Oracle Forms system. One of the most common use cases there - Master-Detail relationships across different levels. Some of the Master-Detail use cases are using editable primary keys. This means there is no database sequence for primary key, user types key value directly from interface. And its where problem starts - because we are using incorrect design and asking user to provide primary key values manually, things are not working as expected. But what to do, sometimes we can't change design and are forced to find solutions. Today I will describe what type of problems you will face with this use case, and how to solve it with a bit of ADF magic. Its where ADF magic comes - even we are using wrong database design, we still can make it work with ADF.
    Download - CreateMasterDetailNoSequence.zip

No comments: