Error in DataBase Change ,Spring boot


#1

spring boot ,IDEA can reproduce my problem
Next are my steps:
1、 download a project from start.spring.io ,import it into IDEA
2、add dependency : camunda-bpm-spring-boot-starter 、 com.h2database 、mysql
3、create file camunda.cfg.xml,add my mysql profile
4、start my service
When I delete or add user , it will change my database (mysql not H2 ), H2 database seems no help。
However,if I delete the dependency of H2, It can not start service then. It seems the dependency camunda-bpm-spring-boot-starter need H2

I can’t figure out it ? How can I delete H2 dependency ? I do not want to use database H2, but I need to make camunda into spring boot …What dependency should I use to replace camunda-bpm-spring-boot-starter or How can I delete H2 dependency

Help ! Thank you so much , My English is not very good

Error creating bean with name ‘org.camunda.bpm.spring.boot.starter.CamundaBpmAutoConfiguration$ProcessEngineConfigurationImplDependingConfiguration’: Unsatisfied dependency expressed through field ‘processEngineConfigurationImpl’; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘processEngineConfigurationImpl’ defined in class path resource [org/camunda/bpm/spring/boot/starter/CamundaBpmConfiguration.class]: Unsatisfied dependency expressed through method ‘processEngineConfigurationImpl’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘camundaDatasourceConfiguration’: Unsatisfied dependency expressed through field ‘transactionManager’; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type ‘org.springframework.transaction.PlatformTransactionManager’ available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}


#2

Did you configure the datasource url when you switched from h2 to mysql?
This is not specific to camunda, you will find results when you check for spring boot, mysql, jpa configuration.


#3

Thank you so much for helping me . The datasource url is right, it can connect to my database. I do not figure out how camunda works. By keeping studying , I can figure out it .


#4

@yxyjw999 maybe you need to setup datasource like this,

Based on your requirement, you can change DataSource & TransactionManager type.