Example usage for org.hibernate.criterion Projections max

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections max.

Prototype

public static AggregateProjection max(String propertyName)

Source Link

Document

A property maximum value projection

Usage

From source file:edu.temple.tutrucks.Review.java

/**
 * Saves this review object to the database and assigns it an ID value.
 *//*from w ww .  ja va  2 s  . com*/
@Override
public void save() {
    Session session = HibernateUtil.getSessionFactory().openSession();
    session.beginTransaction();
    if (this.id == 0) {
        Criteria criteria = session.createCriteria(Review.class).setProjection(Projections.max("id"));
        Object result = criteria.uniqueResult();
        int max = result == null ? 0 : (Integer) result;
        this.setId(max + 1);
    }
    session.saveOrUpdate(this);
    session.saveOrUpdate(this.getReviewed());
    session.getTransaction().commit();
    session.close();
    this.getUser().save();
}

From source file:ee.ria.xroad.proxy.messagelog.LogArchiver.java

License:Open Source License

@SuppressWarnings("unchecked")
protected Long getMaxTimestampId(Session session) {
    return (Long) session.createCriteria(TimestampRecord.class).add(Restrictions.eq("archived", false))
            .setProjection(Projections.max("id")).uniqueResult();
}

From source file:ejer3.E4anadirNuevo.java

private void bGuardarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_bGuardarActionPerformed
    String e = (String) cbEmpresas.getSelectedItem();
    if (e.equals("Seleccione una Empresa:")) {
        JOptionPane.showMessageDialog(null, "Debe selecionar una Empresa", "Error", JOptionPane.ERROR_MESSAGE);
    } else {/*from ww  w.  j  ava 2s. co  m*/
        String hnS = tfHorasN.getText();
        if (!isNumeric(hnS)) {
            JOptionPane.showMessageDialog(null, "El campo nmero de horas debe ser un nmero.", "Error",
                    JOptionPane.ERROR_MESSAGE);
        } else {
            Criteria criteria = sese.createCriteria(Proyectos.class)
                    .setProjection(Projections.max("idproyecto"));
            int idproyecto = (Integer) criteria.uniqueResult();
            int hn = Integer.parseInt(hnS);
            sese.beginTransaction();
            int ide = Integer.parseInt(e);
            Proyectos p = new Proyectos();
            idproyecto++;
            p.setIdproyecto(idproyecto);
            p.setEmpresas((Empresas) sese.get(Empresas.class, ide));
            p.setHorasnecesarias(hn);
            p.setFecha(dcFecha.getDate());
            sese.save(p);
            sese.getTransaction().commit();
            this.dispose();
        }

    }
}

From source file:es.emergya.bbdd.dao.CapaInformacionHome.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRES_NEW, readOnly = true, rollbackFor = Throwable.class)
public Calendar lastUpdated() {
    Calendar res = Calendar.getInstance();
    try {//from  w w w .j av  a2  s. co m
        Session currentSession = getSession();
        currentSession.clear();
        Criteria criteria = currentSession.createCriteria(CapaInformacion.class)
                .setProjection(Projections.max("updatedAt"));
        res.setTime((Date) criteria.uniqueResult());
    } catch (Throwable t) {
        log.error("Error al buscar la ultima actualizacion de capas" + t);
        return null;
    }
    return res;
}

From source file:es.emergya.bbdd.dao.FlotaHome.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRES_NEW, readOnly = true, rollbackFor = Throwable.class)
public Calendar lastUpdated() {
    Calendar res = Calendar.getInstance();
    try {//from  ww  w  . j ava 2s  . c  o m
        Session currentSession = getSession();
        currentSession.clear();
        Criteria criteria = currentSession.createCriteria(Flota.class)
                .setProjection(Projections.max("updatedAt"));
        res.setTime((Date) criteria.uniqueResult());
    } catch (NullPointerException t) {
        log.error("No hay datos en la tabla.");
        return null;
    } catch (Throwable t) {
        log.error(t, t);
        return null;
    }
    return res;
}

From source file:es.emergya.bbdd.dao.IncidenciaHome.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRES_NEW, readOnly = true, rollbackFor = Throwable.class)
public Calendar lastUpdated() {
    Calendar res = Calendar.getInstance();
    try {/*  w ww. ja va  2s  .  c o m*/
        Session currentSession = getSession();
        currentSession.clear();
        Criteria criteria = currentSession.createCriteria(Incidencia.class)
                .setProjection(Projections.max("updatedAt"));
        res.setTime((Date) criteria.uniqueResult());
    } catch (NullPointerException t) {
        log.error("No hay datos en la tabla.");
        return null;
    } catch (Throwable t) {
        log.error(t, t);
        return null;
    }
    return res;
}

From source file:es.emergya.bbdd.dao.PatrullaHome.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRES_NEW, readOnly = true, rollbackFor = Throwable.class)
public Calendar lastUpdated() {
    Calendar res = Calendar.getInstance();
    try {// w ww  .j  a va  2  s.  co  m
        Session currentSession = getSession();
        currentSession.clear();
        Criteria criteria = currentSession.createCriteria(Patrulla.class)
                .setProjection(Projections.max("updatedAt"));
        res.setTime((Date) criteria.uniqueResult());
    } catch (NullPointerException t) {
        log.error("No hay datos en la tabla.");
        return null;
    } catch (Throwable t) {
        log.error(t, t);
        return null;
    }
    return res;
}

From source file:es.emergya.bbdd.dao.RecursoHome.java

License:Open Source License

@Transactional(readOnly = true, rollbackFor = Throwable.class, propagation = Propagation.REQUIRES_NEW)
public Calendar lastUpdated() {
    Calendar res = Calendar.getInstance();
    try {/*from   w ww . ja  va 2  s  .  com*/
        Session currentSession = getSession();
        currentSession.clear();
        Criteria criteria = currentSession.createCriteria(Recurso.class)
                .setProjection(Projections.max("updatedAt"));
        res.setTime((Date) criteria.uniqueResult());
    } catch (NullPointerException t) {
        log.error("No hay datos en la tabla.");
        return null;
    } catch (Throwable t) {
        log.error(t, t);
        return null;
    }
    return res;
}

From source file:es.emergya.bbdd.dao.RolHome.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRES_NEW, readOnly = true, rollbackFor = Throwable.class)
public Calendar lastUpdated() {
    Calendar res = Calendar.getInstance();
    try {//w w  w  . java  2  s.c  o m
        Session currentSession = getSession();
        currentSession.clear();
        Criteria criteria = currentSession.createCriteria(Rol.class)
                .setProjection(Projections.max("updatedAt"));
        res.setTime((Date) criteria.uniqueResult());
    } catch (Throwable t) {
        log.error(t, t);
        return null;
    }
    return res;
}

From source file:es.emergya.bbdd.dao.UsuarioHome.java

License:Open Source License

@Transactional(readOnly = true, rollbackFor = Throwable.class, propagation = Propagation.REQUIRES_NEW)
public Calendar lastUpdated() {
    Calendar res = Calendar.getInstance();
    try {/*from  ww  w. ja  va 2 s . c om*/
        org.hibernate.Session currentSession = getSession();
        currentSession.clear();
        Criteria criteria = currentSession.createCriteria(Usuario.class)
                .setProjection(Projections.max("updatedAt"));
        res.setTime((Date) criteria.uniqueResult());
    } catch (Throwable t) {
        log.error(t, t);
        return null;
    }
    return res;
}