Methods Summary |
---|
public void | configure(org.hibernate.cfg.Configuration cfg)
cfg.setProperty(Environment.GENERATE_STATISTICS, "true");
|
public java.lang.String | getCacheConcurrencyStrategy()
return null;
|
public java.lang.String[] | getMappings()
return new String[] { "subselectfetch/ParentChild.hbm.xml" };
|
public static junit.framework.Test | suite()
return new FunctionalTestClassTestSuite( SubselectFetchTest.class );
|
public void | testManyToManyCriteriaJoin()
Session s = openSession();
Transaction t = s.beginTransaction();
Parent p = new Parent("foo");
p.getChildren().add( new Child("foo1") );
p.getChildren().add( new Child("foo2") );
Parent q = new Parent("bar");
q.getChildren().add( new Child("bar1") );
q.getChildren().add( new Child("bar2") );
q.getMoreChildren().addAll( p.getChildren() );
s.persist(p);
s.persist(q);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
List parents = s.createCriteria(Parent.class)
.createCriteria("moreChildren")
.createCriteria("friends")
.addOrder( Order.desc("name") )
.list();
parents = s.createCriteria(Parent.class)
.setFetchMode("moreChildren", FetchMode.JOIN)
.setFetchMode("moreChildren.friends", FetchMode.JOIN)
.addOrder( Order.desc("name") )
.list();
s.delete( parents.get(0) );
s.delete( parents.get(1) );
t.commit();
s.close();
|
public void | testSubselectFetchCriteria()
Session s = openSession();
Transaction t = s.beginTransaction();
Parent p = new Parent("foo");
p.getChildren().add( new Child("foo1") );
p.getChildren().add( new Child("foo2") );
Parent q = new Parent("bar");
q.getChildren().add( new Child("bar1") );
q.getChildren().add( new Child("bar2") );
q.getMoreChildren().addAll( p.getChildren() );
s.persist(p);
s.persist(q);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
getSessions().getStatistics().clear();
List parents = s.createCriteria(Parent.class)
.add( Property.forName("name").between("bar", "foo") )
.addOrder( Order.desc("name") )
.list();
p = (Parent) parents.get(0);
q = (Parent) parents.get(1);
assertFalse( Hibernate.isInitialized( p.getChildren() ) );
assertFalse( Hibernate.isInitialized( q.getChildren() ) );
assertEquals( p.getChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( p.getChildren().iterator().next() ) );
assertTrue( Hibernate.isInitialized( q.getChildren() ) );
assertEquals( q.getChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( q.getChildren().iterator().next() ) );
assertFalse( Hibernate.isInitialized( p.getMoreChildren() ) );
assertFalse( Hibernate.isInitialized( q.getMoreChildren() ) );
assertEquals( p.getMoreChildren().size(), 0 );
assertTrue( Hibernate.isInitialized( q.getMoreChildren() ) );
assertEquals( q.getMoreChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( q.getMoreChildren().iterator().next() ) );
assertEquals( 3, getSessions().getStatistics().getPrepareStatementCount() );
Child c = (Child) p.getChildren().get(0);
c.getFriends().size();
s.delete(p);
s.delete(q);
t.commit();
s.close();
|
public void | testSubselectFetchHql()
Session s = openSession();
Transaction t = s.beginTransaction();
Parent p = new Parent("foo");
p.getChildren().add( new Child("foo1") );
p.getChildren().add( new Child("foo2") );
Parent q = new Parent("bar");
q.getChildren().add( new Child("bar1") );
q.getChildren().add( new Child("bar2") );
q.getMoreChildren().addAll( p.getChildren() );
s.persist(p);
s.persist(q);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
getSessions().getStatistics().clear();
List parents = s.createQuery("from Parent where name between 'bar' and 'foo' order by name desc")
.list();
p = (Parent) parents.get(0);
q = (Parent) parents.get(1);
assertFalse( Hibernate.isInitialized( p.getChildren() ) );
assertFalse( Hibernate.isInitialized( q.getChildren() ) );
assertEquals( p.getChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( p.getChildren().iterator().next() ) );
assertTrue( Hibernate.isInitialized( q.getChildren() ) );
assertEquals( q.getChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( q.getChildren().iterator().next() ) );
assertFalse( Hibernate.isInitialized( p.getMoreChildren() ) );
assertFalse( Hibernate.isInitialized( q.getMoreChildren() ) );
assertEquals( p.getMoreChildren().size(), 0 );
assertTrue( Hibernate.isInitialized( q.getMoreChildren() ) );
assertEquals( q.getMoreChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( q.getMoreChildren().iterator().next() ) );
assertEquals( 3, getSessions().getStatistics().getPrepareStatementCount() );
Child c = (Child) p.getChildren().get(0);
c.getFriends().size();
s.delete(p);
s.delete(q);
t.commit();
s.close();
|
public void | testSubselectFetchNamedParam()
Session s = openSession();
Transaction t = s.beginTransaction();
Parent p = new Parent("foo");
p.getChildren().add( new Child("foo1") );
p.getChildren().add( new Child("foo2") );
Parent q = new Parent("bar");
q.getChildren().add( new Child("bar1") );
q.getChildren().add( new Child("bar2") );
q.getMoreChildren().addAll( p.getChildren() );
s.persist(p);
s.persist(q);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
getSessions().getStatistics().clear();
List parents = s.createQuery("from Parent where name between :bar and :foo order by name desc")
.setParameter("bar", "bar")
.setParameter("foo", "foo")
.list();
p = (Parent) parents.get(0);
q = (Parent) parents.get(1);
assertFalse( Hibernate.isInitialized( p.getChildren() ) );
assertFalse( Hibernate.isInitialized( q.getChildren() ) );
assertEquals( p.getChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( p.getChildren().iterator().next() ) );
assertTrue( Hibernate.isInitialized( q.getChildren() ) );
assertEquals( q.getChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( q.getChildren().iterator().next() ) );
assertFalse( Hibernate.isInitialized( p.getMoreChildren() ) );
assertFalse( Hibernate.isInitialized( q.getMoreChildren() ) );
assertEquals( p.getMoreChildren().size(), 0 );
assertTrue( Hibernate.isInitialized( q.getMoreChildren() ) );
assertEquals( q.getMoreChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( q.getMoreChildren().iterator().next() ) );
assertEquals( 3, getSessions().getStatistics().getPrepareStatementCount() );
Child c = (Child) p.getChildren().get(0);
c.getFriends().size();
s.delete(p);
s.delete(q);
t.commit();
s.close();
|
public void | testSubselectFetchPosParam()
Session s = openSession();
Transaction t = s.beginTransaction();
Parent p = new Parent("foo");
p.getChildren().add( new Child("foo1") );
p.getChildren().add( new Child("foo2") );
Parent q = new Parent("bar");
q.getChildren().add( new Child("bar1") );
q.getChildren().add( new Child("bar2") );
q.getMoreChildren().addAll( p.getChildren() );
s.persist(p);
s.persist(q);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
getSessions().getStatistics().clear();
List parents = s.createQuery("from Parent where name between ? and ? order by name desc")
.setParameter(0, "bar")
.setParameter(1, "foo")
.list();
p = (Parent) parents.get(0);
q = (Parent) parents.get(1);
assertFalse( Hibernate.isInitialized( p.getChildren() ) );
assertFalse( Hibernate.isInitialized( q.getChildren() ) );
assertEquals( p.getChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( p.getChildren().iterator().next() ) );
assertTrue( Hibernate.isInitialized( q.getChildren() ) );
assertEquals( q.getChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( q.getChildren().iterator().next() ) );
assertFalse( Hibernate.isInitialized( p.getMoreChildren() ) );
assertFalse( Hibernate.isInitialized( q.getMoreChildren() ) );
assertEquals( p.getMoreChildren().size(), 0 );
assertTrue( Hibernate.isInitialized( q.getMoreChildren() ) );
assertEquals( q.getMoreChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( q.getMoreChildren().iterator().next() ) );
assertEquals( 3, getSessions().getStatistics().getPrepareStatementCount() );
Child c = (Child) p.getChildren().get(0);
c.getFriends().size();
s.delete(p);
s.delete(q);
t.commit();
s.close();
|
public void | testSubselectFetchWithLimit()
Session s = openSession();
Transaction t = s.beginTransaction();
Parent p = new Parent("foo");
p.getChildren().add( new Child("foo1") );
p.getChildren().add( new Child("foo2") );
Parent q = new Parent("bar");
q.getChildren().add( new Child("bar1") );
q.getChildren().add( new Child("bar2") );
Parent r = new Parent("aaa");
r.getChildren().add( new Child("aaa1") );
s.persist(p);
s.persist(q);
s.persist(r);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
getSessions().getStatistics().clear();
List parents = s.createQuery("from Parent order by name desc")
.setMaxResults(2)
.list();
p = (Parent) parents.get(0);
q = (Parent) parents.get(1);
assertFalse( Hibernate.isInitialized( p.getChildren() ) );
assertFalse( Hibernate.isInitialized( p.getMoreChildren() ) );
assertFalse( Hibernate.isInitialized( q.getChildren() ) );
assertFalse( Hibernate.isInitialized( q.getMoreChildren() ) );
assertEquals( p.getMoreChildren().size(), 0 );
assertEquals( p.getChildren().size(), 2 );
assertTrue( Hibernate.isInitialized( q.getChildren() ) );
assertTrue( Hibernate.isInitialized( q.getMoreChildren() ) );
assertEquals( 3, getSessions().getStatistics().getPrepareStatementCount() );
r = (Parent) s.get( Parent.class, r.getName() );
assertTrue( Hibernate.isInitialized( r.getChildren() ) );
assertFalse( Hibernate.isInitialized( r.getMoreChildren() ) );
assertEquals( r.getChildren().size(), 1 );
assertEquals( r.getMoreChildren().size(), 0 );
s.delete(p);
s.delete(q);
s.delete(r);
t.commit();
s.close();
|