Uploaded image for project: 'Gateway'
  1. Gateway
  2. GTWY-2177

Quotes Required in Role Adding Liquibase Changeset

XMLWordPrintable

    • Icon: Defect Defect
    • Resolution: Won't Do
    • Icon: Minor Minor
    • Recycle Bin
    • 1.3.0-M1
    • Database
    • None

      If a database administrator chooses to name a new role "user" and exception will occur due to "user" being a reserved word in postgres.



      SEVERE: Exception sending context initialized event to listener instance
      of class org.springframework.web.context.ContextLoaderListener
      org.springframework.beans.factory.BeanCreationException: Error creating
      bean with name 'datasetFactory' defined in class path resource
      [sgf/gateway/model/model-context.xml]: Cannot resolve reference to bean
      'defaultMetadataProfileStrategy' while setting constructor argument;
      nested exception is
      org.springframework.beans.factory.BeanCreationException: Error creating
      bean with name 'defaultMetadataProfileStrategy' defined in class path
      resource [sgf/gateway/model/model-context.xml]: Cannot resolve reference
      to bean 'hibernateMetadataDao' while setting constructor argument;
      nested exception is
      org.springframework.beans.factory.BeanCreationException: Error creating
      bean with name 'hibernateMetadataDao' defined in class path resource
      [sgf/gateway/dao/metadata/impl/hibernate/metadata-dao-context.xml]:
      Cannot resolve reference to bean 'hibernateSessionFactory' while setting
      bean property 'sessionFactory'; nested exception is
      org.springframework.beans.factory.BeanCreationException: Error creating
      bean with name 'databaseInstaller' defined in class path resource
      [sgf/gateway/dao/dao-context.xml]: Invocation of init method failed;
      nested exception is java.lang.RuntimeException:
      liquibase.exception.MigrationFailedException: Migration failed for
      change set
      classpath:liquibase/update-v2/changesets/20100407-SGF-1093.xml::20100407-SGF-1093::sgf:
            Reason: liquibase.exception.DatabaseException: Error executing SQL
      GRANT USAGE ON SCHEMA curator TO user: ERROR: syntax error at or near
      "user":
                 Caused By: Error executing SQL GRANT USAGE ON SCHEMA curator
      TO user: ERROR: syntax error at or near "user":
                 Caused By: ERROR: syntax error at or near "user"

              Unassigned Unassigned
              estanislao.gonzalez Estanislao Gonzalez (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: