Codota Logo
Criteria.setFirstResult
Code IndexAdd Codota to your IDE (free)

How to use
setFirstResult
method
in
org.hibernate.Criteria

Best Java code snippets using org.hibernate.Criteria.setFirstResult (Showing top 20 results out of 756)

  • Common ways to obtain Criteria
private void myMethod () {
Criteria c =
  • Codota IconSession session;Class persistentClass;session.createCriteria(persistentClass)
  • Smart code suggestions by Codota
}
origin: stackoverflow.com

 DetachedCriteria idsOnlyCriteria = DetachedCriteria.forClass(MyClass.class);
//add other joins and query params here
idsOnlyCriteria.setProjection(Projections.distinct(Projections.id()));

Criteria criteria = getSession().createCriteria(myClass);
criteria.add(Subqueries.propertyIn("id", idsOnlyCriteria));
criteria.setFirstResult(0).setMaxResults(50);
return criteria.list();
origin: spring-projects/spring-framework

@Override
@SuppressWarnings({"unchecked", "deprecation"})
public <T> List<T> findByExample(
    @Nullable final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
    throws DataAccessException {
  Assert.notNull(exampleEntity, "Example entity must not be null");
  return nonNull(executeWithNativeSession((HibernateCallback<List<T>>) session -> {
    Criteria executableCriteria = (entityName != null ?
        session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
    executableCriteria.add(Example.create(exampleEntity));
    prepareCriteria(executableCriteria);
    if (firstResult >= 0) {
      executableCriteria.setFirstResult(firstResult);
    }
    if (maxResults > 0) {
      executableCriteria.setMaxResults(maxResults);
    }
    return executableCriteria.list();
  }));
}
origin: spring-projects/spring-framework

@Override
@SuppressWarnings("unchecked")
public List<?> findByCriteria(final DetachedCriteria criteria, final int firstResult, final int maxResults)
    throws DataAccessException {
  Assert.notNull(criteria, "DetachedCriteria must not be null");
  return nonNull(executeWithNativeSession((HibernateCallback<List<?>>) session -> {
    Criteria executableCriteria = criteria.getExecutableCriteria(session);
    prepareCriteria(executableCriteria);
    if (firstResult >= 0) {
      executableCriteria.setFirstResult(firstResult);
    }
    if (maxResults > 0) {
      executableCriteria.setMaxResults(maxResults);
    }
    return executableCriteria.list();
  }));
}
origin: org.springframework/spring-orm

@Override
@SuppressWarnings({"unchecked", "deprecation"})
public <T> List<T> findByExample(
    @Nullable final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
    throws DataAccessException {
  Assert.notNull(exampleEntity, "Example entity must not be null");
  return nonNull(executeWithNativeSession((HibernateCallback<List<T>>) session -> {
    Criteria executableCriteria = (entityName != null ?
        session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
    executableCriteria.add(Example.create(exampleEntity));
    prepareCriteria(executableCriteria);
    if (firstResult >= 0) {
      executableCriteria.setFirstResult(firstResult);
    }
    if (maxResults > 0) {
      executableCriteria.setMaxResults(maxResults);
    }
    return executableCriteria.list();
  }));
}
origin: stackoverflow.com

Criteria criteria=session.createCriteria(Student.class);
  criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
  criteria.add(Restrictions.ne("enquiryStatus", ENQUIRY.JOINED));
  criteria.setMaxResults(10);
  criteria.setFirstResult((paginate.getStartIndex()-1)*10);
  List<Student> students = criteria.list();
 criteria.setProjection(null);
 criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
 Long resultCount = (Long)criteria.uniqueResult();
origin: org.springframework/spring-orm

@Override
@SuppressWarnings("unchecked")
public List<?> findByCriteria(final DetachedCriteria criteria, final int firstResult, final int maxResults)
    throws DataAccessException {
  Assert.notNull(criteria, "DetachedCriteria must not be null");
  return nonNull(executeWithNativeSession((HibernateCallback<List<?>>) session -> {
    Criteria executableCriteria = criteria.getExecutableCriteria(session);
    prepareCriteria(executableCriteria);
    if (firstResult >= 0) {
      executableCriteria.setFirstResult(firstResult);
    }
    if (maxResults > 0) {
      executableCriteria.setMaxResults(maxResults);
    }
    return executableCriteria.list();
  }));
}
origin: hibernate/hibernate-orm

@Test
public void testCriteria() {
  Session session = openSession();
  session.beginTransaction();
  Criteria criteria = session.createCriteria( Door.class );
  criteria.setLockMode( LockMode.PESSIMISTIC_WRITE );
  criteria.setFirstResult( 2 );
  criteria.setMaxResults( 2 );
  @SuppressWarnings("unchecked") List<Door> results = criteria.list();
  assertEquals( 2, results.size() );
  for ( Door door : results ) {
    assertEquals( LockMode.PESSIMISTIC_WRITE, session.getCurrentLockMode( door ) );
  }
  session.getTransaction().commit();
  session.close();
}
origin: hibernate/hibernate-orm

assertTrue( list.size()==1 && list.get(0)==f );
list = s.createCriteria(Foo.class)
  .setFirstResult(1)
  .addOrder( Order.asc("date") )
  .addOrder( Order.desc("string") )
origin: openmrs/openmrs-core

/**
 * @see org.openmrs.api.db.OpenmrsDataDAO#getAll(boolean, java.lang.Integer, java.lang.Integer)
 */
@Override
public List<T> getAll(boolean includeVoided, Integer firstResult, Integer maxResults) {
  Criteria crit = sessionFactory.getCurrentSession().createCriteria(mappedClass);
  
  if (!includeVoided) {
    crit.add(Restrictions.eq("voided", false));
  }
  crit.setFirstResult(firstResult);
  crit.setMaxResults(maxResults);
  
  return crit.list();
  
}

origin: openmrs/openmrs-core

/**
 * @see org.openmrs.api.db.OpenmrsMetadataDAO#getAll(boolean, java.lang.Integer, java.lang.Integer)
 */
@Override
public List<T> getAll(boolean includeRetired, Integer firstResult, Integer maxResults) {
  Criteria crit = sessionFactory.getCurrentSession().createCriteria(mappedClass);
  
  if (!includeRetired) {
    crit.add(Restrictions.eq("retired", false));
  }
  crit.setFirstResult(firstResult);
  crit.setMaxResults(maxResults);
  
  return crit.list();
  
}

origin: hibernate/hibernate-orm

.setFirstResult( 1 ).setMaxResults( 3 ).list();
origin: stackoverflow.com

 Criteria crit = HibernateUtil.getSession().createCriteria( persistentClass );
crit.setFirstResult(startIndex);
crit.setFetchSize(fetchSize);
crit.setCachable(true); // Enable caching of this query result
return crit.list();
origin: openmrs/openmrs-core

/**
 * @see org.openmrs.api.db.EncounterDAO#getEncounters(String, Integer, Integer, Integer,
 *      boolean)
 */
@Override
@SuppressWarnings("unchecked")
public List<Encounter> getEncounters(String query, Integer patientId, Integer start, Integer length,
    boolean includeVoided) {
  if (StringUtils.isBlank(query) && patientId == null) {
    return Collections.emptyList();
  }
  
  Criteria criteria = createEncounterByQueryCriteria(query, patientId, includeVoided, true);
  
  if (start != null) {
    criteria.setFirstResult(start);
  }
  if (length != null && length > 0) {
    criteria.setMaxResults(length);
  }
  
  return criteria.list();
}

origin: openmrs/openmrs-core

/**
 * @see org.openmrs.api.db.ConceptDAO#getConceptReferenceTerms(String, ConceptSource, Integer,
 *      Integer, boolean)
 */
@SuppressWarnings("unchecked")
@Override
public List<ConceptReferenceTerm> getConceptReferenceTerms(String query, ConceptSource conceptSource, Integer start,
    Integer length, boolean includeRetired) throws APIException {
  Criteria criteria = createConceptReferenceTermCriteria(query, conceptSource, includeRetired);
  
  if (start != null) {
    criteria.setFirstResult(start);
  }
  if (length != null && length > 0) {
    criteria.setMaxResults(length);
  }
  
  return criteria.list();
}

origin: openmrs/openmrs-core

private void setFirstAndMaxResult(Criteria criteria, Integer start, Integer length) {
  if (start != null) {
    criteria.setFirstResult(start);
  }
  
  int maximumSearchResults = HibernatePersonDAO.getMaximumSearchResults();
  if (length != null && length < maximumSearchResults) {
    criteria.setMaxResults(length);
  } else {
    if (log.isDebugEnabled()) {
      log.debug("Limiting the size of the number of matching patients to " + maximumSearchResults);
    }
    criteria.setMaxResults(maximumSearchResults);
  }
}

origin: openmrs/openmrs-core

@Override
public ListPart<T> listPart(Long firstResult, Long maxResults) {
  criteria.setProjection(null);
  criteria.setResultTransformer(Criteria.ROOT_ENTITY);
  
  if (firstResult != null) {
    criteria.setFirstResult(firstResult.intValue());
  }
  
  if (maxResults != null) {
    criteria.setMaxResults(maxResults.intValue());
  }
  
  @SuppressWarnings("unchecked")
  List<T> list = criteria.list();
  
  return ListPart.newListPart(list, firstResult, maxResults, null, null);
}

origin: openmrs/openmrs-core

/**
 * @see org.openmrs.hl7.db.HL7DAO#getHL7Batch(Class, int, int, Integer, String)
 */
@Override
@SuppressWarnings( { "rawtypes", "unchecked" })
public <T> List<T> getHL7Batch(Class clazz, int start, int length, Integer messageState, String query)
    throws DAOException {
  Criteria crit = getHL7SearchCriteria(clazz, messageState, query);
  crit.setFirstResult(start);
  crit.setMaxResults(length);
  crit.addOrder(Order.asc("dateCreated"));
  return crit.list();
}

origin: bill1012/AdminEAP

public List<?> getListByCriteria(DetachedCriteria criteria, Integer startPage, Integer pageSize) {
  if (startPage != null && pageSize != null) {
    return criteria.getExecutableCriteria(getCurrentSession()).setProjection(null)
        .setResultTransformer(CriteriaSpecification.ROOT_ENTITY).setFirstResult(startPage).setMaxResults(pageSize).list();
  } else {
    return criteria.getExecutableCriteria(getCurrentSession()).setProjection(null)
        .setResultTransformer(CriteriaSpecification.ROOT_ENTITY).list();
  }
}
origin: openmrs/openmrs-core

/**
 * @see org.openmrs.api.db.ProviderDAO#getProviders(String, Map, Integer, Integer, boolean)
 */
@Override
public List<Provider> getProviders(String name, Map<ProviderAttributeType, String> serializedAttributeValues,
    Integer start, Integer length, boolean includeRetired) {
  Criteria criteria = prepareProviderCriteria(name, includeRetired);
  if (start != null) {
    criteria.setFirstResult(start);
  }
  if (length != null) {
    criteria.setMaxResults(length);
  }
  
  if (includeRetired) {
    //push retired Provider to the end of the returned list
    criteria.addOrder(Order.asc("retired"));
  }
  
  List<Provider> providers = criteria.list();
  if (serializedAttributeValues != null) {
    CollectionUtils.filter(providers, new AttributeMatcherPredicate<Provider, ProviderAttributeType>(
        serializedAttributeValues));
  }
  return providers;
}

origin: bill1012/AdminEAP

public <T> List<T> getListByCriteria(DetachedCriteria criteria, PageInfo page) {
  if (page == null) {
    return criteria.getExecutableCriteria(getCurrentSession()).setProjection(null)
        .setResultTransformer(CriteriaSpecification.ROOT_ENTITY).list();
  } else {
    return criteria.getExecutableCriteria(getCurrentSession()).setProjection(null)
        .setResultTransformer(CriteriaSpecification.ROOT_ENTITY).setFirstResult((page.getPageNum() - 1) * page.getPageSize())
        .setMaxResults(page.getPageSize()).list();
  }
}
org.hibernateCriteriasetFirstResult

Javadoc

Set the first result to be retrieved.

Popular methods of Criteria

  • list
    Get the results.
  • add
    Add a Criterion to constrain the results to be retrieved.
  • uniqueResult
    Convenience method to return a single instance that matches the query, or null if the query returns
  • addOrder
    Add an Order to the result set.
  • setProjection
    Used to specify that the query results will be a projection (scalar in nature). Implicitly specifies
  • setMaxResults
    Set a limit upon the number of objects to be retrieved.
  • setResultTransformer
    Set a strategy for handling the query results. This determines the "shape" of the query result.
  • createAlias
    Join an association using the specified join-type, assigning an alias to the joined association. The
  • createCriteria
    Create a new Criteria, "rooted" at the associated entity, using the specified join type.
  • setFetchMode
    Specify an association fetching strategy for an association or a collection of values.
  • setCacheable
    Enable caching of this query result, provided query caching is enabled for the underlying session fa
  • setFetchSize
    Set a fetch size for the underlying JDBC query.
  • setCacheable,
  • setFetchSize,
  • scroll,
  • setLockMode,
  • setReadOnly,
  • setCacheRegion,
  • setTimeout,
  • setCacheMode,
  • setFlushMode

Popular in Java

  • Finding current android device location
  • onRequestPermissionsResult (Fragment)
  • getExternalFilesDir (Context)
  • getSupportFragmentManager (FragmentActivity)
    Return the FragmentManager for interacting with fragments associated with this activity.
  • Format (java.text)
    The base class for all formats. This is an abstract base class which specifies the protocol for clas
  • Dictionary (java.util)
    The Dictionary class is the abstract parent of any class, such as Hashtable, which maps keys to valu
  • LinkedHashMap (java.util)
    Hash table and linked list implementation of the Map interface, with predictable iteration order. Th
  • Reference (javax.naming)
  • Filter (javax.servlet)
    A filter is an object that performs filtering tasks on either the request to a resource (a servlet o
  • SAXParseException (org.xml.sax)
    Encapsulate an XML parse error or warning.This exception may include information for locating the er
Codota Logo
  • Products

    Search for Java codeSearch for JavaScript codeEnterprise
  • IDE Plugins

    IntelliJ IDEAWebStormAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimAtomGoLandRubyMineEmacsJupyter
  • Company

    About UsContact UsCareers
  • Resources

    FAQBlogCodota Academy Plugin user guide Terms of usePrivacy policyJava Code IndexJavascript Code Index
Get Codota for your IDE now