topic Activiti 6.0 MySql db configuration. Error:Could not create connection to database server. in Alfresco Forum

Activiti 6.0 MySql db configuration. Error:Could not create connection to database server.

juhi_gupta — Wed, 27 Feb 2019 10:16:08 GMT

I am using activiti 6.0 and trying to configure MySql db for activiti app and activiti rest. Here are my mysql database config for the activiti-rest and activiti-app -activiti-app.propertiesdatasource.driver=com.mysql.jdbc.Driverdatasource.url=jdbc:mysql://127.0.0.1:3306/activitidb?characterEncoding

Re: Activiti 6.0 MySql db configuration. Error:Could not create connection to database server.

salaboy — Thu, 28 Feb 2019 08:48:09 GMT

Hi Juhi,

Does this schema: activiti exists in your database?

Re: Activiti 6.0 MySql db configuration. Error:Could not create connection to database server.

juhi_gupta — Thu, 28 Feb 2019 09:42:19 GMT

Hi Mauricio Salatino,
Thanks for your prompt reply.
Yes, I have created a database connection 127.0.0.1:3306/activitidb and created a mysql DB with the name 'activitidb'. I checked the schema of the db and it does exist.

Re: Activiti 6.0 MySql db configuration. Error:Could not create connection to database server.

salaboy — Thu, 28 Feb 2019 11:06:19 GMT

This is the normal list of problems while connecting to the DB:

https://confluence.atlassian.com/confkb/connections-could-not-be-acquired-from-the-underlying-database-104825087.html

Also I would check:

hibernate.dialect=org.hibernate.dialect.MySQLDialect

Usually your DBs in Mysql are InnoDB.. so you might need a different

dialect..

Can you please check that?

Re: Activiti 6.0 MySql db configuration. Error:Could not create connection to database server.

juhi_gupta — Fri, 01 Mar 2019 04:30:16 GMT

Hi,

We configured the hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

and upgraded the jar to mysql-connector-java-8.0.11.jar

Thanks.