public static List<UserFlatMapping> checkMobileNumberValidForGroupz(String query) { List<UserFlatMapping> membersList = null; DatabaseSession session = sessionFactory.newDatabaseSession(); try { SQLQuery results = constructMobileNumberValidForGroupzQuery(query); System.out.println("Final SQL Qry:" + results.toString()); membersList = (List<UserFlatMapping>) results.addEntity("userflatmapping", UserFlatMapping.class).list(); System.out.println("Final Groupz List:" + membersList.size()); session.close(); } catch (Exception e) { // TODO: handle exception } return membersList; }