RowLimit configuration in ADF

RowLimit Configuration Parameter Example


 what is rowLimit configuration :

      we have a table with certain number of rows.  if  anyone need to instruct the application user with rowLimit warning when the user cross the predefined rowLimit within the table, here is the way:
<?xml version="1.0" encoding="UTF-8" ?>
<adf-config xmlns="http://xmlns.oracle.com/adf/config"
            xmlns:config="http://xmlns.oracle.com/bc4j/configuration"
            xmlns:adf="http://xmlns.oracle.com/adf/config/properties"
            xmlns:sec="http://xmlns.oracle.com/adf/security/config">
  <adf-adfm-config xmlns="http://xmlns.oracle.com/adfm/config">
    <defaults changeEventPolicy="ppr" useBindVarsForViewCriteriaLiterals="true"
              useBindValuesInFindByKey="true" mapNegativeScaleToIntegerTypes="true"

              executeEmptyOnException="true" rowLimit="100"/>

How do you override the global Row Fetch Limit for a specific ViewObject?


 we can override the global row fetch limit for a particular VO.  Here is the way :

 Provide maxfetchsize for the VO [Tuning Section of a VO]

 OR 

 we can override getRowLimit() of ViewObjectImpl  to return -1.

Comments

Post a Comment

Please add your comment

Popular posts from this blog

ADF MODEL - VIEW CRITERIA (VC)

Image
ADF View Criteria: VIEW CRITERIA is nothing but a "Where" clause to the SQL query with some special functions". It will be used to refine the query results. View Criteria Types: =============== 1. Implicit View Criteria: Renders all the areas in the VO as a filter field. (Default) 2. Named View Criteria: Selected fields are participating in the filter fields section as per the configuration.    Key Technical Term: -------------------------- What is RowMatch :             RowMatch is nothing but "in-memory row filtering" OR CACHE What is Mode : [Filtering Option]            Query/Database - Use query's where clause. [Default]            Cache - In memory filtering            Both  - Use query or memory filtering. What is Bind Variables:           Parameters applied to querie...
Read more

Developing Scalable Web Applications with Cloud Architecture

When developing a web application, it's crucial to consider a simplified yet effective approach to the architecture, especially when leveraging the power of cloud platforms. Here are some essential steps and patterns to ensure a robust and scalable application: DNS : When you type <your domain>.com, the request goes to the DNS server, which responds with an IP address. It uses the cloud's global network to serve DNS zones from various locations worldwide, ensuring high availability and low latency for users. Web Servers : The IP obtained from the DNS server is used by the user's computer to make a connection to the web server where the front-end is deployed. Application Servers : The application's business logic is deployed on the application server. This may involve multiple functional microservices. Requests to this application server are usually limited to web servers and internal services. Database : The application needs one or more databases to store info...
Read more

Best Practices

Best Practices & Notes:  =================== please watch every day update : ------------------------------------- ADF - TABLE : Primary Key While working with table, ADF always expects a predefined primary key for the table.  We can create a primary key using DB sequence or other alternative options. If you do not have a PK for a table, during scrolling or selecting a row within the table or creating an empty row and scrolling to next set of rows, we will get a weird result. Example for Sequence PK: (Groovy Expression) (new oracle.jbo.server.SequenceImpl("TEST_SEQ",adf.object.getDBTransaction())).getSequenceNumber() Just a note: ADF - TABLE : Custom Partial Trigger We can add table selection listener programmatically with declarative component using the following snippets  of code : _getTable().addSelectionListener(new SelectionListener(){             @Override ...
Read more