Uploaded image for project: 'Apache Fineract'
  1. Apache Fineract
  2. FINERACT-1276

Unknown table 'TABLE_NAMES' in information_schema

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Feedback Received
    • Affects Version/s: None
    • Fix Version/s: 1.5.0
    • Component/s: None
    • Labels:
      None

      Description

      After building the latest develop branch, I can not spring boot fineract i get the error below

      Error creating bean with name '(inner bean)#707f107c': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantDatabaseUpgradeService': Invocation of init method failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback;
      bad SQL grammar [SHOW TABLES LIKE 'schema_version';];
      nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'TABLE_NAMES' in information_schema

      Query being executed when exception was thrown:
      SHOW FULL COLUMNS FROM `information_schema`.`TABLE_NAMES`

      if you look at  org\apache\fineract\infrastructure\core\service\TenantDatabaseUpgradeService.java
      line 133 this is where it all starts 

      But i cannot figure out where the SHOW FULL COLUMNS FROM `information_schema`.`TABLE_NAMES` line is 

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                francisguchie Francis Guchie
                Reporter:
                francisguchie Francis Guchie
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: