SQL

SQL Datasource Connector - Log level

Hi guys,

Is this possible to change the Log Level for the SQL Datasource connector ?
I think in the code it might write INFO messages (Request and Results ...)

1- Should I make a product update request for it to be set to DEBUG ?
2- If let to INFO, is it possible to change the Logging config for this connector Specifically :
2a - in the Studio ?
2b - on the Server once deployed ?

Thank you for your answers :)
Pierre

Installation Mysql Database Bonita BPM platform

Hi,
Following the official documentation and new to ubuntu / MySQL / Bonita I wish to setup a Bonita BPM platform.
I downloaded the Tomcat-bundle and I wish to setup MySQL Database.

But when looking at the official documentation, the Database must be configured, (it is writed literaly everywhere) there is no informations / guide for MySQL database.

Here is the only thing they say for MySQL :
*MySQL
Maximum packet size

Selecting multiple set of data from Oracle db

Hi,
I use Bonita BPM 7.3.1 local on Windows 7. I m novice at bonita
I have a question. I need to select some data sets from Oracle DB.
I d read a lot of topics at this forum and others.
And I resolve this problem like this:

  1. I create Process Variable with type List
  2. Then I create in Connectors In new Connector to my base with query , scripting Mode and assign to my process variable (type List) data from query result, by this script:

    import java.util.logging.Logger;
    import groovy.json.JsonBuilder;

groovy conectors, problem accesing bdm data

Greetings, Im having troubles with the bonita MicrosoftSQL server2008 conector. I need to make a query that depends on the data stored on the bdm. The exact problem is I can't access the bdm data from the groovy script witch is creating th query

thanks a lot for the help

Mauro

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

Postgres query result (List of lists) fills only the first column in form Table

I am a new to java and Bonita (although not to BPM) and I am trying to display a sql query result in a standard Bonita UI table version 7.1 (using the Table widget). But all the data ends up in the most left column like this example below:

1OWTwFcV.png

What did I do to get to this?

I defined a postgresql dataconnector, that shows a working Array when testing:

1OVozpJJ.png

Variable in DB Connector

Hello I'm trying to pass a whole sql string into the connector.

For example i have the var SQLSTRING

then in the connector i only write ${SQLSTRING}

when i try to test the connector the following message appears

"Type of expression not admitted for test:
-Entry parameter ´script' is using an expression that contains an unreachable reference"

why is this happening?

Thanks

How can I query 2 different tables and get the result in 2 different result sets using 1 connector

Hi,

I want to know if it is possible to use only one connector in order to execute 2 or more different select querys and store the returned values in differents resultsets.

And also if it is possible how to do it

Thanks.

LLenar un widget select en el UIDesigner desde base de datos sql

Que tal estimados, estoy tratando de llenar un select dentro del UIDesigner mediante base de datos SQL, ¿alguien tiene idea de como hacerlo?, les comento que hice una business variable donde el valor default es una lista proveniente de la consulta del SQL, mas no se como relacionar esa variable dentro del UIDesigner y no se si sea la forma correcta de hacerlo, cualquier apoyo es bueno!

  • Estoy en la versión 7 de bonitasoft
  • Java versión 8.
  • Windows 7

Gracias y Saludos

When try to pass variable into query of database connector it gives error

hello ,

i m using on service task which give ti list of pant based on parameter of user's city i m using oracle 10 database connector .

Detail description ,

  1. perameter : NDS
  2. query : "Select title from plant_mst where unit_id=NDS"

this is perfactly run . but when i try dynamic query .

Select title from plant_mst where unit_id = " + city(variable- which store users city =NDS)

it gives error : Invelid Identifier . what i m doing wrong .

Here is server log :

Notifications