topic Re: liquibase cannot be created when using mysql in Alfresco Forum

liquibase cannot be created when using mysql

ycl — Thu, 11 Jan 2018 15:14:15 GMT

With Activiti 6, I've tried activiti-app with H2 database and it works fine. But when I try to switch to mysql, tomcat failed to start with errors below:12-Jan-2018 10:55:13.063 INFO [localhost-startStop-2] org.apache.catalina.core.ApplicationContext.log SessionListener: contextDestroyed()12-Jan-201

Re: liquibase cannot be created when using mysql

ryandawson — Thu, 11 Jan 2018 18:32:14 GMT

Are you sure there isn't more to that stacktrace if you go further down? I'd expect there to be something on why the liquibase can't be instantiated.

Re: liquibase cannot be created when using mysql

ycl — Fri, 12 Jan 2018 07:27:21 GMT

I solved this problem.

The exception stack log is not the real problem, actually it's a result.

Because the database user I gave activit-app does not have full access to mysql database, on startup creation of acitivit-app database did not finish correctly. These exception stack log is from the second start of tomcat.

After I gave full access to database, delete all the tables and restart tomcat, activiti-app works fine.