stored procedure

How to Execute a Stored Procedure call in Bonita Studio


I'm trying to execute a stored procedure in Bonita Studio. The stored procedure is stored at a mysql database server, so currently I'm using a MYSQL Connector, but if it's unsuitable, I don't mind changing my approach. What I've done:

Execute a stored procedure

Good Morning,

i need to execute a stored procedure that returns a row. The stored procedure requires one string parameter, and returns a row. Then, i want to save the values of the row (5 columns) in independent variables. What is the best way to do this?

I'm doing it in a groovy script but it is giving me the following error:

No suitable driver found for jdbc:sqlserver://hostSql;database=DBName.

I'm using this code in the groovy script:

`import groovy.sql.Sql;