Andrejus Baranovskis Blog - JDev/ADF Samples list

JDev/ADF sample - ADF Faces and Client Side Value with innerHTML

2019-06-04T14:32:00.000+02:00

ADF Faces and Client Side Value with innerHTML. In ADF Faces you can leverage the full power of JavaScript. I will explain how you could assign a value from ADF Faces component to the plain HTML div.

GitHub

JDev/ADF sample - Intercepting ADF Table Column Show/Hide Event with Custom Change Manager Class

2019-02-20T21:18:00.004+01:00

Intercepting ADF Table Column Show/Hide Event with Custom Change Manager Class. Ever wondered how to intercept ADF table column show/hide event from ADF Panel Collection component? Yes, you could use ADF MDS functionality to store user preference for table visible columns. But what if you would want to implement it yourself without using MDS? Actually, this is possible through custom persistence manager class. I will show you how.

GitHub

JDev/ADF sample - Oracle ADF BC Reusing SQL from Statement Cache

2019-01-19T19:31:00.000+01:00

Oracle ADF BC Reusing SQL from Statement Cache. Oracle ADF BC by default is trying to reuse prepared SQL query from statement cache. It works this way when ADF BC runs with DB pooling off (jbo.doconnectionpooling=false). Normally we tune ADF application to run with DB pooling on (jbo.doconnectionpooling=true), this allows to release unused DB connection back to the pool when a request is completed (and in this case, statement cache will not be used anyway). If View Object is re-executed multiple times during the same request - in this situation, it will use statement cache too.

GitHub

JDev/ADF sample - Understanding Attributes Enum in ADF BC Row Class

2018-12-23T11:03:00.001+01:00

Understanding Attributes Enum in ADF BC Row Class. Did you ever wonder why Attributes Enum is generated by JDeveloper in Entity or View Row class? Attributes Enum holds a collection of attribute names and there is a set of static variables with attribute indexes. These indexes are used to locate attribute in getter/setter. Attributes Enum is a structure which is required for JDeveloper on design time to generate Java code. On runtime Attributes Enum is needed only as long as you are using a static variable index in the getter/setter.

GitHub

JDev/ADF sample - Oracle ADF + Jasper Visualize.js = Awesome

2018-11-25T09:48:00.003+01:00

Oracle ADF + Jasper Visualize.js = Awesome. This week I was working on a task to integrate Jasper Visualize.js into Oracle ADF application JSF page fragment. I must say integration was successful and Jasper report renders very well in Oracle ADF screen with the help of Visualize.js. Great thing about Visualize.js - it renders report in ADF page through client side HTML/JS, there is no iFrame. Report HTML structure is included into HTML generated by ADF, this allows to use CSS to control report size and make it responsive.

GitHub

JDev/ADF sample - ADF Postback Payload Size Optimization

2018-07-15T08:49:00.001+02:00

ADF Postback Payload Size Optimization. Recently I came across property called oracle.adf.view.rich.POSTBACK_PAYLOAD_TYPE. This property helps to optimize postback payload size. It is described in ADF Faces configuration section - A.2.3.16 Postback Payload Size Optimization. ADF partial request is executing HTTP post with values from all fields included. When postback property is set to dirty, it will include into HTTP post only changed values. As result - server will get only changed attributes, potentially this can reduce server time processing and make HTTP request size smaller. This especially can be important for large forms, with many fields.

GitHub

JDev/ADF sample - Effective Way to Get Changed Rows in ADF BC API

2018-05-29T21:38:00.002+02:00

Effective Way to Get Changed Rows in ADF BC API. Did you ever wondered how to get all changed rows in the transaction, without iterating through entire row set? It turns out to be pretty simple with ADF BC API method - getAllEntityInstancesIterator, which is invoked for Entity Definition attached to current VO.

GitHub

JDev/ADF sample - Oracle ADF BC REST - Performance Review and Tuning

2018-05-27T07:27:00.003+02:00

Oracle ADF BC REST - Performance Review and Tuning. I thought to check how well ADF BC REST scales and how fast it performs. For that reason, I implemented sample ADF BC REST application and executed JMeter stress load test against it. You can access source code for application and JMeter script on my GitHub repository. Application is called Blog Visitor Counter app for a reason - I'm using same app to count blog visitors. This means each time you are accessing blog page - ADF BC REST service is triggered in the background and it logs counter value with timestamp (no personal data).

