bonitasoft to Mysql
i create a connector with bonitasoft to Mysql workbench 8.0.16:
when i test, i get this message:
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?
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
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.
thanks, I download MySQL Connector/J 8.0, but how i add it to bonita?
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?
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.
thank you all Laurant and Antoine:
yes sir antoine; I think it is best solution.
this is my draft projet:
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.
thank you all.