Uploaded image for project: 'GeoServer'
  1. GEOS-8314

gs-sec-jdbc tests fail with PostgreSQL 10 RC1

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.12-RC1, 2.13-beta
    • Fix Version/s: 2.12.1, 2.13-beta
    • Component/s: Security
    • Labels:
      None

      Description

      For tests, gs-sec-jdbc uses an ancient postgresql 8.4-701.jdbc3 jar that does not work with PostgreSQL 10. Tests fail in Maven. Tests pass in Eclipse only because the more recent 42.1.1 jar used everywhere else is a transitive dependency via gs-main in the Eclipse dependency model.

      Tests in error: 
        testRoleDatabaseSetup(org.geoserver.security.jdbc.PostGisRoleServiceTest): org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)
        testIsModified(org.geoserver.security.jdbc.PostGisRoleServiceTest): org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)
        testInsert(org.geoserver.security.jdbc.PostGisRoleServiceTest): org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)
        testModify(org.geoserver.security.jdbc.PostGisRoleServiceTest): org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)
        testRemove(org.geoserver.security.jdbc.PostGisRoleServiceTest): org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)
        testConfiguration(org.geoserver.security.jdbc.PostGisUserDetailsServiceTest): org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)
        testRoleCalculation(org.geoserver.security.jdbc.PostGisUserDetailsServiceTest): org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)
        testPersonalizedRoles(org.geoserver.security.jdbc.PostGisUserDetailsServiceTest): org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This ResultSet is closed.)
        testUserGroupDatabaseSetup(org.geoserver.security.jdbc.PostGisUserGroupServiceTest)
        testIsModified(org.geoserver.security.jdbc.PostGisUserGroupServiceTest)
        testPasswordRecoding(org.geoserver.security.jdbc.PostGisUserGroupServiceTest)
        testEraseCredentials(org.geoserver.security.jdbc.PostGisUserGroupServiceTest)
        testEmptyPassword(org.geoserver.security.jdbc.PostGisUserGroupServiceTest)
        testInsert(org.geoserver.security.jdbc.PostGisUserGroupServiceTest)
        testModify(org.geoserver.security.jdbc.PostGisUserGroupServiceTest)
        testRemove(org.geoserver.security.jdbc.PostGisUserGroupServiceTest)
      

      Solution is to upgrade the postgresql driver (and put it under dependency management to match GeoTools).

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                bencaradocdavies Ben Caradoc-Davies
                Reporter:
                bencaradocdavies Ben Caradoc-Davies
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Stride room