Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-3854

DSpace 5 PostgreSQL JDBC Driver doesn't work well with Postgres 10

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.8
    • Fix Version/s: 5.9, 6.3, 7.0
    • Component/s: DSpace API
    • Labels:
      None
    • Attachments:
      0
    • Comments:
      12
    • Documentation Status:
      Not Required

      Description

      DSpace 5.x comes with a very old PostgreSQL JDBC driver (v9.1-901-1.jdbc4): https://github.com/DSpace/DSpace/blob/dspace-5_x/pom.xml#L1162

      If you install DSpace 5 with more recent versions of Postgres (especially Postgres 10), Groups can no longer be created.  Specifically a NullPointerException occurs when DSpace attempts to create the default Administrator/Anonymous groups.

      The fix is to simply update to the newest version of the PostgreSQL driver (currently 42.2.1). As noted in its documentation, this new driver works for Postgres 8 and above. See: https://github.com/pgjdbc/pgjdbc#supported-postgresql-and-java-versions 

      A sample of configuring this new driver in Maven can be found at: https://github.com/pgjdbc/pgjdbc#maven-central

      I've not tested whether DSpace 6 would also be affected by similar issues. It also uses a very old JDBC driver (v9.4.1211): https://github.com/DSpace/DSpace/blob/dspace-6_x/pom.xml#L27

        Attachments

          Activity

            People

            Assignee:
            tdonohue Tim Donohue
            Reporter:
            tdonohue Tim Donohue
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: