Example usage for org.hibernate.type LongType INSTANCE

Introduction

In this page you can find the example usage for org.hibernate.type LongType INSTANCE.

Prototype

LongType INSTANCE

To view the source code for org.hibernate.type LongType INSTANCE.

Click Source Link

Usage

From source file:es.jpons.persistence.query.CriteriaAllenRelations.java

License:Open Source License

/**
 * Implements the during criteria/*  ww  w.j  ava2 s  .c o  m*/
 *
 * @param initializedCriteria
 * @param pvp
 * @return
 */
public static Criteria during(Criteria initializedCriteria, PossibilisticVTP pvp) {
    Long jstart = pvp.getStartMP();
    Long jright = pvp.getEndMP() + pvp.getEndRight();
    Long jleft = pvp.getStartMP() - pvp.getStartLeft();
    Long jend = pvp.getEndMP();

    initializedCriteria = initializedCriteria.add(Restrictions.or(
            Restrictions.and(Restrictions.sqlRestriction("({alias}.startMP ) > ?", jstart, LongType.INSTANCE),
                    Restrictions.sqlRestriction("{alias}.endMP <= ?", jright, LongType.INSTANCE)),
            Restrictions.and(Restrictions.sqlRestriction("({alias}.startMP ) >= ?", jleft, LongType.INSTANCE),
                    Restrictions.sqlRestriction("{alias}.endMP < ?", jend, LongType.INSTANCE))));

    return initializedCriteria;

}

---

From source file:es.jpons.persistence.query.CriteriaAllenRelations.java

License:Open Source License

/**
 * Implements the contains//  w  w w  .ja va  2  s .  c  o  m
 *
 * @param initializedCriteria
 * @param pvp
 * @return
 */
public static Criteria contains(Criteria initializedCriteria, PossibilisticVTP pvp) {
    Long jstart = pvp.getStartMP();
    Long jright = pvp.getStartMP() + pvp.getStartRight();
    Long jleft = pvp.getEndMP() - pvp.getEndLeft();
    Long jend = pvp.getEndMP();

    initializedCriteria = initializedCriteria.add(Restrictions.or(
            Restrictions.and(Restrictions.sqlRestriction("({alias}.startMP ) < ?", jstart, LongType.INSTANCE),
                    Restrictions.sqlRestriction("{alias}.endMP >= ?", jleft, LongType.INSTANCE)),
            Restrictions.and(Restrictions.sqlRestriction("({alias}.startMP ) <= ?", jright, LongType.INSTANCE),
                    Restrictions.sqlRestriction("{alias}.endMP > ?", jend, LongType.INSTANCE))));

    return initializedCriteria;

}

---

From source file:es.jpons.persistence.query.CriteriaAllenRelations.java

License:Open Source License

public static Criteria equals(Criteria initializedCriteria, PossibilisticVTP pvp) {

    initializedCriteria = initializedCriteria.add(Restrictions.and(
            Restrictions.or(//from  w  w w  .j  a v  a2  s. co  m
                    Restrictions.sqlRestriction("({alias}.startMP + {alias}.startRight ) <= ?",
                            pvp.getStartMP() - pvp.getStartLeft(), LongType.INSTANCE),
                    Restrictions.sqlRestriction("({alias}.startMP - {alias}.startLeft ) >= ?",
                            pvp.getStartMP() + pvp.getStartRight(), LongType.INSTANCE)),
            Restrictions.or(
                    Restrictions.sqlRestriction("({alias}.endMP + {alias}.endRight ) <= ?",
                            pvp.getEndMP() - pvp.getEndLeft(), LongType.INSTANCE),
                    Restrictions.sqlRestriction("({alias}.endMP - {alias}.endLeft ) >= ?",
                            pvp.getEndMP() + pvp.getEndRight(), LongType.INSTANCE))));

    return initializedCriteria;
}

---

From source file:es.jpons.persistence.query.CriteriaAllenRelations.java

License:Open Source License

