groovy connector

Is a Postgres/SQL UPDATE statement limited to a maximum length?

Hi all,

I am using a sql update statement like this in a Groovy Out connector:

"sql.execute("UPDATE table SET col3=$bdmvar3, [and another 40 variables...].WHERE col1=$bdmvar1")"

The length of this statement is approximately 1300 characters. When I try to execute it, I get this syntax error:

Caused by: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "is" Position: 588

BDM and Groovy script

I use the following Groovy script to retrieve data stored in the BDM. In the BDM I defined a "business Object" called "Rutas" that has two "attributes", "nombreRuta" and "valor".
The script I use is:

import com.company.model.Rutas
List rtSubir = rutasDAO.findByNombreRuta("rutaSubir",0,100)

return rtSubir

But I fails. I think that left me something, but I can not to find out what it is.
Any suggestions?. Thank you.

frederic.krebs
Category: 

Created on Bonita BPM version : 6.3.3

Objectives: Execute an external groovy script

You can edit the script without recompiling neither redeploying the process on the server * Use as a form widget connector, it allows you to edit the script and refresh the screen to see the result * Use as a Form transiant data connector, it allows you to edit the script and refresh the screen to see the result * Use as an activity connector, it allows you to edit the script, restart a new process instance and see the changes

Releases for Execute External Groovy Script Connector

Total downloads: 1 347
Version BonitaBPM Version Post date Download Link
First release 6.5.x, 6.4.x, 6.3.x 2015-Jun-10 Download
1347 downloads
Release note

Groovy Connector Exception while evaluating expression

Hi folks,

I'm having occasionally this exception thrown: org.bonitasoft.connectors.scripting.GroovyConnector - Exception : Exception while evaluating expression

I set up a Groovy script connector to retrieve user details using the code as below:

GroovyConnector class not found

Bonita BPM 5.7 Server Glassfish : 3.1.2 JDK : 1.7

We have the exception listed below while calling a groovy script connector in a task. In glassfish3\glassfish\domains\domain1\bonita-server-v5.7.2\server\default\tmp there are scripting-5.7.2.jar listed. Is there any other reference to the groovy jars? Where do we have to put the classpath references? Thanks in advance

How to display table on conformation task page .

i m using bonitasoft community 6.3 on confromation i just downloaded defauly html generated. and add table on it , but now i want to display some process variable's data into that table . how can i get this process variable data from that html

pl pl specify need code .

how can i refactor this code .

Hidden button at the connector grovy

Bonita BPM 6.3.0.

In the form "output operetions" from the "grovy" connector, the button "add" disappears when the number of outputs is large. Would require a vertical scroll bar.

Email Task URL to user

at the end of TASK 1 i create one email connector

in email body , i switch to script editor and as per documentation i paste following code ,

Groovy script cannot find depenedencies

Hi,

I am a newbee to Bonita BPM and am trying to create a groovy script connector. I dont get errors when i test the connector as i manually check dependencies but when i run the process it fails as it cannot find the jar files i think. How do i get my process to get dependencies at runtime?

This is the log file.

How to Create Document in PDF with forms All content

I create one from with all employee detail now i want to add action on submit button .

when it clicked : document is generated of all detail and email to the employee email id

Pl can i know how to achieve it . how to generate document .

Thanks kandarp

Notifications