#Mysql

Hi,it is my first time to bonita(2021.1) community edition.

I have a simple task that needs to connect to an external database (mysql 8.0.26) using a connector (default: mysql 5.5 jdbc database query 4), but there is an error, I searched a lot and found that the reason is probably the lack of compatibility between versions. So I tried to add file (mysql-connector-java 8.0.26.jar) to tomcat path and to my project in bonita in java dependencies and make this file active when should select or add database driver but it didn't work, and I still had the same error:

Hi All,

I am trying to connect to a MySQL 5.5 database using the connector available in Bonita. I get the following error.

Hola!

Estoy comenzando con bonita community y estoy desarollando unos procesos para una fabrica. En unos de mis formularios necesitaria acceder a la base de datos para poder mosotrar como criterios de seleccion alguna de las piezas que actualmente estan en fabricacion. ¿ Como puedo relizar esto?

Muchas gracias de antemano

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.

Hello,

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.

Hi

Anybody tried Bonita 7.6.* with Mysql 8.0, It is throwing unable to connect to db error.

Hello,

Hello All,

I changed the workspace/tomcat/setup/database.properties file as follows:

bdm.db.vendor=mysql
bdm.db.server.name=localhost
bdm.db.server.port=3306
bdm.db.database.name=bonita_business
bdm.db.user=bonita
bdm.db.password=bonita

However, when I modify and reset the BDM it isn't deployed to database, it remains empty, with no tables. The tomcat log only contains this:

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