public static Criteria starts(Criteria initializedCriteria, PossibilisticVTP pvp) {

    initializedCriteria = initializedCriteria.add(Restrictions.or(
            Restrictions.sqlRestriction("({alias}.startMP + {alias}.startRight ) <= ?",
                    pvp.getStartMP() - pvp.getStartLeft(), LongType.INSTANCE),
            Restrictions.sqlRestriction("({alias}.startMP - {alias}.startLeft ) >= ?",
                    pvp.getStartMP() + pvp.getStartRight(), LongType.INSTANCE)));

    return initializedCriteria;
}

---

From source file:es.jpons.persistence.query.CriteriaAllenRelations.java

License:Open Source License

public static Criteria ends(Criteria initializedCriteria, PossibilisticVTP pvp) {

    initializedCriteria = initializedCriteria.add(Restrictions.or(
            Restrictions.sqlRestriction("({alias}.endMP + {alias}.endRight ) <= ?",
                    pvp.getEndMP() - pvp.getEndLeft(), LongType.INSTANCE),
            Restrictions.sqlRestriction("({alias}.endMP - {alias}.endLeft ) >= ?",
                    pvp.getEndMP() + pvp.getEndRight(), LongType.INSTANCE)));

    return initializedCriteria;
}

---

From source file:fi.vm.sade.eperusteet.repository.custom.TekstiPalanenRepositoryCustomImpl.java

License:EUPL

private List<LokalisoituTekstiHakuDto> getTekstipalaset(List<Long> tekstiPalanenIds) {
    // In JPA 2.0 we can not select DTOs with native queries and LokalisoituTeksti is not an entity
    // (which can therefore neither be selected with JPA query language) -> doing in Hibernate level API:
    Session session = em.unwrap(Session.class);
    StringBuilder or = new StringBuilder();
    // Just to make sure that https://hibernate.atlassian.net/browse/HHH-1123 won't affect us:
    List<List<Long>> idChunks = Lists.partition(tekstiPalanenIds, 1000);
    int i = 0;//from  w  w w  .  j  av a  2s  .  co m
    Map<String, List<Long>> params = new HashMap<>(idChunks.size());
    for (List<Long> ids : idChunks) {
        if (or.length() > 0) {
            or.append(" OR ");
        }
        or.append("t.tekstipalanen_id IN (:ids_").append(i).append(") ");
        params.put("ids_" + i, ids);
        ++i;
    }
    Query q = session
            .createSQLQuery("SELECT " + "   t.tekstipalanen_id as id, " + "   t.kieli as kieli, "
                    + "   t.teksti as teksti " + " FROM tekstipalanen_teksti t " + " WHERE (" + or
                    + ") ORDER BY t.tekstipalanen_id, t.kieli")
            .addScalar("id", LongType.INSTANCE).addScalar("kieli", enumType(session, Kieli.class))
            .addScalar("teksti", StringType.INSTANCE)
            .setResultTransformer(new AliasToBeanResultTransformer(LokalisoituTekstiHakuDto.class));
    for (Map.Entry<String, List<Long>> p : params.entrySet()) {
        q.setParameterList(p.getKey(), p.getValue());
    }
    return list(q);
}

---

From source file:gov.medicaid.services.impl.SequenceGeneratorBean.java

License:Apache License

/**
 * Creates a new sequence if necessary.//w w  w  .ja  va2 s  .co  m
 *
 * @param sequenceName the sequence to get the next set of values for
 * @return the generator
 */
