@Override public List<Offer> readOffersByAutomaticDeliveryType() { //TODO change this to a JPA criteria Criteria criteria = ((HibernateEntityManager) em).getSession().createCriteria(OfferImpl.class); Date myDate = getCurrentDateAfterFactoringInDateResolution(); Calendar c = Calendar.getInstance(); c.setTime(myDate); c.add(Calendar.DATE, +1); criteria.add(Restrictions.lt("startDate", c.getTime())); c = Calendar.getInstance(); c.setTime(myDate); c.add(Calendar.DATE, -1); criteria.add(Restrictions.or(Restrictions.isNull("endDate"), Restrictions.gt("endDate", c.getTime()))); criteria.add(Restrictions.or(Restrictions.eq("archiveStatus.archived", 'N'), Restrictions.isNull("archiveStatus.archived"))); criteria.add(Restrictions.eq("automaticallyAdded", true)); criteria.setCacheable(true); criteria.setCacheRegion("query.Offer"); return criteria.list(); }
/** * Prepare the given Criteria object, applying cache settings and/or * a transaction timeout. * @param criteria the Criteria object to prepare * @see #setCacheQueries * @see #setQueryCacheRegion */ protected void prepareCriteria(Criteria criteria) { if (isCacheQueries()) { criteria.setCacheable(true); if (getQueryCacheRegion() != null) { criteria.setCacheRegion(getQueryCacheRegion()); } } if (getFetchSize() > 0) { criteria.setFetchSize(getFetchSize()); } if (getMaxResults() > 0) { criteria.setMaxResults(getMaxResults()); } ResourceHolderSupport sessionHolder = (ResourceHolderSupport) TransactionSynchronizationManager.getResource(obtainSessionFactory()); if (sessionHolder != null && sessionHolder.hasTimeout()) { criteria.setTimeout(sessionHolder.getTimeToLiveInSeconds()); } }
/** * Prepare the given Criteria object, applying cache settings and/or * a transaction timeout. * @param criteria the Criteria object to prepare * @see #setCacheQueries * @see #setQueryCacheRegion */ protected void prepareCriteria(Criteria criteria) { if (isCacheQueries()) { criteria.setCacheable(true); if (getQueryCacheRegion() != null) { criteria.setCacheRegion(getQueryCacheRegion()); } } if (getFetchSize() > 0) { criteria.setFetchSize(getFetchSize()); } if (getMaxResults() > 0) { criteria.setMaxResults(getMaxResults()); } ResourceHolderSupport sessionHolder = (ResourceHolderSupport) TransactionSynchronizationManager.getResource(obtainSessionFactory()); if (sessionHolder != null && sessionHolder.hasTimeout()) { criteria.setTimeout(sessionHolder.getTimeToLiveInSeconds()); } }
@Override public Criteria setCacheRegion(String cacheRegion) { backingCriteria.setCacheRegion(cacheRegion); return this; }
@Override public Criteria setCacheRegion(final String cacheRegion) { criteria.setCacheRegion(cacheRegion); return this; }
@Override public Criteria setCacheRegion(final String cacheRegion) { return criteria.setCacheRegion(cacheRegion); }
Criteria cri = session.createCriteria(tableName.class); cri.setCacheRegion("cacheReginName");
private void setCacheRegion(final Criteria criteria) { criteria.setCacheable(true); if (useOwnCriteriaCacheRegion() == false) { return; } criteria.setCacheRegion(this.getClass().getName()); }
protected void prepareCache(Criteria criteria) { if (isCache()) { criteria.setCacheable(true); criteria.setCacheRegion(getCacheRegion()); } }
@SuppressWarnings("unchecked") public static void removeEmptyEntries(String bundle) { List<MessageBundleEntry> entries = getSession().createCriteria(MessageBundleEntry.class) .setCacheable(true) .setCacheRegion("messages") .add(Restrictions.sizeLe("messages", 1)) .add(Restrictions.naturalId() .set("bundle", bundle)) .list(); for (MessageBundleEntry entry : entries) { entry.delete(); } }
protected void prepareCache(Criteria criteria) { if (isCache()) { criteria.setCacheable(true); criteria.setCacheRegion(getCacheRegion()); } }
protected void prepareCache(Criteria criteria) { if (isCache()) { criteria.setCacheable(true); criteria.setCacheRegion(getCacheRegion()); } }
criteria.setCacheRegion("historyItemCache"); criteria.setProjection(Projections.property("entityId")); List<Object> idList = criteria.list();
/** * Prepare the given Criteria object, applying cache settings and/or * a transaction timeout. * @param criteria the Criteria object to prepare * @see #setCacheQueries * @see #setQueryCacheRegion * @see SessionFactoryUtils#applyTransactionTimeout */ protected void prepareCriteria(Criteria criteria) { if (isCacheQueries()) { criteria.setCacheable(true); if (getQueryCacheRegion() != null) { criteria.setCacheRegion(getQueryCacheRegion()); } } if (getFetchSize() > 0) { criteria.setFetchSize(getFetchSize()); } if (getMaxResults() > 0) { criteria.setMaxResults(getMaxResults()); } SessionFactoryUtils.applyTransactionTimeout(criteria, getSessionFactory()); }
/** * Prepare the given Criteria object, applying cache settings and/or * a transaction timeout. * @param criteria the Criteria object to prepare * @see #setCacheQueries * @see #setQueryCacheRegion */ protected void prepareCriteria(Criteria criteria) { if (isCacheQueries()) { criteria.setCacheable(true); if (getQueryCacheRegion() != null) { criteria.setCacheRegion(getQueryCacheRegion()); } } if (getFetchSize() > 0) { criteria.setFetchSize(getFetchSize()); } if (getMaxResults() > 0) { criteria.setMaxResults(getMaxResults()); } SessionHolder sessionHolder = (SessionHolder) TransactionSynchronizationManager.getResource(getSessionFactory()); if (sessionHolder != null && sessionHolder.hasTimeout()) { criteria.setTimeout(sessionHolder.getTimeToLiveInSeconds()); } }