#database

Hibernate error on named query, server doesn't start : how to fix BDM on server without any access to the admin interface ?

Hello.

I have a problem with an hibernate error on a named query.

I have deployed on a Bonita server a bad BDM with an error in a custom query. The deploy succeed but an hibernate error occurs and the server doesn't start after the update.

Date type is stored in BDM database as string/varchar?

We are using Bonita 7.6.1 with MySQL, and recently realised that the date fields/data are stored as character string/varchar inside the business database? How do we do date-based queries on the business database now?

Anyone has faced/solved this issue please reply.

Upload excel file format to database

Hello everyone, how to upload excel file format (xls or csv) to database in bonita?

Table filled with null each row

Hello Everyone,

Currently im having an issue with my table row. almost all of my table row filled with null. Does anybody here ever experienced this problem? what are the solution to overcome this? and what makes the row filled with null by itself? Here I give you screenshot of my table.
https://www.dropbox.com/s/27cvjfaiky1667i/row%20terisi%20null.PNG?dl=0

Has anyone faced the ORA-01691 unable to extend lob segment problem?

Hi,

we are using bonita bpm community edition 7.7.4 with an oracle 12c enterprise database.
We started with a fresh user schema, but after a few weeks of usage the error occured the first time.

Right now bonita tries to extend the lobsegment area by ~ 5GB of data... which is (even with the autoextend options) not possible...

We have removed all active process instances, but the problem still comes up...

Anyone has or had the same problem or can anyone tell me where to find the data, which our bonita node tries to write into the database?

Can the application be deployed locally?

My customer security requirements wont allow their data to be hosted off site.
Can the application and data be deployed/hoted locally?

How to use DB in-connector?

I want to get data from the database and display it on the WEB screen table.

However, although it seems to use DB connector for the entrance connector, I do not know what to do in "definition of output operation".

Can you tell me what to do?

How to avoid using XA data source, when both the business-db and bonita-db in same host?

I'm using Bonita 7.6.1 with Mysql 5.7.

How to avoid usage of XA data source/connector when both Bonita and business databases in the same host. I've seen the non-XA datasources defined somewhere in the configuration, but I couldn't find where to specify it, so that Bonita will use the non-XA data sources.

Way to connect to my simple form application with postgres database, as by default we are on H2 db?

In the documentation you have given quite difficult approach to connect to any database. Please provide some easy way to do the same thing.

How to write dynamic query in bonita studio bdm?

I have five filter fields in my application home page (dashboard -> where I am showing all the records from h2 DB) now I want to filter the records on these fields basis.
It may require 31 (2^5 -1) queries, some are already provided as default queries.

Isn't there a way to write a dynamic query in "custom queries" or somewhere to get the desired result at UI?

Notifications