private MultipleHiLoPerTableGenerator configure(String sequenceName) {
    Properties params = new Properties();
    params.put(MultipleHiLoPerTableGenerator.ID_TABLE, "CMS_SEQUENCE");
    params.put(MultipleHiLoPerTableGenerator.PK_COLUMN_NAME, "SEQ_NAME");
    params.put(MultipleHiLoPerTableGenerator.PK_VALUE_NAME, sequenceName);
    params.put(MultipleHiLoPerTableGenerator.VALUE_COLUMN_NAME, "NEXT_HI");
    params.put(MultipleHiLoPerTableGenerator.MAX_LO, MAXIMUM_LO);
    params.put(MultipleHiLoPerTableGenerator.IDENTIFIER_NORMALIZER, new ObjectNameNormalizer() {
        /**
         * Returns false.
         */
        protected boolean isUseQuotedIdentifiersGlobally() {
            return false;
        }

        /**
         * Returns the default naming strategy.
         */
        protected NamingStrategy getNamingStrategy() {
            return EJB3NamingStrategy.INSTANCE;
        }
    });

    Session sess = (Session) em.getDelegate();
    SessionFactoryImplementor impl = (SessionFactoryImplementor) sess.getSessionFactory();
    MultipleHiLoPerTableGenerator generator = new MultipleHiLoPerTableGenerator();
    generator.configure(LongType.INSTANCE, params, impl.getDialect());
    generators.put(sequenceName, generator);
    return generator;
}

---

From source file:gov.opm.scrd.services.impl.SecurityServiceImpl.java

License:Apache License

/**
 * Check authorization by user name,roles and action
 * /*from  ww w . java 2  s . com*/
 * @param username
 *            the user name
 * @param roles
 *            the roles
 * @param action
 *            the action name
 * @return if authorized return true
 */
@Override
public boolean authorize(String username, List<String> roles, String action) {
    final String signature = SecurityServiceImpl.class.getName()
            + "#authorize(String username, List<String> roles, String action)";
    Helper.logEntrance(LOGGER, signature, new String[] { "username", "roles", "action" },
            new Object[] { username, roles, action });
    try {
        Helper.checkNullOrEmpty("username", username);
        Helper.checkNull("roles", roles);
        Helper.checkNullOrEmpty("action", action);
        Session session = (Session) entityManager.getDelegate();
        Long count = (Long) session.createSQLQuery(COUNT_QUERY).addScalar("count", LongType.INSTANCE)
                .setString("userName", username).setString("action", action)
                .setParameterList("roleNames", roles).setCacheable(true).setCacheRegion("query.countCache")
                .uniqueResult();
        boolean result = count > 0;
        Helper.logExit(LOGGER, signature, new Object[] { result });
        return result;
    } catch (IllegalArgumentException e) {
        Helper.logException(LOGGER, signature, e);
        return false;
    } catch (HibernateException e) {
        Helper.logException(LOGGER, signature, e);
        return false;
    }
}

---

From source file:helpers.PanMelon.java

public static long countSportist(String sp, String zemlja) {//dohvata samo broj, a to i treba
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tr = null;/* w ww  .  j  av  a  2 s. co  m*/
    long broj = 0;
    boolean good = false;

    tr = session.beginTransaction();
    Query q = session.createSQLQuery(
            "select count(DISTINCT sp.name) as cnt from sportista sp, spordisc sd where sp.nacionalnost='"
                    + zemlja + "' and sd.sport='" + sp + "' and sd.id=sp.sport_discipline")
            .addScalar("cnt", LongType.INSTANCE);
    broj = (long) q.uniqueResult();

    tr.commit();
    good = false;

    session.close();

    return broj;
}

---

From source file:helpers.VHelper.java

public static void updateContNumCountry(String zemlja) {//dohvata samo broj, sto i treba
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tr = null;/*from   w ww  .java  2  s.c om*/
    long broj = 0;
    boolean good = false;
    try {
        tr = session.beginTransaction();
        /* Query q = session.createSQLQuery("select sportists as num from zemlja where naziv='" + zemlja + "'")
            .addScalar("num", LongType.INSTANCE);*/
        Query q = session
                .createSQLQuery(
                        "select count(distinct name) as num from sportista where nacionalnost='" + zemlja + "'")
                .addScalar("num", LongType.INSTANCE);
        broj = (long) q.uniqueResult();
        // broj++;
        q = session.createSQLQuery("update zemlja set sportists=" + broj + " where naziv='" + zemlja + "'");
        q.executeUpdate();

        tr.commit();
        good = false;
    } catch (HibernateException e) {
        if (tr != null) {
            tr.rollback();
        }
    } finally {
        session.close();
    }

}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• »