Example usage for org.hibernate.query Query uniqueResult

Introduction

In this page you can find the example usage for org.hibernate.query Query uniqueResult.

Prototype

@Override
    R uniqueResult();

Source Link

Usage

From source file:accesobd.AccesoVistas.java

License:BSD License

/**
 * Obtiene una vista a partir de su identificador.
 * @param idVista//from   w w w  .ja  va 2 s .  c o m
 * @return 
 */
public AdmVista obtenerVista(int idVista) {
    AdmVista vista;

    Session sesion;
    sesion = HibernateUtil.getSessionFactory().openSession();

    try {

        Query q = sesion.createQuery("from AdmVista where id = :id");
        q.setParameter("id", idVista);

        vista = (AdmVista) q.uniqueResult();

    } catch (Exception e) {
        vista = null;
        System.out.println(e.toString());
    } finally {
        sesion.close();
    }

    return vista;

}

---

From source file:com.codeup.hibernate.repositories.CategoriesRepository.java

public Category with(int id) {
    Query query = session.createQuery("FROM Category WHERE id = ?");
    query.setParameter(0, id);//from  w  w  w . j  ava 2  s .c o  m

    return (Category) query.uniqueResult();
}

---

From source file:com.codeup.hibernate.repositories.MoviesRepository.java

public Movie with(int id) {
    Query query = session.createQuery("FROM Movie WHERE id = ?");
    query.setParameter(0, id);/*from ww  w  . j a  v a2 s . c o  m*/

    return (Movie) query.uniqueResult();
}

---

From source file:com.evolveum.midpoint.repo.sql.AuditCleanupPerformanceTest.java

License:Apache License

private void prepareAuditEventRecords() throws Exception {
    long start = System.currentTimeMillis();
    for (int i = 0; i < RECORDS;) {
        AuditEventRecord record = new AuditEventRecord();
        record.addDelta(createObjectDeltaOperation(i));
        record.setTimestamp(System.currentTimeMillis());
        record.addPropertyValue("prop1", "val1");
        record.addReferenceValue("ref1",
                ObjectTypeUtil.createObjectRef("oid1", ObjectTypes.USER).asReferenceValue());
        auditService.audit(record, new SimpleTaskAdapter());
        i++;/*  ww  w .  ja v  a 2s .com*/
        if (i % 1000 == 0 || i == RECORDS) {
            long duration = System.currentTimeMillis() - start;
            System.out.println(
                    i + " records created in " + duration + " ms (" + duration / i + " ms per record)");
        }
    }
    try (Session session = getFactory().openSession()) {
        session.beginTransaction();
        Query query = session.createQuery("select count(*) from " + RAuditEventRecord.class.getSimpleName());
        Long count = (Long) query.uniqueResult();
        AssertJUnit.assertEquals(RECORDS, (long) count);
        session.getTransaction().commit();
    }
}

---

From source file:com.vpontes.airtickets.dao.BookingDAO.java

public Booking findByAirfareAndPassanger(Integer airfareId, Integer passangerId) {
    Query q = session.createQuery("From Booking where id.airfareId=:airfareId and id.passangerId=:passangerId");

    q.setParameter("airfareId", airfareId);
    q.setParameter("passangerId", passangerId);

    Booking b = (Booking) q.uniqueResult();

    return b;/*  w ww .j ava  2 s .  c  o m*/
}

---

From source file:com.vpontes.airtickets.dao.UserSystemDAO.java

public UserSystem findByEmail(String email) {

    Query q = session.createQuery("From UserSystem where email=:emailParameter");

    q.setParameter("emailParameter", email);

    UserSystem us = (UserSystem) q.uniqueResult();

    return us;/*  w w w  . j  a  v a  2  s .  c o m*/
}

---

From source file:com.wso2telco.services.dep.sandbox.dao.hibernate.HibernateProvisioningDAO.java

License:Open Source License

