Package org.hibernate.classic

Examples of org.hibernate.classic.Session.createFilter()

986
987
988
989
990
991
992
993
994
995
996
    s.save(baz);
    Glarch g = new Glarch();
    Serializable gid = s.save(g);

    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof HSQLDialect) /*&& !(dialect instanceof MckoiDialect)*/ && !(getDialect() instanceof SAPDBDialect) && !(getDialect() instanceof PointbaseDialect) && !(getDialect() instanceof TimesTenDialect) ) {
      s.createFilter( baz.getFooArray(), "where size(this.bytes) > 0" ).list();
      s.createFilter( baz.getFooArray(), "where 0 in elements(this.bytes)" ).list();
    }
    s.getTransaction().commit();
    s.close();

View Full Code Here
987
988
989
990
991
992
993
994
995
996
997
    Glarch g = new Glarch();
    Serializable gid = s.save(g);

    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof HSQLDialect) /*&& !(dialect instanceof MckoiDialect)*/ && !(getDialect() instanceof SAPDBDialect) && !(getDialect() instanceof PointbaseDialect) && !(getDialect() instanceof TimesTenDialect) ) {
      s.createFilter( baz.getFooArray(), "where size(this.bytes) > 0" ).list();
      s.createFilter( baz.getFooArray(), "where 0 in elements(this.bytes)" ).list();
    }
    s.getTransaction().commit();
    s.close();

    s = openSession();
View Full Code Here
462
463
464
465
466
467
468
469
470
471
472
    assertTrue( s.createCriteria(Part.class).list().size()==1 ); //there is a where condition on Part mapping
    assertTrue( s.createCriteria(Part.class).add( Restrictions.eq( "id", p1.getId() ) ).list().size()==1 );
    assertTrue( s.createQuery("from Part").list().size()==1 );
    assertTrue( s.createQuery("from Baz baz join baz.parts").list().size()==2 );
    baz = (Baz) s.createCriteria(Baz.class).uniqueResult();
    assertTrue( s.createFilter( baz.getParts(), "" ).list().size()==2 );
    //assertTrue( baz.getParts().size()==1 );
    s.delete( s.get( Part.class, p1.getId() ));
    s.delete( s.get( Part.class, p2.getId() ));
    s.delete(baz);
    t.commit();
View Full Code Here
493
494
495
496
497
498
499
500
501
502
503
    assertTrue( s.createCriteria(Part.class).list().size()==1 ); //there is a where condition on Part mapping
    assertTrue( s.createCriteria(Part.class).add( Restrictions.eq( "id", p1.getId() ) ).list().size()==1 );
    assertTrue( s.createQuery("from Part").list().size()==1 );
    assertTrue( s.createQuery("from Baz baz join baz.moreParts").list().size()==2 );
    baz = (Baz) s.createCriteria(Baz.class).uniqueResult();
    assertTrue( s.createFilter( baz.getMoreParts(), "" ).list().size()==2 );
    //assertTrue( baz.getParts().size()==1 );
    s.delete( s.get( Part.class, p1.getId() ));
    s.delete( s.get( Part.class, p2.getId() ));
    s.delete(baz);
    t.commit();
View Full Code Here
587
588
589
590
591
592
593
594
595
596
597
              .size() == 1
      );
    }
    assertTrue( s.contains(cd) );
    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof HSQLDialect) )  {
      s.createFilter( c.getBag(), "where 0 in elements(this.bag)" ).list();
      s.createFilter( c.getBag(), "where 0 in elements(this.lazyBag)" ).list();
    }
    s.createQuery( "select count(comp.name) from ContainerX c join c.components comp" ).list();
    s.delete(cd);
    s.delete(c);
View Full Code Here
588
589
590
591
592
593
594
595
596
597
598
      );
    }
    assertTrue( s.contains(cd) );
    if ( !(getDialect() instanceof MySQLDialect) && !(getDialect() instanceof HSQLDialect) )  {
      s.createFilter( c.getBag(), "where 0 in elements(this.bag)" ).list();
      s.createFilter( c.getBag(), "where 0 in elements(this.lazyBag)" ).list();
    }
    s.createQuery( "select count(comp.name) from ContainerX c join c.components comp" ).list();
    s.delete(cd);
    s.delete(c);
    s.delete(s1);
View Full Code Here
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
    s.beginTransaction();
    baz = (Baz) s.load( Baz.class, baz.getCode() );
    assertTrue( baz.getFooArray().length==1 );
    assertTrue( s.createQuery( "from Baz baz join baz.fooArray foo" ).list().size()==1 );
    assertTrue( s.createQuery( "from Foo foo" ).list().size()==2 );
    assertTrue( s.createFilter( baz.getFooArray(), "" ).list().size()==1 );
    //assertTrue( s.delete("from java.lang.Object o")==9 );
    doDelete( s, "from Foo foo" );
    String bazid = baz.getCode();
    s.delete(baz);
    int rows=s.connection().createStatement().executeUpdate(
View Full Code Here
467
468
469
470
471
472
473
474
475
476
477
      assertTrue( ( (Object[]) iter.next() )[1] instanceof Fum );
    }
    assertTrue( "iterate on composite key", j==8 );

    fum = (Fum) s.load( Fum.class, fum.getId() );
    s.createFilter( fum.getQuxArray(), "where this.foo is null" ).list();
    s.createFilter( fum.getQuxArray(), "where this.foo.id = ?" )
        .setParameter( 0, "fooid", Hibernate.STRING )
        .list();
    Query f = s.createFilter( fum.getQuxArray(), "where this.foo.id = :fooId" );
    f.setString("fooId", "abc");
View Full Code Here
468
469
470
471
472
473
474
475
476
477
478
    }
    assertTrue( "iterate on composite key", j==8 );

    fum = (Fum) s.load( Fum.class, fum.getId() );
    s.createFilter( fum.getQuxArray(), "where this.foo is null" ).list();
    s.createFilter( fum.getQuxArray(), "where this.foo.id = ?" )
        .setParameter( 0, "fooid", Hibernate.STRING )
        .list();
    Query f = s.createFilter( fum.getQuxArray(), "where this.foo.id = :fooId" );
    f.setString("fooId", "abc");
    assertFalse( f.iterate().hasNext() );
View Full Code Here
471
472
473
474
475
476
477
478
479
480
481
    fum = (Fum) s.load( Fum.class, fum.getId() );
    s.createFilter( fum.getQuxArray(), "where this.foo is null" ).list();
    s.createFilter( fum.getQuxArray(), "where this.foo.id = ?" )
        .setParameter( 0, "fooid", Hibernate.STRING )
        .list();
    Query f = s.createFilter( fum.getQuxArray(), "where this.foo.id = :fooId" );
    f.setString("fooId", "abc");
    assertFalse( f.iterate().hasNext() );

    iter = s.createQuery( "from Fum fum where not fum.fum='FRIEND'" ).iterate();
    int i = 0;
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.