Examples of QueryPos


Examples of com.liferay.portal.kernel.dao.orm.QueryPos

        String sql = query.toString();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(meetupsEntryId);

        qPos.add(status);

        list = (List<MeetupsRegistration>)QueryUtil.list(q,
            getDialect(), start, end);
      }
      catch (Exception e) {
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.QueryPos

    Query q = session.createQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(meetupsEntryId);

    qPos.add(status);

    if (orderByComparator != null) {
      Object[] values = orderByComparator.getOrderByValues(meetupsRegistration);

      for (Object value : values) {
        qPos.add(value);
      }
    }

    List<MeetupsRegistration> list = q.list();
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.QueryPos

        String sql = query.toString();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(meetupsEntryId);

        count = (Long)q.uniqueResult();
      }
      catch (Exception e) {
        throw processException(e);
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.QueryPos

        String sql = query.toString();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(userId);

        qPos.add(meetupsEntryId);

        count = (Long)q.uniqueResult();
      }
      catch (Exception e) {
        throw processException(e);
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.QueryPos

        String sql = query.toString();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(meetupsEntryId);

        qPos.add(status);

        count = (Long)q.uniqueResult();
      }
      catch (Exception e) {
        throw processException(e);
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.QueryPos

        Session session = (Session) dbConnection.getNativeConnection();
        SQLQuery query = null;

        try {
            query = session.createSQLQuery(sql);
            QueryPos qpos = QueryPos.getInstance(query);
            for (Object item: params) {
                qpos.add(item);
            }
            log.debug(sql + "\n" + params);
            query.executeUpdate();
        } catch (Exception e) {
            throw new DBException(e);
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.QueryPos

        Session session = (Session) dbConnection.getNativeConnection();
        SQLQuery query = null;

        try {
            query = session.createSQLQuery(sql);
            QueryPos qpos = QueryPos.getInstance(query);
            for (Object item: params) {
                qpos.add(item);
            }
            log.debug(sql + "\n" + params);
            items = query.list();
//            for (Object item : items) {
//                if (item != null) {
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.QueryPos

      try {
        session = openSession();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        if (status != null) {
          qPos.add(status);
        }

        List<Warrant> list = q.list();

        result = list;
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.QueryPos

      try {
        session = openSession();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        if (createDate != null) {
          qPos.add(CalendarUtil.getTimestamp(createDate));
        }

        if (status != null) {
          qPos.add(status);
        }

        qPos.add(expirationWarningSent);

        List<Warrant> list = q.list();

        result = list;
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.QueryPos

      try {
        session = openSession();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(userId);

        List<Warrant> list = q.list();

        result = list;
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.