Menu

Mysql installation problem

Help
2011-02-02
2013-05-23
  • Jean-Luc Beltrami

    When I try to start Express in Tomcat Manager, Start operation ends with following status:
             ECHEC - L'application pour le chemin de contexte /express-0.8-RC1 n'a pas puêtredémarrée

    I installed last MySQL 5.1 connector/J (v5.1.14) but i still got the same error

    Error reported in Tomcat log is:
    INFO: Initializing Spring root WebApplicationContext
    2 févr. 2011 11:20:45 org.apache.catalina.core.StandardContext listenerStart
    GRAVE: Exception lors de l'envoi de l'évènement contexte initialisé (context initialized) à l'instance de classe d'écoute (listener) org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'accessRequestDao' defined in file : Unsatisfied dependency expressed through constructor argument with index 0 of type : : Error creating bean with name 'entityManagerFactory' defined in file : Cannot resolve reference to bean 'jpaVendorAdapter' while setting bean property 'jpaVendorAdapter'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibaseDbMigrator' defined in file : Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:db-changelog.xml::9::adam:
         Reason: liquibase.exception.StatementNotSupportedOnDatabaseException: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns:
              Caused By: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in file : Cannot resolve reference to bean 'jpaVendorAdapter' while setting bean property 'jpaVendorAdapter'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibaseDbMigrator' defined in file : Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:db-changelog.xml::9::adam:
         Reason: liquibase.exception.StatementNotSupportedOnDatabaseException: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns:
              Caused By: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns
    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:718)
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:194)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:993)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:897)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:574)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
    at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:850)
    at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:724)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:493)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
    at org.apache.catalina.core.StandardService.start(StandardService.java:516)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in file : Cannot resolve reference to bean 'jpaVendorAdapter' while setting bean property 'jpaVendorAdapter'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibaseDbMigrator' defined in file : Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:db-changelog.xml::9::adam:
         Reason: liquibase.exception.StatementNotSupportedOnDatabaseException: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns:
              Caused By: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1317)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1076)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:838)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:780)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:697)
    at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:784)
    at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:711)
    … 39 more
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibaseDbMigrator' defined in file : Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set classpath:db-changelog.xml::9::adam:
         Reason: liquibase.exception.StatementNotSupportedOnDatabaseException: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns:
              Caused By: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1412)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:281)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
    … 53 more
    Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set classpath:db-changelog.xml::9::adam:
         Reason: liquibase.exception.StatementNotSupportedOnDatabaseException: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns:
              Caused By: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns
    at liquibase.ChangeSet.execute(ChangeSet.java:260)
    at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
    at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
    at liquibase.Liquibase.update(Liquibase.java:112)
    at liquibase.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:214)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)
    … 62 more
    Caused by: liquibase.exception.StatementNotSupportedOnDatabaseException: liquibase.database.sql.RenameColumnStatement is not supported on MySQL: columnDataType is required to rename columns
    at liquibase.database.sql.RenameColumnStatement.getSqlStatement(RenameColumnStatement.java:72)
    at liquibase.database.template.JdbcTemplate.applyVisitors(JdbcTemplate.java:90)
    at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:75)
    at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:48)
    at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
    at liquibase.change.AbstractChange.execute(AbstractChange.java:247)
    at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
    at liquibase.ChangeSet.execute(ChangeSet.java:236)
    … 68 more
    2 févr. 2011 11:20:45 org.apache.catalina.core.ApplicationContext log
    INFO: Set web app root system property: 'express' =
    2 févr. 2011 11:20:45 org.apache.catalina.core.ApplicationContext log
    INFO: Initializing log4j from
    2 févr. 2011 11:20:45 org.apache.catalina.core.ApplicationContext log
    INFO: Shutting down log4j
    2 févr. 2011 11:20:45 org.apache.catalina.core.ApplicationContext log
    INFO: Closing Spring root WebApplicationContext

     
  • Chaitanya

    Chaitanya - 2011-05-03

    Is there any solution for the above problem? I tried to install express on tomcat 6.0.30 and configured to use MySQL as database and when I start the tomcat the above exception occurs.

    Are there any additional configurations needed for MySQL?

    I have downloaded tool for evaluation and am stuck at installation itself. Early response will help me to provide right feedback to my management regarding the usage of this tool.

    Thanks
    Chaitanya

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.