Wednesday, September 16, 2009

ADF 11g: Rowcount from Execute with parameter query programmatically

//Requirement: ADFUtils class,OnPageLoadBackingBeanBase class backing bean extending this(OnPage...) class, override onPageLoad method as below


public void onPageLoad() {
BindingContainer bindings = getBindings();
try
{
OperationBinding operationBinding = bindings.getOperationBinding("ExecuteWithParams");
Object result = operationBinding.execute();
System.out.println("Result"+result);
BindingContainer bindings1 = ADFUtils.getBindingContainer();
DCIteratorBinding dcitr =
(DCIteratorBinding)bindings1.get("Storetimings1View2Iterator");
//Fetch the number of rows returned
long count = dcitr.getDeferredEstimatedRowCount();
System.out.println("Rows returned:: "+count);
if(count == 0) {
OperationBinding operationBinding1 = bindings.getOperationBinding("Createwithparameters");
Object result1 = operationBinding1.execute();
}


}
catch(Exception e) {
System.out.println("The exception");

}

}