how to do BonitaBPMCommunity-6.0.0 mysql database connection

Q&A
1

Hi team,

i created mysql database name(bonita)
C:\BonitaBPMCommunity-6.0.0\workspace\tomcat\conf

i removed this line ( In SERVER.XML

andthis a files name(bitronix-resources.xml) i disable h2 database connection ofter that add mysql example

this is my system path (C:\BonitaBPMCommunity-6.0.0\workspace\tomcat\conf\Catalina\localhost) Inside bonita.xml(i disable h2 database connection ofter that add mysql example)

this is my system path (C:\BonitaBPMCommunity-6.0.0\workspace\tomcat\bin) inside setenv.bat file(set DB_OPTS=“-Dsysprop.bonita.db.vendor=mysql”)
this is my system path(C:\BonitaBPMCommunity-6.0.0\workspace\tomcat\lib\bonita) inside add mysql jar varsion(mysql-connector-java-5.0.4-bin)
my working mysql path(C:\Program Files (x86)\MySQL) inside query browser
plz help me
Reagrds
Ram

ERROR
Unable to check if a default tenant already exists: org.hibernate.exception.SQLGrammarException: could not execute query

2

Hi,

To understand the context, can you let me know why you are using version 6.0.0? I would really recommend to use the latest release available in order to Benefit from all the bug fixes.

Thanks