Upload Info

ADF 12c BC Proxy User DB Connection and Save Point Error If you are modernising Oracle Forms system, high chance you need to rely on DB proxy connection. Read more about it in my previous post for ADF 11g - Extending Application Module for ADF BC Proxy User DB Connection. It works in the same way for ADF 12c, but there is issue related to handling DB error, when DB proxy connection is on. DB error is propagated to ADF but is being substituted by save point error (as result - user would not see original error from DB). It seems like related to JDBC driver in 12c. The workaround is to override ADF SQL builder class and disable save point error propagation (there might be better ways to workaround it). Proxy connection is established from prepareSession method in generic AM Impl class: If I would change salary value to negative and save data - DB constraint error would fire (negative not allowed). Unfortunately, end user would not see that error - he gets message about failed save point: ...

ADF BC Create View Object From Query with Custom Implementation Class I had a request to explain how to create dynamic ADF BC VO from SQL statement and set custom VO implementation class for newly created VO instance. Custom VO implementation class extends from ADF BC ViewObjectImpl and overrides super method: There is a method createViewObjectFromQueryStmt , in previous ADF versions this method had two parameters - VO instance name and SQL statement. In current ADF 12c - there is a second signature of the same method, which contains option to specify VO implementation class name. Dynamic VO from SQL with VO implementation class: ADF BC custom methods can be tested with ADF BC tester: Overridden method from custom VO implementation class is called: Download sample application - ADFVOFromSQLApp.zip. go to link download

ADF BC REST Service from ADF Library JAR I had assignment to enable ADF BC REST for existing ADF application, which was developed with multiple ADF libraries. ADF BC REST was supposed to be enabled for one of the ADF libraries and then accessed through Master application. All ADF BC REST samples usually show how to enable REST inside Master application itself. I was curious if it will work to enable ADF BC REST and package it into ADF library, which is consumed from Master application. It worked and I would like to share sample app. Sample app is based on two JDEV projects - library and master applications. Library application contains ADF BC REST implementation for Employees VO: ADF Library is generated out of ViewController project, ADF BC REST is packaged through dependency: Model (enabled with ADF BC support) project in Master application imports ADF library: Run Master application by running REST project. There is improvement in JDEV 12.2.1.3 comparing to 12.2.1.2 - re-deployment...