ADF/RIDC: Multiple sort in RIDC

Following is the way to specify multiple sort while using "GET_SEARCH_RESULTS" service through RIDC java APIs

    ----
    ----
    DataBinder requestDataBinder = idcClient.createBinder();
    requestDataBinder.putLocal("IdcService", "GET_SEARCH_RESULTS");
    requestDataBinder.putLocal("QueryText", doc.getSearchQuery());
    requestDataBinder.putLocal("SearchEngineName", "DATABASE");

    requestDataBinder.putLocal("SortSpec",
        "ORDER BY metadataField01 asc, metadataField02 asc, metadataField03 asc");
    -----
    -----

ADF: Getting URL parameter values inside page region

Getting URL parameter values in page region or inside taskflow can be achieved in following ways:

• Through groovy expression

It can be specified in region binding parameter value

${facesContext.externalContext.requestParameterMap['<parameter-name>']}

• In Managed bean

String paramValue = 
                 (String) FacesContext.getCurrentInstance().getExternalContext()
                 .getRequestParameterMap().get("param-name");

ADF: Resolving random JBO-27122 and closed statement errors

Problem: 

• Resolving random JBO-27122 and closed statement errors 
• <java.sql.SQLException: Statement cancelled, probably by transaction timing out.

Resolution:

Fusion web applications are not compatible with data sources defined with the JDBC XA driver. When creating a data source on Oracle WebLogic Server, be sure to change the Fusion web application data source's JDBC driver from “Oracle's Driver (Thin XA)” to “Oracle's Driver (Thin)”. Because XA data sources close all cursors upon commit, random JBO-27122 and closed statement errors may result when running the Fusion web application with an XA data source. 

Reference: http://docs.oracle.com/cd/E24382_01/web.1112/e16182/deployment_topics.htm#ADFFD23083