@ManyToOne(cascade = CascadeType.REFRESH, fetch = FetchType.LAZY)
        @JoinColumn(name = "id_user")
        private Account account;

    @Column(name="id_user", nullable=true)
	private Long id_user;

    @ManyToOne(cascade = CascadeType.REFRESH, fetch = FetchType.LAZY)
        @JoinColumn(name = "id_user")
        private Account account;

    @Override
    @Transactional
    public List<Category> getAllUserCntCom() {
        String sqlQuery = "select user.*, (select count(*) from comment where comment.id_user = user.id_user) as countCom from user";
        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(User.class, sqlQuery);
	return criteria.list();
    }

public class UserDTO {
    protected User user;
    protected Integer cntCom;


    public Integer getCntCom() {
        return cntCom;
    }

    public void setCntCom(Integer cntCom) {
        this.cntCom = cntCom;
    }

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }
}

    @Override
    @Transactional
    public List<Article> getAllUserCntCom(Integer FirstR, Integer MaxR) {
        String sqlQuery = "select new UserDTO(u, countCom) from select user.* as u , (select count(*) from comment where comment.id_user = user.id_user) as countCom from user";
        Query query = sessionFactory.getCurrentSession().createQuery(sqlQuery);
        query.setFirstResult(FirstR);
        query.setMaxResults(MaxR);
                
        return query.list();
    }

public class UserDTO {
    protected Account account;
    protected Integer cntCom;


    public Integer getCntCom() {
        return cntCom;
    }

    public void setCntCom(Integer cntCom) {
        this.cntCom = cntCom;
    }

    public Account getAccount() {
        return account;
    }

    public void setAccount(Account account) {
        this.account = account;
    }
}

    @Override
    @Transactional
    public List<UserDTO> getAllUserCntCom(Integer FirstR, Integer MaxR) {
        String sqlQuery = "select new UserDTO(u, countCom) from select account.* as u , (select count(*) from comment where comment.id_user = account.id_user) as countCom from account";
        Query query = sessionFactory.getCurrentSession().createQuery(sqlQuery);
        query.setFirstResult(FirstR);
        query.setMaxResults(MaxR);
                
        return query.list();
    }

public class UserDTO {
    protected Account account;
    protected Long cntCom;

    public UserDTO() {}
    
    public Long getCntCom() {
        return cntCom;
    }

    public void setCntCom(Long cntCom) {
        this.cntCom = cntCom;
    }

    public Account getAccount() {
        return account;
    }

    public void setAccount(Account account) {
        this.account = account;
    }
}

    @Override
    @Transactional
    public List<UserDTO> getAllUserCntCom(Integer FirstR, Integer MaxR) {
        String sqlQuery = "select account.id_user, account.username, (select count(*) from comment where comment.id_user = account.id_user) as countCom from account";
//        Query query = sessionFactory.getCurrentSession().createQuery(sqlQuery);
//        query.setFirstResult(FirstR);
//        query.setMaxResults(MaxR);
//        
//        query.list();
        
	List list =  sessionFactory.getCurrentSession().createSQLQuery(sqlQuery).list();

	if(list.isEmpty()) {
            return null;
        }
        
        List <UserDTO> results = new ArrayList<UserDTO>();
	for(Object item : list) {
            Object[] array = (Object[]) item;

            UserDTO userDTO = new UserDTO();
            Account account = new Account();
            
            account.setId(((Number)array[0]).longValue());
            account.setUsername((String) array[1]);
            
            userDTO.setAccount(account);
            userDTO.setCntCom(((Number)array[2]).longValue());
            
            results.add(userDTO);
	}
                
        return results;
    }

            <c:forEach items="${userDTO}" var="accDTO">
                ${accDTO.account.id}, ${accDTO.account.username}, ${accDTO.cntCom} |
            </c:forEach>