Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-3425

Error when saving any setting with Derby and on a Project

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0
    • Fix Version/s: 3.0.1, 3.1
    • Component/s: None
    • Labels:
    • Environment:
      Sonar 3.0

      Description

      I've just installed Sonar 3.0 and whenever I try to save any setting in the adminstration (http://localhost:9000/project/settings/1) I get the following error:

      ActiveRecord::JDBCError: Comparisons between 'INTEGER' and 'CHAR (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1'): SELECT * FROM "PROPERTIES" WHERE ("PROPERTIES"."PROP_KEY" = 'sonar.jira.login.secured' AND "PROPERTIES"."RESOURCE_ID" = '1' AND "PROPERTIES"."USER_ID" IS NULL) FETCH FIRST 1 ROWS ONLY
      

      Thanks

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              simon.brandhof Simon Brandhof (Inactive)
              Reporter:
              vmassol Vincent Massol
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: