bonitasoft 7.8 + mysql Problem insert from a form

Q&A
1

Hello everyone,
I’m using bonitasoft 7.8 and the mysql database.
I want to insert data from a form using a connector into my database mysql.
I managed to insert static data but using a form I do not know how to do it and how to link data in form and in the connector
Thanks for your help

2

i have two process variables “nom” and “prenom” declared in my pool and i have a script task with a connector query like:
return “INSERT INTO tabletest (nom,prenom) VALUES ('”+nom+“', '”+prenom+“')”;
but when i test there is an error : input parameter ‘script’ use an expression containing unreachable reference