SQL

Hello,

I have some stored procedure at Microsoft SQL Server, it returns a view ('myview') based on parameters passed:

The stored procedure ('requserinfo') has 3 parameters: @fname; @lname;@locationcode .....

I want to use the procedure to get a user information in the form (something like: FirstName, LastName, Age, Location etc). It is going to be some kind of a search form... I don't have an access to the data source, only can execute the procedure so this is only the way to get the user information....

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

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

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;

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

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

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:

What did I do to get to this?

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

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

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.

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