@Test
public void testOneToOneOnSubclass() {
Map person = new HashMap();
person.put("name", "Steve");
Map address = new HashMap();
address.put("zip", "12345");
address.put("state", "TX");
address.put("street", "123 Main St");
person.put("address", address);
address.put("owner", person);
Session s = openSession();
s.beginTransaction();
s.persist("Person", person);
s.getTransaction().commit();
s.close();
s = openSession();
s.beginTransaction();
EntityStatistics addressStats = sessionFactory().getStatistics().getEntityStatistics("Address");
person = (Map) s.createQuery("from Person p join fetch p.address").uniqueResult();
assertNotNull("could not locate person", person);
assertNotNull("could not locate persons address", person.get("address"));
s.clear();
Object[] tuple =
(Object[])
s.createQuery("select p.name, p from Person p join fetch p.address").uniqueResult();
assertEquals(tuple.length, 2);
person = (Map) tuple[1];
assertNotNull("could not locate person", person);
assertNotNull("could not locate persons address", person.get("address"));
s.delete("Person", person);
s.getTransaction().commit();
s.close();
assertEquals(addressStats.getFetchCount(), 0);
}
@Test
public void testOneToOneOnSubclass() {
Person p = new Person();
p.name = "Gavin";
Address a = new Address();
a.entityName = "Gavin";
a.zip = "3181";
a.state = "VIC";
a.street = "Karbarook Ave";
p.address = a;
Session s = openSession();
Transaction t = s.beginTransaction();
s.persist(p);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
EntityStatistics addressStats =
sessionFactory().getStatistics().getEntityStatistics(Address.class.getName());
EntityStatistics mailingAddressStats =
sessionFactory().getStatistics().getEntityStatistics("MailingAddress");
p =
(Person)
s.createQuery("from Person p join fetch p.address left join fetch p.mailingAddress")
.uniqueResult();
assertNotNull(p.address);
assertNull(p.mailingAddress);
s.clear();
assertEquals(addressStats.getFetchCount(), 0);
assertEquals(mailingAddressStats.getFetchCount(), 0);
p = (Person) s.createQuery("from Person p join fetch p.address").uniqueResult();
assertNotNull(p.address);
assertNull(p.mailingAddress);
s.clear();
assertEquals(addressStats.getFetchCount(), 0);
assertEquals(mailingAddressStats.getFetchCount(), 1);
p = (Person) s.createQuery("from Person").uniqueResult();
assertNotNull(p.address);
assertNull(p.mailingAddress);
s.clear();
assertEquals(addressStats.getFetchCount(), 1);
assertEquals(mailingAddressStats.getFetchCount(), 2);
p = (Person) s.createQuery("from Entity").uniqueResult();
assertNotNull(p.address);
assertNull(p.mailingAddress);
s.clear();
assertEquals(addressStats.getFetchCount(), 2);
assertEquals(mailingAddressStats.getFetchCount(), 3);
// note that in here join fetch is used for the nullable
// one-to-one, due to a very special case of default
p = (Person) s.get(Person.class, "Gavin");
assertNotNull(p.address);
assertNull(p.mailingAddress);
s.clear();
assertEquals(addressStats.getFetchCount(), 2);
assertEquals(mailingAddressStats.getFetchCount(), 3);
p = (Person) s.get(Entity.class, "Gavin");
assertNotNull(p.address);
assertNull(p.mailingAddress);
s.clear();
assertEquals(addressStats.getFetchCount(), 2);
assertEquals(mailingAddressStats.getFetchCount(), 3);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
Org org = new Org();
org.name = "IFA";
Address a2 = new Address();
a2.entityName = "IFA";
a2.zip = "3181";
a2.state = "VIC";
a2.street = "Orrong Rd";
org.addresses.add(a2);
s.persist(org);
t.commit();
s.close();
s = openSession();
t = s.beginTransaction();
org = (Org) s.get(Entity.class, "IFA");
s.clear();
List list = s.createQuery("from Entity e order by e.name").list();
p = (Person) list.get(0);
assertNotNull(p.address);
assertNull(p.mailingAddress);
org = (Org) list.get(1);
assertEquals(org.addresses.size(), 1);
s.clear();
list =
s.createQuery(
"from Entity e left join fetch e.address left join fetch e.mailingAddress order by e.name")
.list();
p = (Person) list.get(0);
org = (Org) list.get(1);
assertNotNull(p.address);
assertNull(p.mailingAddress);
assertEquals(org.addresses.size(), 1);
s.delete(p);
s.delete(org);
t.commit();
s.close();
}
