# mysql result "one column n rows" doesn't works

**URL:** <https://community.ofelia.com/t/mysql-result-one-column-n-rows-doesnt-works/5133>\
**Category:** Q&A\
**Created:** [10 September 2014 12:57 UTC](https://community.ofelia.com/t/mysql-result-one-column-n-rows-doesnt-works/5133 "2014-09-10T12:57:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fabi13](https://avatars.discourse-cdn.com/v4/letter/f/e47c2d/32.png) [@Fabi13](https://community.ofelia.com/u/Fabi13)\
**Post date:** [10 September 2014 12:57 UTC](https://community.ofelia.com/t/mysql-result-one-column-n-rows-doesnt-works/5133/1 "2014-09-10T12:57:42Z")

</div>

Hi!

Following some tips from the bonita documentation and some answers from the forum, I tried to configure a mysql query to show it in a multiselect list wigdet as below ( I used the bonita community 6.3.2 ):

1. Create a field list\_name type java.util.list;

2. Insert a connector and adjust the database access information to a MYSQL database;

3. Insert the following data in “Query or Batch Script”:  
script name: selectMysql  
// selects all user emails  
String myQuery = "SELECT email ";  
myQuery= myQuery +"FROM users ";  
myQuery= myQuery +“WHERE valid = 1 ORDER BY email;”;  
return myQuery

4. Output operation definition:  
Select the output  
Expression type: Connector output \>\> **oneColNRowResult**  
(Return type: java.util.List)

5. The selected target was the field list\_name

6. Create a form and insert a wigdet:  
List \<java.util.List\>

7. Available values receive the field list\_name

When I save and run the the process, all the output connector parameters are gone.

Please, can somebody help me?

Thanks in advance!!  
Fabi

---

<div class="post-metadata">

**Author:** ![florian.baillagou](https://avatars.discourse-cdn.com/v4/letter/f/b9bd4f/32.png) [@florian.baillagou](https://community.ofelia.com/u/florian.baillagou)\
**Post date:** [10 September 2014 13:36 UTC](https://community.ofelia.com/t/mysql-result-one-column-n-rows-doesnt-works/5133/2 "2014-09-10T13:36:10Z")

</div>

Hummm, your title and your output operation definition say something different.

Title : one column n rows  
Output Operation Definition : Connector output \>\> oneRowNColResult

Is this a typing error ? This could explain why it doesn’t work.

---

<div class="post-metadata">

**Author:** ![Fabi13](https://avatars.discourse-cdn.com/v4/letter/f/e47c2d/32.png) [@Fabi13](https://community.ofelia.com/u/Fabi13)\
**Post date:** [11 September 2014 18:19 UTC](https://community.ofelia.com/t/mysql-result-one-column-n-rows-doesnt-works/5133/3 "2014-09-11T18:19:33Z")

</div>

Hi! Florian,

Sorry, was a typing mistake :o)

The parameters:  
_Edit expression_ window:  
Expression type: Connector output  
Name: nRowOneColResult  
Return type: java.util.List

Maybe there’s a 6.3.2 version’s bug , or the community version doesn’t accepts MySQL connections like that.

PS: I have two another connections (SQL Server and PostGre) working fine.  
I didn’t understand why the connectors (SQLServer and PostGre) informs the column name direct in the field “Takes value of” and in the MySQL connector, the bonita suggests the “resultset” value.

Thanks for your concern,

Fabi

---

<div class="post-metadata">

**Author:** ![florian.baillagou](https://avatars.discourse-cdn.com/v4/letter/f/b9bd4f/32.png) [@florian.baillagou](https://community.ofelia.com/u/florian.baillagou)\
**Post date:** [12 September 2014 06:20 UTC](https://community.ofelia.com/t/mysql-result-one-column-n-rows-doesnt-works/5133/4 "2014-09-12T06:20:24Z")

</div>

Yes, it could be a bug but you need an admin to confirm this.

---

<div class="post-metadata">

**Author:** ![Fabi13](https://avatars.discourse-cdn.com/v4/letter/f/e47c2d/32.png) [@Fabi13](https://community.ofelia.com/u/Fabi13)\
**Post date:** [14 October 2014 19:28 UTC](https://community.ofelia.com/t/mysql-result-one-column-n-rows-doesnt-works/5133/5 "2014-10-14T19:28:58Z")

</div>

I think it’s a bug indeed. So, I try other way to do it.

Thank you for all.  
Fabi ;o)