AnsweredAssumed Answered

Spring boot with Activiti Example along with MySQL

Question asked by harishkadamudi on Sep 1, 2016
Latest reply on Sep 2, 2016 by jbarrez
Hi there,
I am following the code committed by jbarrez, git link mentioned below.
https://github.com/jbarrez/spring-boot-with-activiti-example

I have query here, i am trying to connect the above code with mysql. I tried having MAVEN dependency of MYSQL along with related changes in application.properties file but no success.
Could you please help me on this.

The only change being to the pom is adding mysql dependency.
                 <dependency>
         <groupId>mysql</groupId>
         <artifactId>mysql-connector-java</artifactId>
      </dependency>

application.properties file

# ===============================
# = DATA SOURCE
# ===============================

# Set here configurations for the database connection

# Connection url for the database
spring.datasource.url = jdbc:mysql://localhost:3306/activiti?useSSL=false

# Username and password
spring.datasource.username = root
spring.datasource.password = root

# Keep the connection alive if idle for a long time (needed in production)
spring.datasource.testWhileIdle = true
spring.datasource.validationQuery = SELECT 1

# ===============================
# = JPA / HIBERNATE
# ===============================

# Use spring.jpa.properties.* for Hibernate native properties (the prefix is
# stripped before adding them to the entity manager).

# Show or not log for each sql query
spring.jpa.show-sql = true

# Hibernate ddl auto (create, create-drop, update): with "update" the database
# schema will be automatically updated accordingly to java entities found in
# the project
spring.jpa.hibernate.ddl-auto = create-drop

# Naming strategy
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy

# Allows Hibernate to generate SQL optimized for a particular DBMS
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

Outcomes