Problems with BBDD Bonita
We have problems when synchronizing Bonitasoft with SQL Server, many problems, some tables are created if others do not, they give us errors when creating the business objects in Bonitasoft, is there any version of Bonitasoft that comes already installed by default with SQL Server or MySql?
Is there any expert person who can solve the problem by remote desktop or some Bonitasoft service?
Nor does it allow us to access the H2 database, it gives us many errors, for example:
Broken connection: "java.net.ConnectException: Connection refused: connect: localhost: 9091"
Connection is broken: "java.net.ConnectException: Connection refused: connect: localhost: 9091" [90067-175] 90067/90067 (Help)
Thank you very much.
OK...now I kow what you want to do:
The only thing we need is to see the Bonita tables that come by default, we want to see the tables where Bonita saves the users of the login, we want to see the tables where it saves the names of the tasks, the names of the processes, etc etc, for Get information and KPIs.
I'm assuming Windows - If Linux - you have to modify this for your self...
- Download and Install Bonitasoft Studio
- Open Studio,wait until its finished setting up and then exit
- Goto the directory {{BonitaInstallDirectory}}\workspace\tomcat\server\lib\bonita
- Open h2-1.3.175.jar (double click)
Driver Class = org.h2.Driver
jdbc:h2:file: {{BonitaInstallDirectory}}\workspace\default\h2_database\bonita_journal.db
user name = sa
password = (leave blank)
- Click Connect
and there you have it all the Bonitasoft tables as already described...
Regarding the paid for version you can only talk to Bonitasoft - use their official form here
regards
Seán
PS: As this reply answers your question, please mark as resolved.
Comments
what version are you using? also community or subscription?
My company uses the community version
what version 6 or 7 7.1 7.2.1 etc...
I am sorry.
We have 7.4.3
I'm Confused...
but the easy question first... is there any version of Bonitasoft that comes already installed by default with SQL Server or MySql? No
What do you mean by this...
We have problems when synchronizing Bonitasoft with SQL Server, many problems, some tables are created if others do not, they give us errors when creating the business objects in Bonitasoft
When you say ...they give us errors... why didn't you include the errors? We're not mind readers...please give us the information we need to help you.
Then you say:
Nor does it allow us to access the H2 database, it gives us many errors
If you are using SQL Server (assumed from the first question) then of course you will not be able to use the h2 database...you're not using it!
When asking questions please try to be clear, and give as much information about the error as possible.
1) What are you trying to do
2) What you did/tried to do
3) What the error was
regards
Hello,
Sorry for the confusion.
The only thing we need is to see the Bonita tables that come by default, we want to see the tables where Bonita saves the users of the login, we want to see the tables where it saves the names of the tasks, the names of the processes, etc etc, for Get information and KPIs.
We have seen some online manual on how to do this, but the manuals are not very specific.
My version installed in the company is 7.4.3.
Also my company wants to know how much the payment version is worth, and know what advantages it has.
Thank you very much
Best regards