Connecting Flowable to mysql insted of H2

Hi All,
I want to configure mysql database with my flowable application can anyone suggest me how can i achieve this, which files do i need to edit in order to achieve this or can it be directly achieve without any code change please help.

Hi Anand!

You can configure the database through properties. In the following examples, I’m assuming that you properly set up your DB with a schema named flowable.

If you are building a Spring app, you can simply add the following lines to your files located in your resources:


If you are not using Spring and configure your engines with the flowable.cfg file, you’ll have to add the following:

<beans xmlns=""

<!-- Data Source -->
  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" >
    <property name="driverClassName" value="com.mysql.jdbc.Driver" />
    <property name="url" value="jdbc:mysql://localhost:3306/flowable" />
    <property name="username" value="flowable" />
    <property name="password" value="flowable" />
    <property name="defaultAutoCommit" value="false" />
<!-- Rest of your configuration -->


This will directly configure the data source of your application. You can also change the jdbcUrl, jdbcDriver, jdbcUsername and jdbcPassword directly, see here:

Also make sure that you add the dependeny to the connector to your pom.xml file:

<!-- Other dependencies here -->

<!-- Connector -->

<!-- Other stuff here -->


Further references
You can also have a look at the following sections of the documentation:
Database configuration in general:

Database configuration in Spring Boot: