How to Display Database data into Table widget

1
0
-1

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

  1. Create oracle data source connector.
  2. Enter database access information
  3. Write Query : SELECT * FROM ZZ_TEST q
  4. Select scripting mode. d
  5. On output : create variable -> type : java.util.list http://i.imgur.com/KTAGsNK.png" title="Hosted by imgur.com"/></a" alt="df" />
  6. Available value : default value write following script
  1. final List<List<Object>> resultTable = new ArrayList<List<Object>>();
  2. int maxColumn = Resultset.getMetaData().getColumnCount()+1;
  3. while(Resultset.next()){
  4. final List<Object> row = new ArrayList<Object>();
  5. for(int colIndex = 1; colIndex < maxColumn ; colIndex++){
  6. row.add(Resultset.getObject(colIndex));
  7. }
  8. resultTable.add(Collections.unmodifiableList(row));
  9. }

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

No answers yet.
Notifications