Pagination with BC4J

There are two ways to to do pagination in BC4J.

There is one in build pagination is available in BC4J.

Create you VO object.
then
vo.setAccessmode(RowSet.PAGING_MODE);
vo.setWhereClauseParam(0,25);//for ROWNUM <= section
vo.setWhereClauseParam(1,0);//for ROWNUM> SECTION


Other-way to do this is.

Have one method like below

setPagingQuery(ViewObjectImpl vo){
vo.setQuery("SELECT * FROM (SELECT /*+ FIRST_ROWS */ IQ.*, ROWNUM AS Z_R_N FROM(" + 
                             vo.getQuery() + ")IQ  WHERE ROWNUM < " + end + 
                             ") WHERE Z_R_N >" + start);
}

then before your do execute your query. just call
setPagingQuery(this);
excecuteQuery();

How to work with OA BC4j in normal oc4j container(Not EBS oc4j container)

First i would like to tell that the OA BC4j is not same as normal BC4J .. It is extended version of BC4j.

So few configuration changes required to make it work in normal oc4j

First we need to copy following files to one folder (Let say applib) in in oc4j server.

../applib/mdsrt.jar"/>
../applib/fwk.jar"/>
../applib/fwkcabo.jar"/>
../applib/fwkjbo.jar"/>
../applib/diagnostics.jar"/>
../applib/concurrent.jar"/>
../applib/collections.jar"/>
../applib/atg.jar"/>
../applib/lesson.jar"/>
../applib/nls_charset12.jar"/>
../applib/oamMaintMode.jar"/>
../applib/part.jar"/>
../applib/req.jar"/>
../applib/svc.jar"/>




Then we need change server.xml to change our  adf to new version like below


<shared-library name="adf.oracle.domain" version="10.1.3.1" library-compatible="true">
<code-source path="/u01/app/oracle/product/oas_1/BC4J/lib"/>
<code-source path="/u01/app/oracle/product/oas_1/jlib/commons-cli-1.0.jar"/>
<!-- <code-source path="/u01/app/oracle/product/oas_1/mds/lib/concurrent.jar"/> -->
<!-- <code-source path="/u01/app/oracle/product/oas_1/mds/lib/mdsrt.jar"/> -->
<code-source path="/u01/app/oracle/product/oas_1/jlib/share.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/jlib/regexp.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/jlib/xmlef.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/BC4J/jlib/adfmtl.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/BC4J/jlib/adfui.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/BC4J/jlib/adf-connections.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/BC4J/jlib/dc-adapters.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/ord/jlib/ordim.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/ord/jlib/ordhttp.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/jlib/ojmisc.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/jlib/jdev-cm.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/lib/xsqlserializers.jar"/>
<code-source path="../applib/mdsrt.jar"/>
<code-source path="../applib/fwk.jar"/>
<code-source path="../applib/fwkcabo.jar"/>
<code-source path="../applib/fwkjbo.jar"/>
<code-source path="../applib/diagnostics.jar"/>
<code-source path="../applib/concurrent.jar"/>
<code-source path="../applib/collections.jar"/>
<code-source path="../applib/atg.jar"/>
<code-source path="../applib/lesson.jar"/>
<code-source path="../applib/nls_charset12.jar"/>
<code-source path="../applib/oamMaintMode.jar"/>
<code-source path="../applib/part.jar"/>
<code-source path="../applib/req.jar"/>
<code-source path="../applib/svc.jar"/>
<code-source path="../applib/uix2.jar"/>
<code-source path="../applib/uix2-install.jar"/>
<code-source path="../applib/wsp.jar"/>
<import-shared-library name="oracle.xml"/>
<import-shared-library name="oracle.jdbc"/>
<import-shared-library name="oracle.gdk"/>
<import-shared-library name="oracle.cache"/>
<import-shared-library name="oracle.dms"/>
<import-shared-library name="oracle.sqlj"/>
<import-shared-library name="oracle.toplink"/>
<import-shared-library name="oracle.ws.core"/>
<import-shared-library name="oracle.ws.client"/>
<import-shared-library name="oracle.xml.security"/>
<import-shared-library name="oracle.ws.security"/>
<import-shared-library name="oracle.ws.reliability"/>
<import-shared-library name="oracle.jwsdl"/>
<import-shared-library name="oracle.http.client"/>
<import-shared-library name="oracle.expression-evaluator"/>
</shared-library>
<shared-library name="adf.generic.domain" version="10.1.3.1" library-compatible="true">
<code-source path="/u01/app/oracle/product/oas_1/BC4J/jlib/bc4jdomgnrc.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/BC4J/lib"/>
<code-source path="/u01/app/oracle/product/oas_1/jlib/commons-cli-1.0.jar"/>
<!-- <code-source path="/u01/app/oracle/product/oas_1/mds/lib/concurrent.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/mds/lib/mdsrt.jar"/> -->
<code-source path="/u01/app/oracle/product/oas_1/jlib/share.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/jlib/regexp.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/jlib/xmlef.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/BC4J/jlib/adfmtl.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/BC4J/jlib/adfui.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/BC4J/jlib/adf-connections.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/BC4J/jlib/dc-adapters.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/ord/jlib/ordim.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/ord/jlib/ordhttp.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/jlib/ojmisc.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/jlib/jdev-cm.jar"/>
<code-source path="/u01/app/oracle/product/oas_1/lib/xsqlserializers.jar"/>
<code-source path="../applib/mdsrt.jar"/>
<code-source path="../applib/fwk.jar"/>
<code-source path="../applib/fwkcabo.jar"/>
<code-source path="../applib/fwkjbo.jar"/>
<code-source path="../applib/diagnostics.jar"/>
<code-source path="../applib/concurrent.jar"/>
<code-source path="../applib/collections.jar"/>
<code-source path="../applib/atg.jar"/>
<code-source path="../applib/lesson.jar"/>
<code-source path="../applib/nls_charset12.jar"/>
<code-source path="../applib/oamMaintMode.jar"/>
<code-source path="../applib/part.jar"/>
<code-source path="../applib/req.jar"/>
<code-source path="../applib/svc.jar"/>
<code-source path="../applib/uix2.jar"/>
<code-source path="../applib/uix2-install.jar"/>
<code-source path="../applib/wsp.jar"/>
<import-shared-library name="oracle.xml"/>
<import-shared-library name="oracle.jdbc"/>
<import-shared-library name="oracle.gdk"/>
<import-shared-library name="oracle.cache"/>
<import-shared-library name="oracle.dms"/>
<import-shared-library name="oracle.sqlj"/>
<import-shared-library name="oracle.toplink"/>
<import-shared-library name="oracle.ws.core"/>
<import-shared-library name="oracle.ws.client"/>
<import-shared-library name="oracle.xml.security"/>
<import-shared-library name="oracle.ws.security"/>
<import-shared-library name="oracle.ws.reliability"/>
<import-shared-library name="oracle.jwsdl"/>
<import-shared-library name="oracle.http.client"/>
<import-shared-library name="oracle.expression-evaluator"/>
</shared-library>


We  need comment out the path for concurrent.jar and mdsrt.jar for existing setup and add new path.








Please reach out to me in case in  help required on this.