bonitasoft to Mysql

Q&A
1

hi ;
i create a connector with bonitasoft to Mysql workbench 8.0.16:
when i test, i get this message:

java.lang.reflect.InvocationTargetException
org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | org.bonitasoft.engine.core.connector.exception.SConnectorException: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long

what does this means?
how i resolve it?

2

Hi,

The problem seems with your version of MySQL in combination with your version of mysql-connector.jar. Try a newer version of MySQL Connector/J.

best

3

Hi,

the error says “java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long”

this means you have a trouble in the way you pass parameters or retrieve results back from the MySql connector.

can you share a .bos of your process involving this connector ? and also a SQL to create/populate the table

thanks,

L.

4

this is my draft projet:
https://drive.google.com/file/d/1S41kzbqJSzy3gBtd1bKPz__k1QvlIG4U/view?u…

5

thanks, I download MySQL Connector/J 8.0, but how i add it to bonita?

6

Hi,

Have you created your own connector or are you using the default MySQL connector available in the Studio?

If you are using the default connector, you can specify the jdbc driver during the configuration of the connector (2nd screen of the configuration wizard).

If you have created your own connector, here is some additional info about how to manage jars in the Studio.

If the error persists, please send us the structure of the table you are trying to query, the connector configuration and the complete error trace

best

7

thanks Mbonita;
I am using the default connector.
I just discovered that bonita 7.8 does not support version 8 of Mysql. so I am installing mysql version 5.5 to create my databases. I do not know if it’s the right solution or not?

8

If you don’t have an existing database already populate with some data I highlight suggest that you use Business Data Model (BDM) feature of Bonita. It makes the business data management a lot easier by creating for you Java classes to manipulate data in your process, also create tables in database to store them and finally provide easy solution to save new data, update existing data and delete data.

You can learn more about BDM in the Bonita Camp a series of video to learn allow the core features of Bonita Community Edition.

9

thank you all Laurant and Antoine:

yes sir antoine; I think it is best solution.

this is my draft projet:
https://drive.google.com/file/d/1S41kzbqJSzy3gBtd1bKPz__k1QvlIG4U/view?usp=sharing

10

Hi,

As a clarification regarding MySQL support. Bonita 7.8 works with MySQL 5.5.27 and higher. Here is the detailed information about hardware and software requirements .

This list refers to the databases that Bonita platform will use to store process related data. The connector you are trying to configure is a way for you to potentially access to external data (ie business data) available in an existing/external database. When using the default MySQL connector you should make sure that the driver you are using is compatible with the version of your MySQL database.

As Laurent and Antoine have pointed out, if you don’t have yet your own database you should give a try to the Bonita BDM capability.

Hope it helps

11

sir Mbonita:
they said in point 3 in “hardware and software requirements”: Note that Bonita BPM does not work with MySQL 8.x.

yes i will try with BDM;
but i want to know what the problem;
actually, when i test the configuration it 's correct with mode graphique, but it give NXN as resultat type.

12

You are right. Bonita 7.9 is the one compatible with MySQL 8.x. Here is the right link to the 7.9. documentation .

13

thank you all.