Configured mysql instead of default h2,when server staring,there are many errors
,like"table xxx does not exist".
server.xml
<Resource name=“jdbc/ProcessEngine”
auth=“Container”
type=“javax.sql.DataSource”
factory=“org.apache.tomcat.jdbc.pool.DataSourceFactory”
uniqueResourceName=“process-engine”
driverClassName=“com.mysql.jdbc.Driver”
url=“jdbc:mysql://localhost:3306/camunda?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC”
defaultTransactionIsolation=“READ_COMMITTED”
username=“root”
password=“123456”
maxActive=“20”
minIdle=“5”
maxIdle=“20”
@yuwanzi1314 you need to enable processEngineConfig.setDatabaseSchemaUpdate("true"); programatically or the property camunda.bpm.datasource.databaseSchemaUpdate=true in properties file. It will create all the necessary tables and indexes required for your process.
