daoUtil.executeQuery( );

        while ( daoUtil.next( ) )
        {
            AnnounceSubscribtionDTO subscription = new AnnounceSubscribtionDTO( );
            subscription.setIdSubscription( daoUtil.getInt( 1 ) );
            subscription.setUserId( daoUtil.getString( 2 ) );
            subscription.setSubscriptionProvider( daoUtil.getString( 3 ) );
            subscription.setSubscriptionKey( daoUtil.getString( 4 ) );
            subscription.setIdSubscribedResource( daoUtil.getString( 5 ) );
            subscription.setEmailSubscribes( daoUtil.getString( 6 ) );
            listSubscription.add( subscription );
        }

        daoUtil.free( );

        return listSubscription;
    }