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

Q&A
1

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

2

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.

3

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

4

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

5

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

Thank you for all.
Fabi ;o)