SQL

Using DB connector

Hi everyone!

I would like to know if someone can help me how to use the DB Connector for SQL Server.

I have already created the Connector to an automatic task, configure the sql query and use the graphical mode (N to N in this case) to assign the resultset to a variable type java.util.List

Is it okay to use a java.util.List variable to load the tableResult?

unique constraint violation sql exception on server but not on local test

Hi,

On the production server, we get an error that we don't encounter on my local test machine.

When a specific task is validated, an operation updates the text of the variable "autorGCAutreStatut" in the BDM "LL". At that point the variable already has some text in it and we add more text there.

It works well when testing on a local machine but on the production server, I get a long exception where the sql query "insert into LL_autorGCAutreStatut ..." is executed but a unique constraint violation is encountered.

MSSQL Connector issue: How to execute a stored procedure with parameters, Microsoft 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....

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

Notifications