GitHub

JDev/ADF sample - Microservice Approach for Web Development - Micro Frontends

2018-05-17T19:26:00.001+02:00

Microservice Approach for Web Development - Micro Frontends. Wondering what micro frontends term means? Check micro frontends description here. Simply speaking, micro frontend must implement business logic from top to bottom (database, middleware and UI) in isolated environment, it should be reusable and pluggable into main application UI shell. There must be no shared variables between micro frontends. Advantage - distributed teams can work on separate micro frontends, this improves large and modular system development. There is runtime advantage too - if one of the frontends stops working, main application should continue to work.

GitHub

JDev/ADF sample - ADF Declarative Component Example

2018-03-22T18:58:00.000+01:00

ADF Declarative Component Example. ADF Declarative Component support is popular ADF framework feature, but in this post I would like to explain it from slightly different angle. I will show how to pass ADF binding and Java bean objects into component through properties, in these cases when component must show data from ADF bindings, such approach could offer robustness and simplify component development.

GitHub

JDev/ADF sample - Find In Cache By Key ADF BC API Method Usage

2018-03-11T19:23:00.001+01:00

Find In Cache By Key ADF BC API Method Usage. What if you need to verify - if row with given key exists in fetched rowset? This could be useful while implementing validation logic. ADF BC API method findByKey - will trigger SQL call and fetch row from DB, if row with given key doesn't exist in fetched rowset. Luckily there is ADF BC API method called findInCacheByKey, this method only checks for row in fetched rowset, without going to DB - very convenient in certain situations, when you actually don't want to bring record from DB, if it wasn't fetched.

GitHub

JDev/ADF sample - Microservices with Oracle ADF Remote Regions

2018-02-25T05:58:00.000+01:00

Microservices with Oracle ADF Remote Regions. ADF remote regions - functionality available in the latest ADF 12c versions. ADF remote region runs on different server and content is delivered to consuming module through ADF remote region servlet. This allows to decouple large enterprise system into separate modules, each running independently on separate servers. Gained advantage - system becomes more scalable and reliable, even if several modules will be down, system will continue to be functional.

GitHub

JDev/ADF sample - Avoid Blind SQL Call from ADF Task Flow Method

2018-01-29T22:55:00.006+01:00

Avoid Blind SQL Call from ADF Task Flow Method. Keep an eye open on ADF Task Flow Method Call activities where methods from ADF Bindings are called. JDEV 12c sets deferred refresh for ADF binding iterators related to TF Method Call activities and this causing blind SQL to be executed. Blind SQL - query without bind variables.

ADFTFCallBindingApp.zip

JDev/ADF sample - Recipe for JQuery Menu integration into ADF Faces

2017-12-21T19:37:00.002+01:00

Recipe for JQuery Menu integration into ADF Faces. May be you are thinking to add some fresh looking element into your ADF app? I would propose JQuery menu. Advantage of such menu - it is purely client side implementation and it allows user to navigate through items really fast. Besides fast navigation, it looks great too and can be easily customized.

ADFJQueryMenuApp.zip

JDev/ADF sample - JET Composite Component in ADF Faces UI - Deep Integration

2017-12-05T19:54:00.001+01:00

JET Composite Component in ADF Faces UI - Deep Integration. Finding ways of further JET integration into ADF Faces is important. Next step would be to implement editable grid JET based component and integrate it into ADF to improve fast user data entry experience..

jetadfcomposite

JDev/ADF sample - ADF Performance Story - This Time Developer Was Wrong

2017-11-10T19:24:00.001+01:00

ADF Performance Story - This Time Developer Was Wrong. ADF is fast. If ADF application is slow, most likely this is related to development mistakes. I would like to tell you one story, based on my ADF tuning experience. Problem description: ADF application runs fast in DEV, when DB size is small. Same application runs slow in TEST/PROD, when DB size is large. Question - what is slow. Answer - slow means forms are loading slow. Ok, lets go to the story.

ADFRangeSizeApp.zip

