Hi everybody.
I have an application developed under JBoss 4.0.1; in this AS there is hibernate3.1; i have used this version of hibernate for acceding to my DB; i have done a select count by using this sintax:
protected Query getQueryCount(BaseFilter filter) throws ValidateException, DaoException, IllegalParameterException { . . . String query = " select count(distinct tbasmusr.id) from TbaSmUsr tbasmusr where " +" tbasmusr.tbuSmUsrOus.size = 0 and tbasmusr.id != 0 "; query = query + " and tbasmusr.id != " + idLogged ; String nameUser = userFilter.getName(); if( !PropertyValidator.isNullable( nameUser )){ query = query + " and ( tbasmusr.name like '%" + nameUser + "%' or tbasmusr.surname like '%" + nameUser + "%' or tbasmusr.socialName like '%" + nameUser + "%' )"; } String userType = userFilter.getUserType(); if( !PropertyValidator.isNullable( userType )){ query = query + " and tbasmusr.type like '" + userType+"'" ; } return getSession().createQuery( query ); }