Database

Attempting to set a Business Data List object from a List using a Postgres Connector

Hello,

I am attempting to use the Postgres 9.2 connector to populate a List business variable.

I have a Business Object called ErrorDetail, and have a Pool Business Variable errorDetailList - List

When I try to populate errorDetails using the "takes value of" from my Groovy script I get the following error:

Script creation DataBase Oracle for business data.

como creo la base de datos para la version 7 the bpm.

BPM7 - How to pass variable in business model instance to a database connector

Update: See my last comment to skip to part of the answer.

I have tried many ways of doing this but not able to find any documentation or videos out there. Maybe the new version is to need.

How do we pass data contained in our process instance of a business model to the connector (Postgresql) SQL query? I have tried several ways without any success:

Problem connecting to external PostgreSQL DB using connector

Bonita BPM 6.5.2. Community PostgreSQL 9.4

I am very new in using Bonita. I am studying it to use in production. I stuck in pretty simply task. I need to create connectors in order to get and update data from/in external client base (PostgreSQL). I created connector in lane, entered correct info for connecting to the database but can't event test connection with simple queries.

Here are my steps:

  1. Choose connector - PostgreSQL 9.2.
  2. Choose driver - PostgreSQL.

  3. Enter DB access information. DB is hosted locally.

How to make cascading dropdowns with database values?

Hi all!

I want to add three cascading dropdowns in one of my forms. Each dropdown values are dependent to the one above it. The values are mapped in a mysql database.

Based on what I read, one possible approach is to use the HTML widget, manually code the dropdowns, and use jquery and ajax to handle the events/queries on each dropdown. I can then use bonita's rest API to pass the values from each dropdowns into predefined bonita variables which can be used in succeeding tasks/forms.

where the instances are stored?

Hello people, I'm using the tool recently, use the open source version, and I'm finding diciculdades because whenever I run my process again, I lose the previous instances. Anyone know where this is stored? it is stored in memory or it is? or is this a limitation of the version I'm using?

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 :

How to Display table data as form

I m using following code for retrive record from table .

Update a row in a business object

Hi,

I would like to update a row in my business object. How can I do that ? If i use transient data I modify the list but not the actual object.

I'm using the default h2 database.

Thanks for your answers,

Pauline

Possible to save a file/picture in the database ?

Hi,

I need to know if it's possible to save a picture or a file in a business object? Thanks for your answers,

Pauline

Notifications