# How to Display Database data into Table widget

**URL:** <https://community.ofelia.com/t/how-to-display-database-data-into-table-widget/4694>\
**Category:** Q&A\
**Created:** [12 June 2014 09:50 UTC](https://community.ofelia.com/t/how-to-display-database-data-into-table-widget/4694 "2014-06-12T09:50:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kppatel](https://avatars.discourse-cdn.com/v4/letter/k/ecccb3/32.png) [@kppatel](https://community.ofelia.com/u/kppatel)\
**Post date:** [12 June 2014 09:50 UTC](https://community.ofelia.com/t/how-to-display-database-data-into-table-widget/4694/1 "2014-06-12T09:50:50Z")

</div>

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](http://i.imgur.com/yCv3cfY.png)
4. Select scripting mode.  
 ![d](http://i.imgur.com/ZF9H1GW.png)
5. On output : create variable → type : java.util.list  
![df][df]
6. Available value : default value write following script  
  
final List\<List\> resultTable = new ArrayList\<List\>();  
int maxColumn = Resultset.getMetaData().getColumnCount()+1;  
while(Resultset.next()){  
final List row = new ArrayList();  
for(int colIndex = 1; colIndex \< maxColumn ; colIndex++){  
row.add(Resultset.getObject(colIndex));  
}  
resultTable.add(Collections.unmodifiableList(row));  
}

![d](http://i.imgur.com/tE3i4j4.png) 7. Finish 8. In form take table widget \> gen \> data \> default Val \> this field 9. When run : error while submitting 

[df]: [![](http://i.imgur.com/KTAGsNK.png "Hosted by imgur.com")](http://imgur.com/KTAGsNK)