We're updating the issue view to help you get more done. 

gs-sec-jdbc tests fail with PostgreSQL 10 RC1

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.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 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).

Environment

None

Status

Assignee

Ben Caradoc-Davies

Reporter

Ben Caradoc-Davies

Triage

None

Fix versions

Affects versions

2.12-RC1
2.13-beta

Components

Priority

Medium