[Geoserver-devel] [JIRA] (GEOS-8314) gs-sec-jdbc tests fail with PostgreSQL 10 RC1

GeoServer GeoServer Developer
1

Ben Caradoc-Davies created an issue

GeoServer / BugGEOS-8314

gs-sec-jdbc tests fail with PostgreSQL 10 RC1

Issue Type:

BugBug

Affects Versions:

2.12-RC1, 2.13-beta

Assignee:

Ben Caradoc-Davies

Components:

Security

Created:

01/Oct/17 1:29 AM

Priority:

MediumMedium

Reporter:

Ben Caradoc-Davies

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 pas 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).

Add Comment

Add Comment

Get JIRA notifications on your phone! Download the JIRA Cloud app for Android or iOS

This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100063-sha1:5b66ec3)

Atlassian logo