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

Fix support of PostgreSQL 10.0

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.7
    • Fix Version/s: 6.7.1, 7.0
    • Component/s: Database
    • Labels:
      None

      Description

      SonarQube 6.7 fails with Postgres 10. Error comes from JDBC driver:

      ### Error updating database.  Cause: org.postgresql.util.PSQLException: Returning autogenerated keys is only supported for 8.2 and later servers.
      

      The solution is to upgrade the driver to 42.1.4 or greater.
      As a workaround for SonarQube 6.7 LTS users, the content of directory lib/jdbc/postgresql must be replaced with https://jdbc.postgresql.org/download/postgresql-42.1.4.jar

      Thanks to @mirabilos for the feedback: https://twitter.com/mirabilos/status/928666582531768320

        Attachments

          Activity

            People

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

              Dates

              Due:
              Created:
              Updated:
              Resolved: