Nathalie Roman has been checking out the different capabilities and new features of the Adapter-framework in ESB and BPEL and shares her insights on nasty pitfalls and nice-to-knows in this article. On the subject of inserting master-detail data using DB Adapter functionality, Roman writes, "It's best to make use of stored procedures instead of the toplink mappings file. I am mainly using the stored procedures because the tooling support in Jdeveloper (wizards, toplink ui), I still miss a good ui for the toplink support. Also it is easy to give the task to create an PL/SQL api to the PL/SQL developers that are working on a certain application."

Read the complete article in iAdvise.