Examples of org.hibernate.Session.createCriteria()

org.hibernate.Session.createCriteria()
Create a new Criteria instance, for the given entity class, or a superclass of an entity class. @param persistentClass a class, which is persistent, or has persistent subclasses @return Criteria

   * you expect large results to be returned enable scrollableResultSet to retrieve only as many records as needed.
   */
  public Iterator<?> getElements(Filter filter, int offset, int maxResultSize) throws LayerException {
    try {
      Session session = getSessionFactory().getCurrentSession();
      Criteria criteria = session.createCriteria(getFeatureInfo().getDataSourceName());
      if (filter != null) {
        if (filter != Filter.INCLUDE) {
          CriteriaVisitor visitor = new CriteriaVisitor((HibernateFeatureModel) featureModel, dateFormat);
          Criterion c = (Criterion) filter.accept(visitor, criteria);
          if (c != null) {

View Full Code Here

      throw new HibernateLayerException(ExceptionCode.ATTRIBUTE_UNKNOWN, (Object) null);
    }
    AssociationAttributeInfo attributeInfo = getRecursiveAttributeInfo(attributeName, getFeatureInfo()
        .getAttributes());
    Session session = getSessionFactory().getCurrentSession();
    Criteria criteria = session.createCriteria(attributeInfo.getFeature().getDataSourceName());
    CriteriaVisitor visitor = new CriteriaVisitor((HibernateFeatureModel) getFeatureModel(), dateFormat);
    if (filter != null) {
      Criterion c = (Criterion) filter.accept(visitor, null);
      if (c != null) {
        criteria.add(c);

View Full Code Here

   *             oops
   */
  private Envelope getBoundsLocal(Filter filter) throws LayerException {
    try {
      Session session = getSessionFactory().getCurrentSession();
      Criteria criteria = session.createCriteria(getFeatureInfo().getDataSourceName());
      CriteriaVisitor visitor = new CriteriaVisitor((HibernateFeatureModel) getFeatureModel(), dateFormat);
      Criterion c = (Criterion) filter.accept(visitor, criteria);
      if (c != null) {
        criteria.add(c);
      }

View Full Code Here


        for (String s : ignoreProperty) example.excludeProperty(s);


        Session session = (Session)entityManager.getDelegate();


        Criteria crit = session.createCriteria(User.class).add(example);
        if (orderByProperty != null)
                crit.addOrder( orderDescending ? Order.desc(orderByProperty) : Order.asc(orderByProperty) );


        return crit.setResultTransformer(DistinctRootEntityResultTransformer.INSTANCE);
    }

View Full Code Here

  
  @GET
  @Produces(TEXT_HTML + "; charset=utf-8")
  public Viewable fortunes() {
    final Session session = sessionFactory.openSession();
    final List fortunes = new ArrayList(session.createCriteria(Fortune.class).list());
    fortunes.add(new Fortune(0, "Additional fortune added at request time."));
    Collections.sort(fortunes);
    
    session.close();
    return new Viewable("/fortunes.mustache", new Scope(fortunes));

View Full Code Here

    @PostConstruct
    public void retrieveAllMembersOrderedByName() {


        // using Hibernate Session and Criteria Query via Hibernate Native API
        Session session = (Session) em.getDelegate();
        Criteria cb = session.createCriteria(Member.class);
        cb.addOrder(Order.asc("name"));
        members = (List<Member>) cb.list();


    }
}

View Full Code Here


    @SuppressWarnings("unchecked")
    public List<Member> findAllOrderedByName() {
        // using Hibernate Session and Criteria Query via Hibernate Native API
        Session session = (Session) em.getDelegate();
        Criteria cb = session.createCriteria(Member.class);
        cb.addOrder(Order.asc("name"));
        return (List<Member>) cb.list();
        // return members;
    }
}

View Full Code Here

    }


    @Override
    public Workspace findById(String workspaceId, User user) {
        Session session = sessionManager.getSession();
        List workspaces = session.createCriteria(SqlWorkspace.class).add(Restrictions.eq("workspaceId", workspaceId)).list();
        if (workspaces.size() == 0) {
            return null;
        } else if (workspaces.size() > 1) {
            throw new LumifyException("more than one workspace was returned");
        } else {

View Full Code Here

    }


    @Override
    public Iterable<Workspace> findAll(User user) {
        Session session = sessionManager.getSession();
        List workspaces = session.createCriteria(SqlWorkspaceUser.class)
                .add(Restrictions.eq("sqlWorkspaceUser.user.userId", user.getUserId()))
                .add(Restrictions.in("workspaceAccess", new String[]{WorkspaceAccess.READ.toString(), WorkspaceAccess.WRITE.toString()}))
                .list();
        return new ConvertingIterable<Object, Workspace>(workspaces) {
            @Override

View Full Code Here

        Transaction transaction = null;
        try {
            transaction = session.beginTransaction();


            for (Update update : updates) {
                List vertices = session.createCriteria(SqlWorkspaceVertex.class)
                        .add(Restrictions.eq("vertexId", update.getVertexId()))
                        .add(Restrictions.eq("workspace.workspaceId", workspace.getWorkspaceId()))
                        .list();
                SqlWorkspaceVertex sqlWorkspaceVertex;
                if (vertices.size() > 1) {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.