I have downloaded BonitaBPMCommunity-7.2.3-Tomcat-7.0.67 tomcat bundle and i am trying to configure “mysql” db for that i made below changes in respective files.
- BonitaBPMCommunity-7.2.3-Tomcat-7.0.67/bin/setenv.sh
DB_OPTS=“-Dsysprop.bonita.db.vendor=mysql”
BDM_DB_OPTS=“-Dsysprop.bonita.bdm.db.vendor=mysql”
- BonitaBPMCommunity-7.2.3-Tomcat-7.0.67/conf/bitronix-resources.properties
commented h2 properties and uncommented mysql properties as below
resource.ds1.className=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
resource.ds1.driverProperties.user=bonita
resource.ds1.driverProperties.password=bpm
resource.ds1.driverProperties.URL=jdbc:mysql://localhost:3306/bonita?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8
resource.ds2.className=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
resource.ds2.driverProperties.user=bonita
resource.ds2.driverProperties.password=bpm
resource.ds2.driverProperties.URL=jdbc:mysql://localhost:3306/business_data?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8
- BonitaBPMCommunity-7.2.3-Tomcat-7.0.67/conf/server.xml
commented H2 listner
- BonitaBPMCommunity-7.2.3-Tomcat-7.0.67/conf/Catalina/localhost/bonita.xml
commented h2 config and uncommented mysql config as below
<Resource name="bonitaSequenceManagerDS"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
maxActive="17"
minIdle="5"
maxWait="10000"
initialSize="3"
validationQuery="SELECT 1"
validationInterval="30000"
removeAbandoned="true"
logAbandoned="true"
username="bonita"
password="bpm"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/bonita?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8"/>
- BonitaBPMCommunity-7.2.3-Tomcat-7.0.67/bonita/engine-server/conf/platform/bonita-platform-community-custom.properties
db.vendor=mysql
- BonitaBPMCommunity-7.2.3-Tomcat-7.0.67/bonita/engine-server/work/tenants/template/bonita-tenant-community.properties
bdm.db.vendor=mysql
- Created two dbs with utf-8 support as “business_data” and bonita
CREATE DATABASE business_data DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE bonita DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
- Removed H2 jars BonitaBPMCommunity-7.2.3-Tomcat-7.0.67/lib/bonita/
bonita-tomcat-h2-listener-1.0.1.jar and h2-1.3.170.jar
- Copied mysql jar to lib
When i am staring tomcat and accessing portal, below error i am getting. Please help and Thanks in advance
ERROR: Table ‘bonita.platform’ doesn’t exist
2016-06-30 09:15:14.856 +0530 org.bonitasoft.engine.scheduler.impl.SchedulerServiceImpl org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4
JImpl log
SEVERE: THREAD_ID=15 | HOSTNAME=VER-BLR-LT1239 | java.lang.IllegalArgumentException: null source
org.bonitasoft.engine.scheduler.exception.SSchedulerException: java.lang.IllegalArgumentException: null source
at org.bonitasoft.engine.scheduler.impl.QuartzSchedulerExecutor.schedule(QuartzSchedulerExecutor.java:100)
at org.bonitasoft.engine.scheduler.impl.SchedulerServiceImpl.internalSchedule(SchedulerServiceImpl.java:197)
at org.bonitasoft.engine.scheduler.impl.SchedulerServiceImpl.schedule(SchedulerServiceImpl.java:160)
at org.bonitasoft.engine.api.impl.transaction.platform.ActivateTenant.startEventHandling(ActivateTenant.java:144)
at org.bonitasoft.engine.api.impl.transaction.platform.ActivateTenant.execute(ActivateTenant.java:93)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.activateDefaultTenant(PlatformAPIImpl.java:837)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.initializePlatform(PlatformAPIImpl.java:168)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:187)
at org.bonitasoft.engine.PlatformTenantManager.createPlatform(PlatformTenantManager.java:42)
at org.bonitasoft.engine.EngineInitializer.initPlatform(EngineInitializer.java:140)
at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:93)
at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:42)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5077)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5591)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:677)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1939)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalArgumentException: null source
at java.util.EventObject.(EventObject.java:56)
at javax.sql.StatementEvent.(StatementEvent.java:64)
at com.mysql.jdbc.jdbc2.optional.JDBC4PreparedStatementWrapper.close(JDBC4PreparedStatementWrapper.java:70)
at bitronix.tm.resource.jdbc.JdbcUncachedPreparedStatementHandle.close(JdbcUncachedPreparedStatementHandle.java:60)
at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at com.sun.proxy.$Proxy5.close(Unknown Source)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.closeStatement(StdJDBCDelegate.java:3287)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.jobExists(StdJDBCDelegate.java:784)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.jobExists(JobStoreSupport.java:1130)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1104)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$2.executeVoid(JobStoreSupport.java:1062)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3703)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3701)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:245)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1058)
at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:886)
at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:249)
at org.bonitasoft.engine.scheduler.impl.QuartzSchedulerExecutor.schedule(QuartzSchedulerExecutor.java:95)
… 24 more
2016-06-30 09:15:14.857 +0530 org.bonitasoft.engine.api.impl.PlatformAPIImpl org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: THREAD_ID=15 | HOSTNAME=VER-BLR-LT1239 | org.bonitasoft.engine.scheduler.exception.SSchedulerException: java.lang.IllegalArgumentException: null source
org.bonitasoft.engine.scheduler.exception.SSchedulerException: org.bonitasoft.engine.scheduler.exception.SSchedulerException: java.lang.IllegalArgumentException: null source
at org.bonitasoft.engine.scheduler.impl.SchedulerServiceImpl.internalSchedule(SchedulerServiceImpl.java:206)
at org.bonitasoft.engine.scheduler.impl.SchedulerServiceImpl.schedule(SchedulerServiceImpl.java:160)
at org.bonitasoft.engine.api.impl.transaction.platform.ActivateTenant.startEventHandling(ActivateTenant.java:144)