JDev/ADF sample - ADF BC REST Service from ADF Library JAR

2017-09-17T18:51:00.001+02:00

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.

adfbcrest.zip

JDev/ADF sample - Oracle JET Simple Table with Fake JSON Server

2017-09-08T08:54:00.000+02:00

Oracle JET Simple Table with Fake JSON Server. What if you want to build JET UI, but there is no back-end REST service ready yet. You could use static JSON data inside JET app and load it from the JSON file. This works, but data retrieval logic will need to be changed after REST service will be ready. This is not productive. Ideally you would like to have fake REST service to simulate REST calls from JET UI, until real REST back-end is ready.

jetsimplecrud

JDev/ADF sample - ADF 12c Table CRUD Fix for Auto Focus

2017-09-03T13:15:00.000+02:00

ADF 12c Table CRUD Fix for Auto Focus. I had a post about how to improve user data entry for ADF table with auto focus for new row - Improving ADF UI Table CRUD Functionality with Auto Focus. If you follow comments thread for that post - you will see described approach doesn't work exactly as it should in ADF 12c (focus is set for new row but later is lost after tab navigation - it should move focus to another column). Thanks to the community we have simple fix for this issue, read OTN Forum thread - Set Focus on CreateINsert row in ADF Table. I hope Oracle will fix this functionality in the next ADF versions (currently they say it is expected behaviour, and I don't agree with this). But for now - fix does the job.

ADFTableFocusApp_v2.zip

JDev/ADF sample - ADF Client Side Validation with JavaScript

2017-08-30T16:54:00.001+02:00

ADF Client Side Validation with JavaScript. In my previous post I explained how to use JS client side formatter for ADF Faces input components - ADF Goes Client Side - UI Performance Boost with JavaScript. The same principle can be applied for client side validation. Most likely you are not going to implement complex validation rules on the client side, but for simple checks - it will be perfect. There will be no roundtrip to the server and this will allow to improve user experience.

ADFFormattingApp_v2.zip

JDev/ADF sample - Oracle JET Busy Context API to Control Asynchronous REST Calls

2017-07-29T18:06:00.000+02:00

Oracle JET Busy Context API to Control Asynchronous REST Calls. I have received feedback from users working with JET UI - sometimes it is not obvious that action button was pressed, users tend to press same button again very fast, which leads to parallel REST calls executing at the same time. In JET - REST call is executed asynchronously, this makes user to believe action was done instantly when button was pressed. However, REST call still may run in the background - while user will be trying to call same service again. While in most of the cases such behaviour is fine, still there are use cases when we want to block action button, until REST response is not received (while response is executed, button will be disabled - this will give visual feedback to the user about action still executing). JET provides Busy Context API to handle asynchronous REST calls in synchronous way.

JETCRUD

JDev/ADF sample - ADF Goes Client Side - UI Performance Boost with JavaScript

2017-07-22T18:02:00.001+02:00

ADF Goes Client Side - UI Performance Boost with JavaScript. If you would like to boost ADF UI performance, you should look into client side validation and formatting options possible to be done in ADF UI. Today I will describe how you can implement client side converter, to format number value on client side, without making request to the server. Same approach could be used to implement client side validators. You can raise error message and it will be assigned to UI field in the same way, just like any standard ADF error message. While this approach is documented long ago in Oracle ADF developer guide - How To Create Client Side Converter, it is not well known and not often used.

ADFFormattingApp.zip

JDev/ADF sample - ADF BC - Create View Object From Query with Custom Implementation Class

2017-07-16T19:23:00.001+02:00

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.

ADFVOFromSQLApp.zip

JDev/ADF sample - ADF 12c BC Proxy User DB Connection and Save Point Error

2017-07-10T21:40:00.001+02:00

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).

AMExtendApp_v3.zip

JDev/ADF sample - Working with Location and Permissions in JET Hybrid

2017-07-06T08:31:00.001+02:00

Working with Location and Permissions in JET Hybrid. What if you want to access mobile device location data from JET Hybrid application? This can be achieved with Cordova Geolocation plugin. But you want it to be nicely done and want to make sure application is granted with permission to access location information. Use Cordova Permissions plugin for that.

rslocationapp