<bean id="userDetailsService" class="com.icesoft.icefaces.acegi.OurUserDetailsService">

	</bean>

public class OurUserDetailsService implements UserDetailsService {
    
    private Connection authenticationConnection;

    public UserDetails loadUserByUsername(String username)
            throws UsernameNotFoundException, DataAccessException {

        authenticationConnection = DBObject.getInstance().setupConnection("icefaces","icefaces","localhost","usertable");

        try{
            Statement authenticationStatement = authenticationConnection.createStatement();
            
            ResultSet results = authenticationStatement.executeQuery("SELECT user_id, user_enabled, user_password, user_locked, FROM usertable WHERE username = \"" + username + "\";");
            if(results.first()){
                int id = results.getInt(1);
                Boolean enabled = results.getBoolean(2);
                String password = results.getString(3);
                Boolean locked = results.getBoolean(4);
            
                results = authenticationStatement.executeQuery("SELECT ug.group_id, g.group_name FROM usergroups ug, groups g WHERE ug.group_id = g.group_id AND ug.user_id = \"" + id + "\" ORDER BY g.group_id;");
                ArrayList tempGrantedAuthorities = new ArrayList();
                while (results.next()) {
                    GrantedAuthority temp = new GrantedAuthorityImpl("ROLE_" + results.getString("group_name"));
                    tempGrantedAuthorities.add(temp);
                }
                GrantedAuthority[] grantedAuthorities = new GrantedAuthority[tempGrantedAuthorities.size()]; 
                tempGrantedAuthorities.toArray(grantedAuthorities);
                             
                authenticationStatement.close();
                return new User(username,password,enabled,Boolean.TRUE,Boolean.TRUE,locked,grantedAuthorities);
            }else{
                throw new UsernameNotFoundException("Username Not Found");
            }
        }catch (SQLException sqe) {
            sqe.printStackTrace();
        }
        return null;
    }

}