@Test
  public void testModifyCollaborator() {
    RiverCollaborator collaborator = riverCollaboratorDao.findById(1L);
    collaborator.setActive(false);
    collaborator.setReadOnly(true);
    riverDao.updateCollaborator(collaborator);
    em.flush();

    String sql =
        "SELECT river_id, account_id, collaborator_active, read_only FROM river_collaborators WHERE id = ?";
    Map<String, Object> results = this.jdbcTemplate.queryForMap(sql, 1L);

    assertEquals(false, results.get("collaborator_active"));
    assertEquals(true, results.get("read_only"));
  }