Hi All,

We have a Web Application which is developed by using Sun JSF libraries with IDE as Rational Software Architect and Backend as DB2. This application initially developed with NetBeans, MySQL and Sun JSF, Tomcat environment. We migrated the entire project after facing lot of problems we can get resolve some problems to work on WebSphere Applicaiton Server. Still we have a problem on rendering the CachedRowSetDataProvider (multiple results) to JSF table with 7 columns, we used tag as <webuijsf:Table></webuijsf:Table>

Below I am pasting my sample code, please have a look and let me know if we need any changes on the below code, its bit urgent.

From Managed Bean:
private CachedRowSetDataProvider requestDataProvider = new CachedRowSetDataProvider();

private void _init() throws Exception {
requestDataProvider.setCachedRowSet((javax.sql.row set.CachedRowSet) getValue("#{SessiontBean1.requestRowSet}"));
}

From SessionBean1:

private void _init() throws Exception {

requestRowSet.setDataSourceName("jdbc/mydsname");
requestRowSet.setCommand("SELECT ALL request.requestid, request.userid, request.assetid, request.rdescription, request.requestdate FROM Administrator.request WHERE request.activityid = ? AND action_taken = \'0\'");
requestRowSet.setTableName("request");
}

From JSP :
<webuijsf:table augmentTitle="false" binding="#{AdminRequest.table1}" id="table1"
style="height: 149px; left: 48px; top: 264px; position: absolute; width: 768px" title="REQUESTS" width="768">
<webuijsf:tableRowGroup binding="#{AdminRequest.tableRowGroup1}" id="tableRowGroup1" rows="10"
sourceData="#{AdminRequest.requestDataProvider}" sourceVar="currentRow">
<hutputText value="#{currentRow.value['requestid']}"></hutputText>
<webuijsf:tableColumn align="center" headerText="REQUEST ID" id="tableColumn1" sort="requestid" width="20">
<webuijsf:staticText binding="#{AdminRequest.staticText1}" id="staticText1" text="#{currentRow.value['request.requestid']}"/>
</webuijsf:tableColumn>
<webuijsf:tableColumn align="center" headerText="USER ID" id="tableColumn2" sort="userid" width="104">
<webuijsf:staticText binding="#{AdminRequest.staticText2}" id="staticText2" text="#{currentRow.value['request.userid']}"/>
</webuijsf:tableColumn>
<webuijsf:tableColumn align="center" headerText="ASSET ID" height="29" id="tableColumn3" sort="assetid" width="20">
<webuijsf:staticText binding="#{AdminRequest.staticText3}" id="staticText3" text="#{currentRow.value['request.assetid']}"/>
</webuijsf:tableColumn>
<webuijsf:tableColumn align="justify" headerText="DESCRIPTION" id="tableColumn4" sort="rdescription" width="144">
<webuijsf:staticText binding="#{AdminRequest.staticText4}" id="staticText4" text="#{currentRow.value['request.rdescription']}"/>
</webuijsf:tableColumn>
<webuijsf:tableColumn align="center" headerText="DATE" id="tableColumn5" sort="requestdate" width="20">
<webuijsf:staticText binding="#{AdminRequest.staticText5}" id="staticText5" text="#{currentRow.value['request.requestdate']}"/>
</webuijsf:tableColumn>
<webuijsf:tableColumn align="center" id="tableColumn6" width="10">
<webuijsf:button actionExpression="#{AdminRequest.button1_action}" id="button1" text="Accept"/>
</webuijsf:tableColumn>
<webuijsf:tableColumn align="center" id="tableColumn8" width="10">
<webuijsf:button actionExpression="#{AdminRequest.button2_action}" id="button2" text="Decline"/>
</webuijsf:tableColumn>
</webuijsf:tableRowGroup>
</webuijsf:table>
Any body reply with solution will be appreciate it:

hi

it is bit urgent .. any kind of suggestion will be greatful

thanks