public List<RegisterObjectDTO> getObjectList(
          ObjectFilterDTO filter,
          Integer start,
          Integer count) {

    List<RegisterObjectDTO> result = new ArrayList<RegisterObjectDTO>();
    try {
      String queryStr = "SELECT o FROM PrsObjEntity o WHERE " +
              "o.tin IS NOT NULL ";

      if (filter.getOin() != null) {
        queryStr += " AND o.oin = " + filter.getOin();
      }

      if (filter.getTin() != null) {
        queryStr += " AND o.tin LIKE '" + filter.getTin() + "%'";
      }

      if (filter.getName() != null) {
        queryStr += " AND o.nameObj LIKE '%" + filter.getName() + "%'";
      }

      if (filter.getStatus() != null) {
        queryStr += " AND o.rfStatusId = " + filter.getStatus();
      }

      if (filter.getDistCode() != null) {
        queryStr += " AND o.distCode LIKE '" + filter.getDistCode() + "'";
      }

      if (filter.getRegLowerBound() != null) {
        queryStr += " AND o.entDt >= TO_DATE(:startDate,'YYYY-MM-DD')";
      }
      if (filter.getRegUpperBound() != null) {
        queryStr += " AND o.entDt <= TO_DATE(:endDate,'YYYY-MM-DD')";
      }

      if (filter.getTypeObjId() != null) {
        queryStr += " AND o.rfTypeobjId = " + filter.getTypeObjId();
      }

      if (filter.getAddress() != null) {
        String lowerAddress = filter.getAddress().toLowerCase();
        String[] lowerAddressArray = lowerAddress.split("\\s+");
        if (lowerAddressArray != null && lowerAddressArray.length > 0) {
          for (String item : lowerAddressArray) {
            queryStr += " AND (lower(o.city) LIKE '" + item + "%'" +
                    " OR lower(o.street) LIKE '" + item + "%'" +
                    " OR lower(o.houseNo) LIKE '" + item + "%'" +
                    " OR lower(o.aptNo) LIKE '" + item + "%'" +
                    " OR o.tel LIKE '%" + item + "%')";
          }
        }
      }

      Query query = em.createQuery(queryStr);
      query.setHint("openjpa.hint.OracleSelectHint", "/*+ first_rows(1) */");

      if (start != null && start >= 0) {
        query.setFirstResult(start);
      }
      if (count != null && count > 0) {
        query.setMaxResults(count);
      }

      if (filter.getRegLowerBound() != null) {
        query.setParameter("startDate", ConversionsUtils.formatDateForDB(filter.getRegLowerBound()));
      }
      if (filter.getRegUpperBound() != null) {
        query.setParameter("endDate", ConversionsUtils.formatDateForDB(filter.getRegUpperBound()));
      }

      List<PrsObjEntity> list = query.getResultList();

      for (PrsObjEntity item : list) {
        result.add(populate(item));
      }
    } catch (Exception ex) {
      ex.printStackTrace();
      log.error("Error while getting object list", ex);
    }

    return result;
  }

 private SessionFactory sessionFactory;  
    
//    @PersistenceContext(name="bankdemoPU")
//    private EntityManager em;
// 
     
    public List<Users> getUserList() {        
        List<Users> list = null;     
        try {
            String query_string = "from Users o";
           list=sessionFactory.getCurrentSession().createQuery(query_string).list();   
//           sessionFactory.getCurrentSession().persist(list);
             //= query.getResultList();
//            messages = new Vector(list.size());
//            for (int i = 0; i < list.size(); i++) {
//                Users[] result = list.get(i);
//                Users message = new Users();
//                message.setId(result[0]);
//                message.setUsername((String) result[3]);             
//                messages.add(message);
//            }

        } catch (Exception ex) {
           ex.printStackTrace();
        } 
        return list;