How to Display Database data into Table widget

Submitted by kppatel on Thu, 06/12/2014 - 11:50

Hello, I found some discussion and try to apply following procedure to display data of external database into table widget. I’m total new on this environment. pl provide me specific procedure .

I’m using , Bonita soft 6.3 communitiy Oracle database 10g

Create oracle data source connector.
Enter database access information
Write Query : SELECT * FROM ZZ_TEST
Select scripting mode.
On output : create variable -> type : java.util.list http://i.imgur.com/KTAGsNK.png" title="Hosted by imgur.com"/></a" alt="df" />
Available value : default value write following script

final List<List<Object>> resultTable = new ArrayList<List<Object>>();
int maxColumn = Resultset.getMetaData().getColumnCount()+1;
while(Resultset.next()){
final List<Object> row = new ArrayList<Object>();
for(int colIndex = 1; colIndex < maxColumn ; colIndex++){
row.add(Resultset.getObject(colIndex));
}
resultTable.add(Collections.unmodifiableList(row));
}

7. Finish 8. In form take table widget > gen > data > default Val > this field 9. When run : error while submitting