Database

Using a Variable in a Query

Hello all,

I have been attempting to insert a variable into a query and have found many different posts around the internet telling me to do it many different ways. For example... if I had the query

select veg_cat_code from geo_feat where geo_feat_id = '5';

I want to have it be

select veg_cat_code from geo_feat where geo_feat_id = 'variableToBeQueriedWith';

I can't seem to find out how to do this. I've read that

select veg_cat_code from geo_feat where geo_feat_id = '${variableToBeQueriedWith}';

Connecting a mySQL database

Hello,

I'm extremely new when it comes to Bonita BPM and am having troubles connecting to my MySQL database. I can't seem to find any guides out there that are for the most recent version of Bonita BPM. Could someone give me a short tutorial and help walk me through what I need to do?

Thanks for your time,
Aaron

Setup Information:

Driver: com.mysql.jdbc.Driver
URL: jdbc:mysql://localhost:3306/firstdatabase
username:root
password:*******

Query: select * from testing where test_id = 'testingquery';

Show SQL Server connector Resultset in a table

Hi everyone Im using a SQL Server connector and saving the result in a multiple variable, but the value doesn´t seem to be in json format, so how can I show the result in a table widget in the UI Designer?

Regards,

Is it possible to write to a table from inside an Event Handler class?

How do I write to a table from inside an Event Handler class? I need to make an insert from an event handler.

For example:
```
package com.company.event;

import java.util.UUID;

Database cleaned on restart by default

Is there any reason why the checkboxes "On exit, clean database", "Clean business data database on exit" are checked by default?

I'm struggling to come up with even one good reason.

How to call process variable into user interface in bonita 7 [ need tutorial ]

Hello guys,

I'm interested about BPM and I've installed bonita 5 and 7 in my computer.
I've created my process business into bpm modeling, and now i'm in phase of developing my business process into application ( UI Designer ).
In my modeling process, i've created a process variable ( Java Object - java.util.List [No Coding, Just Created] ) to stored my MySQL - query ( Created using Graphical Connector In ).

Can somebody explain me what I have to do to make a database connection work? Get a exception and i have no idea how to fix it.

Hello,
I'm pretty new to Bonita bpm.
At the moment I'm experimenting with it, and try to discover the capabilities of it. (because it could be interesting for our research institute)
I created my first lane with a simple process, and now I want to make a database connection to my Orcale 11g Express edition database.

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.

7.1 - Access connectors dynamically on multi-page forms

I am working with Bonita BPM 7.1, starting to build multi-page forms. It looks like the database connector functionality provides what I need in terms of querying an external database. However, I need to access the connector dynamically within the page. For example, first page-> Select person last Name, second page -> display list of matching people with selection. So between these steps I need to execute a parameterized query to the database. I can build a connector-in, but it always runs before the form.

Notifications