public ProvisionResponseMessage getErrorResponse(String msisdn, String username, String serviceCode)
        throws Exception {

    Session session = getSession();/*from www. ja  v a2s.  c  om*/
    ProvisionResponseMessage expectedErrorList = null;
    StringBuilder hql = new StringBuilder();

    hql.append(" SELECT");
    hql.append(" response");
    hql.append(" FROM");
    hql.append(" ProvisionResponseMessage AS response,");
    hql.append(" ManageNumber AS number,");
    hql.append(" ProvisionExpectedMessage AS expect,");
    hql.append(" ProvisionAllService AS service,");
    hql.append(" User AS user");
    hql.append(" WHERE");
    hql.append(" number.Number = :msisdn AND");
    hql.append(" user.userName= :username AND");
    hql.append(" user.id = number.user AND");
    hql.append(" user.id = service.user AND");
    hql.append(" service.serviceCode = :code AND");
    hql.append(" number.id = expect.msisdnId AND");
    hql.append(" service.id = expect.servicesId AND");
    hql.append(" expect.requestType = :type AND");
    hql.append(" expect.messageId = response.id");

    try {

        Query query = session.createQuery(hql.toString());

        query.setParameter("msisdn", msisdn);
        query.setParameter("username", username);
        query.setParameter("code", serviceCode);
        query.setParameter("type", "DELETE");

        expectedErrorList = (ProvisionResponseMessage) query.uniqueResult();
    } catch (Exception ex) {
        LOG.error("###PROVISION### Error in getErrorResponse " + ex);
        throw ex;
    }
    return expectedErrorList;
}

---

From source file:com.wso2telco.services.dep.sandbox.dao.hibernate.HibernateProvisioningDAO.java

License:Open Source License

public ProvisionedServices getAlreadyProvisioned(String msisdn, String userName, String serviceCode)
        throws Exception {

    Session session = getSession();/*from w  w w.ja  v  a  2s .co m*/
    ProvisionedServices provisionedCheckList = null;
    StringBuilder hql = new StringBuilder();

    hql.append(" SELECT");
    hql.append(" prservice");
    hql.append(" FROM");
    hql.append(" ProvisionedServices AS prservice,");
    hql.append(" ManageNumber AS number,");
    hql.append(" ProvisionAllService AS service,");
    hql.append(" User AS user,");
    hql.append(" ProvisionMSISDNServicesMap AS map,");
    hql.append(" Status AS stat");
    hql.append(" WHERE");
    hql.append(" number.Number = :msisdn AND");
    hql.append(" user.userName= :username AND");
    hql.append(" user.id = number.user AND");
    hql.append(" user.id = service.user AND");
    hql.append(" service.serviceCode = :code AND");
    hql.append(" map.servicesId = service.id AND");
    hql.append(" map.msisdnId = number.id AND");
    hql.append(" map.id = prservice.msisdnServiceMap AND");
    hql.append(" stat.id = prservice.status AND");
    hql.append(" stat.code= :status");

    try {

        Query query = session.createQuery(hql.toString());

        query.setParameter("status", ProvisioningStatusCodes.PRV_PROVISION_SUCCESS.toString());
        query.setParameter("msisdn", msisdn);
        query.setParameter("username", userName);
        query.setParameter("code", serviceCode);

        provisionedCheckList = (ProvisionedServices) query.uniqueResult();

    } catch (Exception ex) {
        LOG.error("###PROVISION### Error in getAlreadyProvisioned " + ex);
        throw ex;
    }

    return provisionedCheckList;

}

---

From source file:com.wso2telco.services.dep.sandbox.dao.hibernate.HibernateProvisioningDAO.java

License:Open Source License

