Following are step to install bonita soft
Step 1. Create two databases named bonita_history and bonita_journal.
Commands:
Create database bonita_history;
Create database bonita_journal;
Step 2. Create user “bonita” with password as “bpm” and grant all permissions for above created two databases.
Commands:
CREATE USER 'bonita'@'localhost' IDENTIFIED BY 'bpm';
GRANT ALL ON bonita_history.* TO 'bonita'@'localhost';
GRANT ALL ON bonita_journal.* TO 'bonita'@'localhost';
Step3. Essentially the downloaded Apache tomcat with BOS configuration uses H2 database and it internally uses hibernate framework for database interaction, and these two file store the database properties required by the BOS . So, we need to modify these two files.
Modify BOS configuration files names bonita-journal.properties and bonita-history.properties, as mentioned below:
(Note:Tthese two files are located at –“ BOS-5.9.1-Tomcat-6.0.35\bonita\server\default\conf”)
Comment the “hibernate.dialect” of H2 database. (Note: To comment out in properties file we use “#”)
Comment “bonita.hibernate.interceptor” attribute as well.
Un comment “hibernate.dialect” and “bonita.hibernate.interceptor” from “Examples- MYSQL” , make sure that the values of these 2 attributes are “org.hibernate.dialect.MySQL5InnoDBDialect” and “org.ow2.bonita.env.interceptor.MySQLDescNullFirstInterceptor” respectively for Mysql database.
Also we need to configure the hibernate properties in context.xml file which is located at “BOS-5.9.1-Tomcat-6.0.35\conf”, the properties which needs to be configured is as shown below (This needs to be done twice for both databases under name – “bonita/default/journal” and “bonita/default/history”) :
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
minIdle="10"
maxWait="10000"
initialSize="1"
maxPoolSize="15"
minPoolSize="3"
maxConnectionAge="0"
maxIdleTime="1800"
maxIdleTimeExcessConnections="120"
idleConnectionTestPeriod="30"
acquireIncrement="3"
testConnectionOnCheckout="true"
removeAbandoned="true"
logAbandoned="true"
username="root"
password="root"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/bonita_journal?dontTrackOpenResources=true"/>
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
minIdle="10"
maxWait="10000"
initialSize="1"
maxPoolSize="15"
minPoolSize="3"
maxConnectionAge="0"
maxIdleTime="1800"
maxIdleTimeExcessConnections="120"
idleConnectionTestPeriod="30"
acquireIncrement="3"
testConnectionOnCheckout="true"
removeAbandoned="true"
logAbandoned="true"
username="root"
password="root"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/bonita_history?dontTrackOpenResources=true"/>
Step5:Once the above configuration is done, add mysql-jdbc diver (
http://dev.mysql.com/downloads/connector/j/ ) into “BOS-5.9.1-Tomcat-6.0.35\lib\bonita” location and remove h2-1.2.139.jar from this location as it is no more required.
step6: Start the tomcat server by navigating to “BOS-5.9.1-Tomcat-6.0.35\bin” location and running command startup.bat from the windows command prompt.
Step7:Once the tomcat server starts hit this url
http://localhost:8080/bonita/ , use default credentials user – “admin” and password- “bpm” to login. If you are able to login with no errors then the configuration is fine.(if not login clear browser cache)
Step8:Bonita creates almost 69 tables into the above 2 created database, to verify execute command “select * from bonita_journal;” from the mysql client.
step9:After the first run you need to comment “hibernate.hbm2ddl.auto” property from bonita-journal.properties and bonita-history.properties files as it is needed to create the table only at first run.
Note:If you have created process in bonita soft studio after that export that process from bonita soft studio and
go in
http://localhost:8080/bonita/ in that left side "Administration " link where processes link there to install new process in that
