Ken,
I am not sure from your email about which code goes where. Can you
please break it down in steps (mainly which code in which file and if I
need to change the input/ouput of the handler)?
- I will still call the handler from the "command" event of the button?
- Do I need to change the handler call (inputs/ouputs), except change
the output type to an attribute? Or it still is same as before?
getTable1Data(lavaVersion="#{pageSession.lava}"
buildVersion="#{pageSession.build}" lavaProject="#{pageSession.project}"
table1Data=>$attribute{table1DataList});
- I need to add your java code in my handler? What is the import
statement for tableRowGroup? Eventhough I have the
MultipleListDataProvider in my WEB-INF/lib, it keeps saying it cannot
detect package com.sun.enterprise.tools.admingui.dataprovider.
- MultipleListDataProvider dp = (MultipleListDataProvider)
tableRowGroup.getAttributes().get("sourceData");
I don't have to change anything in the above line, correct?
- dp.setLists(newData);
At the end of my handler I just pass on my list of list of objects to
dp.setLists, in my case, I just pass in "t1Data" (dp.setLists(t1Data))?
List t1Data = new ArrayList();
try {
System.out.println("In fetchTable1Data try block...");
DataAccessLayer dal = new DataAccessLayer();
CachedRowSetImpl crs = dal.getFirstLevelUsageStats(lava,
build, project);
RowSetMetaDataImpl rsmd = (RowSetMetaDataImpl)
crs.getMetaData();
int count = rsmd.getColumnCount();
//System.out.println("Column count is: " +
rsmd.getColumnCount());
int rows = 0;
while(crs.next()) {
System.out.println("In while loop: " + rows);
Map rEntries = new Hashtable();
for(int i=1;i<=count;i++)
{
//System.out.println(rsmd.getColumnName(i));
System.out.println(crs.getObject(i));
rEntries.put("col" +i, crs.getObject(i));
}
System.out.println(rEntries.get("col1").toString() + " :
" +rEntries.get("col2").toString() + " : "
+rEntries.get("col3").toString());
t1Data.add(rows,rEntries);
rows++;
}
System.out.println("Table rows: " + rows);
} catch(SQLException e) {
e.printStackTrace();
}
// Set the output.
System.out.println("t1Data rows: " + t1Data.size());
context.setOutputValue("table1Data", t1Data);
- The code in the jsf file remains same:
<sun:tableRowGroup
id="rowGroup1"
data={"#{requestScope.table1DataList}"}
sourceVar="tRow"
thanks,
-Karam
Ken Paulsen wrote:
>
> Hi Karam,
>
> The problem is the same issue that you had with the sun:dropDown
> component. The factory is converting the data, and not holding on to
> the original EL bindings. You can get your MultipleListDataProvider,
> and set new data in it:
>
> MultipleListDataProvider dp = (MultipleListDataProvider)
> tableRowGroup.getAttributes().get("sourceData");
> dp.setLists(newData);
>
> "newData" should be a List of List of Object. This data can be stored
> in request scope because this implementation of data provider stores a
> reference to the data. DataProviders are stored on the UIComponent
> (equivalent to pageSession). "newData" can be generated from your
> handler below (getTable1Data), however, I think this is only a List of
> Object. So when you pass it in to the handler in which you place the
> above Java code, make sure you do something like
> data={"#{requestScope.newData}"} (note the {}'s outside the quotes...
> this wraps your parameter value in a List to provide you with a List
> of List of Object.
>
> Ken
>
> Karam Singh Badesha wrote:
>> Ken,
>> This is not going to work for me as this handler takes input some
>> pageSession variables which gets created in beforeCreate event which
>> also gets updated with the ajax requests. I currently have couple of
>> drop downs which use ajax to update each other and then there is a
>> button. When a user presses that button, I need to recreate the table
>> (after page refresh). So I am using "command" event to call the
>> handler in the button and I expect it to refresh the table after the
>> reload, but it doesn't work. Here is my button:
>>
>> <sun:button
>> id="generateButton"
>> text="#{msgs.button_generateText}"
>> toolTip="#{msgs.button_generateText}"
>> > <!command
>> getTable1Data(lavaVersion="#{pageSession.lava}",
>> buildVersion="#{pageSession.build}",
>> lavaProject="#{pageSession.project}"
>> table1Data=>$pageSession{table1DataList});
>> />
>> </sun:button>
>>
>> So how can I make this work.
>>
>> thanks
>> Karam
>>
>> Ken Paulsen wrote:
>>>
>>> I assume you are calling your handler this in a "beforeCreate"
>>> event? Try moving the handler to an <!initPage /> event at the top
>>> of the page:
>>>
>>> <!initPage
>>> yourHandler(...);
>>> />
>>>
>>> Unlike "beforeCreate", "initPage" gets invoked every time the page
>>> is refreshed. You can probably move your List into a request
>>> attribute when you take this approach b/c you will be regenerating
>>> the data every request.
>>>
>>> I hope this helps!
>>>
>>> Ken
>>>
>>> Karam Singh Badesha wrote:
>>>> Found out what is happening here. Basically on my initial page
>>>> load, there was no data for the table. Now when I select some other
>>>> entries and click on a button, it is refreshing the page, but the
>>>> table still shows the old data (in this case, nothing). I tried the
>>>> default so that some data shows up and after resubmitting with
>>>> different data, it doesn't refresh. Can this problem be solved? I
>>>> need the fix by Mon as I need to demo this to our team.
>>>>
>>>> thanks
>>>> Karam
>>>>
>>>> Karam Singh Badesha wrote:
>>>>> Hi,
>>>>> Here is the what I had when the code was working fine:
>>>>>
>>>>> Table data was hardcoded in the handler was passing a list of
>>>>> HashTable/Map entries. The values is passed back and set as a
>>>>> pageSession variable. Here is corresponding jsf code:
>>>>>
>>>>> <sun:tableRowGroup
>>>>> id="rowGroup1"
>>>>> data={"$pageSession{table1DataList}"}
>>>>> sourceVar="tRow"
>>>>> >
>>>>>
>>>>> Now, I am getting the data from the database in the handler and
>>>>> can print the data fine in the handler, so I am assuming the data
>>>>> is getting fed into the same list of HashTable/Map entries fine.
>>>>> But nothing is showing up on the Table. Any idea why this might be
>>>>> happening?
>>>>>
>>>>> Here is the corresponding handler code:
>>>>>
>>>>> @Handler(id="getTable1Data",
>>>>> input={
>>>>> @HandlerInput(name="lavaVersion", type=String.class),
>>>>> @HandlerInput(name="buildVersion", type=String.class),
>>>>> @HandlerInput(name="lavaProject", type=String.class)},
>>>>> output={
>>>>> @HandlerOutput(name="table1Data", type=java.util.List.class)
>>>>> })
>>>>> public static void fetchTable1Data(HandlerContext context) {
>>>>> System.out.println("In fetchTable1Data...");
>>>>> String lava = (String) context.getInputValue("lavaVersion");
>>>>> String build = (String) context.getInputValue("buildVersion");
>>>>> String project = (String)
>>>>> context.getInputValue("lavaProject");
>>>>> List t1Data = new ArrayList();
>>>>> try {
>>>>> System.out.println("In fetchTable1Data try block...");
>>>>> DataAccessLayer dal = new DataAccessLayer();
>>>>> CachedRowSetImpl crs =
>>>>> dal.getFirstLevelUsageStats(lava, build, project);
>>>>> RowSetMetaDataImpl rsmd = (RowSetMetaDataImpl)
>>>>> crs.getMetaData();
>>>>> int count = rsmd.getColumnCount();
>>>>> System.out.println("Column count is: " +
>>>>> rsmd.getColumnCount());
>>>>> int rows = 0;
>>>>> while(crs.next()) {
>>>>> System.out.println("In while loop: " + rows);
>>>>> Map rEntries = new Hashtable();
>>>>> for(int i=1;i<=count;i++)
>>>>> {
>>>>> System.out.println(crs.getObject(i));
>>>>> rEntries.put("col" +i,
>>>>> crs.getObject(i).toString());
>>>>> }
>>>>> t1Data.add(rows,rEntries);
>>>>> rows++;
>>>>> }
>>>>> System.out.println("Table rows: " + rows);
>>>>> } catch(SQLException e) {
>>>>> e.printStackTrace();
>>>>> }
>>>>> // Set the output.
>>>>> context.setOutputValue("table1Data", t1Data);
>>>>> }
>>>>>
>>>>> thanks
>>>>> Karam