Issues with MySQL connector config - output values

Hi,

I'm using BonitaSoft 6.2.1 Studio, community edition, 64bit

Linux 12.04LTS 64bit

In the last few days (since I've first installed Bonita), I've been trying to create a simple link to a test table and pull out a list (for a drop-down box).

I'm right now in a situation where the validation of the connector works OK when I work on the connector but I CANNOT have the connector accept any variable as an output to be used in the form.

I'm going to try and post some images to better describe my problem.

 

This is what I've done so far:

(1) Created a clean process with one step in it (Step 1). For step 1, I'm configuring a connector:

      https://dl.dropboxusercontent.com/u/7204972/Bonita/Screenshot%20from%202014-02-10%2009%3A50%3A09.png

 

(2) The connector shows that the above jar is active for this connector

      https://dl.dropboxusercontent.com/u/7204972/Bonita/Screenshot%20from%202014-02-10%2010%3A32%3A17.png

 

(3) Entering the correct credential for the local database

      https://dl.dropboxusercontent.com/u/7204972/Bonita/Screenshot%20from%202014-02-10%2009%3A52%3A28.png

 

(4) Specifying a test query to pull a list of a single column, in the test table

      https://dl.dropboxusercontent.com/u/7204972/Bonita/Screenshot%20from%202014-02-10%2009%3A59%3A09.png

 

(5) Performing a validation test with the mysql-connector-java-5.1.23-bin

      https://dl.dropboxusercontent.com/u/7204972/Bonita/Screenshot%20from%202014-02-10%2009%3A59%3A32.png

 

(6) I get positive results and the content of this column is being returned:

      https://dl.dropboxusercontent.com/u/7204972/Bonita/Screenshot%20from%202014-02-10%2010%3A00%3A07.png

 

(7) I'm moving to define, with the graphical option, the output of this query into a variable

      https://dl.dropboxusercontent.com/u/7204972/Bonita/Screenshot%20from%202014-02-10%2010%3A43%3A28.png

      https://dl.dropboxusercontent.com/u/7204972/Bonita/Screenshot%20from%202014-02-10%2010%3A43%3A46.png

 

(8) Defining a value with multiple options (List)

      https://dl.dropboxusercontent.com/u/7204972/Bonita/Screenshot%20from%202014-02-10%2010%3A01%3A21.png

 

(9) and HERE is where I get stuck. Whatever value I try to add (even a Java object), when I click on OK - there is no output value in the connector. I get back to this screen and no value is assigned. When I pull-down that menu - it is ALWAYS empty. There is an option (link) to add values from there, but even if I do try to add values - they will never show in the pull-down):

      https://dl.dropboxusercontent.com/u/7204972/Bonita/Screenshot%20from%202014-02-10%2010%3A00%3A40.png

 

Can someone please help and point to what am I doing wrong? How can I select a variable and add it to the output?

I even tried to first set a list variable in the data section of Step1 but I cannot see this variable name either when I try to select an output for the connector.

Help..?

Hi

I know what you mean, I think that should be related to a bug.

But I would like to share with you that I've tested the same scenario in the new version Bonita Community Edition v. 6.2.2 and it works fine.

Hope it is helpful for you.

let me know

Domenico