Tomcat bundle of 7.2.3 is not working with mysql

1
0
-1

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.

1) 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"

2) 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

3) BonitaBPMCommunity-7.2.3-Tomcat-7.0.67/conf/server.xml

commented H2 listner

4) 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"/>

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/business_data?dontTrackOpenResources=true&useUnicode=true&characterEncoding=UTF-8"/>

5) BonitaBPMCommunity-7.2.3-Tomcat-7.0.67/bonita/engine-server/conf/platform/bonita-platform-community-custom.properties

db.vendor=mysql

6) BonitaBPMCommunity-7.2.3-Tomcat-7.0.67/bonita/engine-server/work/tenants/template/bonita-tenant-community.properties

bdm.db.vendor=mysql

7) 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;

8) 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

9) 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)

2 answers

1
0
-1

1
0
-1

did you copy jdbc driver jar in lib/bonita folder ?
can you access to your databases (bonita & business_data) using a third party tools and?

Comments

Submitted by y.suresh247 on Mon, 07/04/2016 - 06:34

Thanks laurent.leseigneur for your reply,

Yes, i have already copied "mysql-connector-java-5.1.6.jar" in Tomcat lib/bonita folders.

I can see some tables are created in "bonita" database
and NO tables are created in "business_data" and gave above mentioned error while starting.

QRTZ_BLOB_TRIGGERS |
| QRTZ_CALENDARS |
| QRTZ_CRON_TRIGGERS |
| QRTZ_FIRED_TRIGGERS |
| QRTZ_JOB_DETAILS |
| QRTZ_LOCKS |
| QRTZ_PAUSED_TRIGGER_GRPS |
| QRTZ_SCHEDULER_STATE |
| QRTZ_SIMPLE_TRIGGERS |
| QRTZ_SIMPROP_TRIGGERS |
| QRTZ_TRIGGERS |
| actor |
| actormember |
| arch_connector_instance |
| arch_contract_data |
| arch_data_instance |
| arch_document_mapping |
| arch_flownode_instance |
| arch_multi_biz_data |
| arch_process_comment |
| arch_process_instance |
| arch_ref_biz_data_inst |
| bar_resource |
| blob_ |
| business_app |
| business_app_menu |
| business_app_page |
| category |
| command |
| connector_instance |
| contract_data |
| custom_usr_inf_def |
| custom_usr_inf_val |
| data_instance |
| dependency |
| dependencymapping |
| document |
| document_mapping |
| event_trigger_instance |
| external_identity_mapping |
| flownode_instance |
| form_mapping |
| group_ |
| job_desc |
| job_log |
| job_param |
| message_instance |
| multi_biz_data |
| page |
| page_mapping |
| pdependency |
| pdependencymapping |
| pending_mapping |
| platform |
| platformCommand |
| proc_parameter |
| process_comment |
| process_content |
| process_definition |
| process_instance |
| processcategorymapping |
| processsupervisor |
| profile |
| profileentry |
| profilemember |
| queriable_log |
| queriablelog_p |
| ref_biz_data_inst |
| report |
| role |
| sequence |
| tenant |
| theme |
| user_ |
| user_contactinfo |
| user_login |
| user_membership |
| waiting_event

Notifications