/** * * Executes {@link Connection#rollback() and * frees the connection object * @see org.geoserver.security.jdbc.JDBCUserGroupService#load() */ public void load() throws IOException { // Simply roll back the transaction try { getConnection().rollback(); releaseConnection(); } catch (SQLException ex) { throw new IOException(ex); } setModified(false); //fireUserGroupChangedEvent(); }
/** * Executes {@link Connection#commit()} and frees * the connection * * @see org.geoserver.security.GeoServerUserGroupStore#store() */ public void store() throws IOException { // Simply commit the transaction try { getConnection().commit(); releaseConnection(); } catch (SQLException ex) { throw new IOException(ex); } setModified(false); //fireUserGroupChangedEvent(); }
public void associateUserToGroup(GeoServerUser user, GeoServerUserGroup group) throws IOException { Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("groupmembers.insert", con); ps.setString(1,group.getGroupname()); ps.setString(2,user.getUsername()); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); }
public void disAssociateUserFromGroup(GeoServerUser user, GeoServerUserGroup group) throws IOException { Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("groupmembers.delete", con); ps.setString(1,group.getGroupname()); ps.setString(2,user.getUsername()); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); }
public boolean removeUser(GeoServerUser user) throws IOException { Connection con = null; PreparedStatement ps = null; boolean retval = false; try { con = getConnection(); ps = getDMLStatement("users.delete", con); ps.setString(1,user.getUsername()); ps.execute(); retval= ps.getUpdateCount()>0; ps.close(); ps = getDMLStatement("userprops.deleteForUser",con); ps.setString(1,user.getUsername()); ps.execute(); ps.close(); ps = getDMLStatement("groupmembers.deleteUser", con); ps.setString(1,user.getUsername()); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); return retval; }
public boolean removeGroup(GeoServerUserGroup group) throws IOException { Connection con = null; PreparedStatement ps = null; boolean retval=false; try { con = getConnection(); ps = getDMLStatement("groups.delete", con); ps.setString(1,group.getGroupname()); ps.execute(); retval = ps.getUpdateCount()>0; ps.close(); ps = getDMLStatement("groupmembers.deleteGroup", con); ps.setString(1,group.getGroupname()); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); return retval; }
public void addGroup(GeoServerUserGroup group) throws IOException { Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("groups.insert", con); ps.setString(1,group.getGroupname()); ps.setString(2,convertToString(group.isEnabled())); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); }
public void updateGroup(GeoServerUserGroup group) throws IOException { Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("groups.update", con); ps.setString(1,convertToString(group.isEnabled())); ps.setString(2,group.getGroupname()); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); }
/** * @see org.geoserver.security.GeoServerUserGroupStore#initializeFromServer(org.geoserver.security.GeoServerUserGroupService) */ public void initializeFromService(GeoServerUserGroupService service) throws IOException { jdbcService= (JDBCUserGroupService) service; setSecurityManager(service.getSecurityManager()); this.name=jdbcService.getName(); this.passwordEncoderName=service.getPasswordEncoderName(); this.passwordValidatorName=service.getPasswordValidatorName(); this.datasource=jdbcService.datasource; this.ddlProps=jdbcService.ddlProps; this.dmlProps=jdbcService.dmlProps; try { getConnection().commit(); } catch (SQLException e) { throw new IOException(); } }
@Override public GeoServerUserGroupStore createStore(GeoServerUserGroupService service) throws IOException { JDBCUserGroupStore store = (JDBCUserGroupStore) super.createStore(service); try { JDBCTestSupport.dropExistingTables(store, store.getConnection()); } catch (SQLException e) { throw new IOException(e); } store.createTables(); store.store(); return store; }
@After public void dropExistingTables() throws Exception { if (store != null) { JDBCUserGroupStore jdbcStore = (JDBCUserGroupStore) store; JDBCTestSupport.dropExistingTables(jdbcStore, jdbcStore.getConnection()); store.store(); } }
@Override protected void tearDownInternal() throws Exception { super.tearDownInternal(); if (store!=null) { JDBCUserGroupStore jdbcStore =(JDBCUserGroupStore)store; JDBCTestSupport.dropExistingTables(jdbcStore,jdbcStore.getConnection()); store.store(); } }
@Override public GeoServerUserGroupStore createStore(GeoServerUserGroupService service) throws IOException { JDBCUserGroupStore store = (JDBCUserGroupStore) super.createStore(service); try { JDBCTestSupport.dropExistingTables(store,store.getConnection()); } catch (SQLException e) { throw new IOException(e); } store.createTables(); store.store(); return store; }
@Override public GeoServerUserGroupStore createStore(GeoServerUserGroupService service) throws IOException { JDBCUserGroupStore store = (JDBCUserGroupStore) super.createStore(service); try { JDBCTestSupport.dropExistingTables(store,store.getConnection()); } catch (SQLException e) { throw new IOException(e); } store.createTables(); store.store(); return store; }
@Override public GeoServerUserGroupStore createStore(GeoServerUserGroupService service) throws IOException { JDBCUserGroupStore store = (JDBCUserGroupStore) super.createStore(service); try { JDBCTestSupport.dropExistingTables(store, store.getConnection()); } catch (SQLException e) { throw new IOException(e); } store.createTables(); store.store(); return store; }
@Override public GeoServerUserGroupStore createStore(GeoServerUserGroupService service) throws IOException { JDBCUserGroupStore store = (JDBCUserGroupStore) super.createStore(service); try { JDBCTestSupport.dropExistingTables(store,store.getConnection()); } catch (SQLException e) { throw new IOException(e); } store.createTables(); store.store(); return store; }
@Override public GeoServerUserGroupStore createStore(GeoServerUserGroupService service) throws IOException { JDBCUserGroupStore store = (JDBCUserGroupStore) super.createStore(service); try { JDBCTestSupport.dropExistingTables(store, store.getConnection()); } catch (SQLException e) { throw new IOException(e); } store.createTables(); store.store(); return store; } }
@Override protected void tearDownInternal() throws Exception { super.tearDownInternal(); JDBCRoleStore rs = (JDBCRoleStore) roleStore; JDBCTestSupport.dropExistingTables(rs, rs.getConnection()); roleStore.store(); JDBCUserGroupStore ugs = (JDBCUserGroupStore) ugStore; JDBCTestSupport.dropExistingTables(ugs, ugs.getConnection()); ugStore.store(); }
@After public void dropTables() throws Exception { if (roleStore != null) { JDBCRoleStore jdbcStore1 = (JDBCRoleStore) roleStore; JDBCTestSupport.dropExistingTables(jdbcStore1, jdbcStore1.getConnection()); roleStore.store(); } if (usergroupStore != null) { JDBCUserGroupStore jdbcStore2 = (JDBCUserGroupStore) usergroupStore; JDBCTestSupport.dropExistingTables(jdbcStore2, jdbcStore2.getConnection()); usergroupStore.store(); } }
@Override protected void tearDownInternal() throws Exception { super.tearDownInternal(); if (roleStore!=null) { JDBCRoleStore jdbcStore1 =(JDBCRoleStore) roleStore; JDBCTestSupport.dropExistingTables(jdbcStore1,jdbcStore1.getConnection()); roleStore.store(); } if (usergroupStore!=null) { JDBCUserGroupStore jdbcStore2 =(JDBCUserGroupStore) usergroupStore; JDBCTestSupport.dropExistingTables(jdbcStore2,jdbcStore2.getConnection()); usergroupStore.store(); } }