public ProvisionedServices checkClientCorrelator(String msisdn, String userName, String serviceCode,
        String clientCorrelator) throws Exception {
    Session session = getSession();//from   ww  w . j a v a  2s. co m
    ProvisionedServices provisionedCheckList = null;
    StringBuilder hql = new StringBuilder();

    hql.append(" SELECT");
    hql.append(" prservice");
    hql.append(" FROM");
    hql.append(" ProvisionedServices AS prservice,");
    hql.append(" ManageNumber AS number,");
    hql.append(" ProvisionAllService AS service,");
    hql.append(" User AS user,");
    hql.append(" ProvisionMSISDNServicesMap AS map,");
    hql.append(" Status AS stat");
    hql.append(" WHERE");
    hql.append(" number.Number = :msisdn AND");
    hql.append(" user.userName= :username AND");
    hql.append(" user.id = number.user.id AND");
    hql.append(" user.id = service.user.id AND");
    hql.append(" service.serviceCode = :code AND");
    hql.append(" map.servicesId.id = service.id AND");
    hql.append(" map.msisdnId.id = number.id AND");
    hql.append(" map.id = prservice.msisdnServiceMap.id AND");
    hql.append(" stat.id = prservice.status.id AND");
    hql.append(" prservice.clientCorrelator= :clientCorrelator AND");
    hql.append(" ( stat.code= :status1 OR stat.code= :status2 )");

    try {
        Query query = session.createQuery(hql.toString());
        query.setParameter("status1", ProvisioningStatusCodes.PRV_DELETE_SUCCESS.toString());
        query.setParameter("status2", ProvisioningStatusCodes.PRV_DELETE_PENDING.toString());
        query.setParameter("msisdn", msisdn);
        query.setParameter("username", userName);
        query.setParameter("code", serviceCode);
        query.setParameter("clientCorrelator", clientCorrelator);

        provisionedCheckList = (ProvisionedServices) query.uniqueResult();
    } catch (Exception ex) {
        LOG.error("###PROVISION### Error in checkClientCorrelator " + ex);
        throw ex;
    }
    return provisionedCheckList;
}

---

From source file:com.wso2telco.services.dep.sandbox.dao.hibernate.HibernateProvisioningDAO.java

License:Open Source License

public ProvisionedServices checkProvisionClientCorrelator(String msisdn, String userName, String serviceCode,
        String clientCorrelator) throws Exception {
    Session session = getSession();//  w  ww. j  a  v  a  2  s  .c o m
    ProvisionedServices provisionedCheckList = null;
    StringBuilder hql = new StringBuilder();

    hql.append(" SELECT");
    hql.append(" prservice");
    hql.append(" FROM");
    hql.append(" ProvisionedServices AS prservice,");
    hql.append(" ManageNumber AS number,");
    hql.append(" ProvisionAllService AS service,");
    hql.append(" User AS user,");
    hql.append(" ProvisionMSISDNServicesMap AS map,");
    hql.append(" Status AS stat");
    hql.append(" WHERE");
    hql.append(" number.Number = :msisdn AND");
    hql.append(" user.userName= :username AND");
    hql.append(" user.id = number.user.id AND");
    hql.append(" user.id = service.user.id AND");
    hql.append(" service.serviceCode = :code AND");
    hql.append(" map.servicesId.id = service.id AND");
    hql.append(" map.msisdnId.id = number.id AND");
    hql.append(" map.id = prservice.msisdnServiceMap.id AND");
    hql.append(" stat.id = prservice.status.id AND");
    hql.append(" prservice.clientCorrelator= :clientCorrelator AND");
    hql.append(" stat.code= :status1 ");

    try {
        Query query = session.createQuery(hql.toString());
        query.setParameter("status1", ProvisioningStatusCodes.PRV_DELETE_SUCCESS.toString());
        //query.setParameter("status2", ProvisioningStatusCodes.PRV_DELETE_PENDING.toString());
        query.setParameter("msisdn", msisdn);
        query.setParameter("username", userName);
        query.setParameter("code", serviceCode);
        query.setParameter("clientCorrelator", clientCorrelator);

        provisionedCheckList = (ProvisionedServices) query.uniqueResult();
    } catch (Exception ex) {
        LOG.error("###PROVISION### Error in checkClientCorrelator " + ex);
        throw ex;
    }
    return provisionedCheckList;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• »