I just recreated, in minimalistic style, your situation and ran your query in 3.2.4sp1. I'm getting a row returned from my test case. Must be something other than the upgrade.
Mike
Employer.java
Code:
package test.jdcyuen;
public class Employer {
private Long id;
private String organizationName;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getOrganizationName() {
return organizationName;
}
public void setOrganizationName(String organizationName) {
this.organizationName = organizationName;
}
}
Occupation.javaCode:
package test.jdcyuen;
public class Occupation {
private Long id;
private Employer employer;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Employer getEmployer() {
return employer;
}
public void setEmployer(Employer employer) {
this.employer = employer;
}
}
Person.javaCode:
package test.jdcyuen;
public class Person {
private Long id;
private String firstName;
private String lastName;
private Occupation occupation;
public String getFirstName() {
return firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
public Occupation getOccupation() {
return occupation;
}
public void setOccupation(Occupation occupation) {
this.occupation = occupation;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
}
Employer.hbm.xmlCode:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="test.jdcyuen">
<class name="Employer" table="jdcyuen_employer">
<id name="id" column="id">
<generator class="increment" />
</id>
<property name="organizationName"/>
</class>
</hibernate-mapping>
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="test.jdcyuen">
<class name="Occupation" table="jdcyuen_occupation">
<id name="id" column="id">
<generator class="increment" />
</id>
<many-to-one name="employer"/>
</class>
</hibernate-mapping>
Person.hbm.xmlCode:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="test.jdcyuen">
<class name="Person" table="jdcyuen_person">
<id name="id" column="id">
<generator class="increment" />
</id>
<property name="firstName"/>
<property name="lastName"/>
<many-to-one name="occupation"/>
</class>
</hibernate-mapping>
Code:
package test.jdcyuen;
import java.util.List;
import junit.framework.TestCase;
import org.hibernate.Query;
import org.hibernate.Session;
public class TestIt extends TestCase {
public void testIt() {
Long id = createPersonInDatabase();
Session s = HibernateUtil.getSession();
Employer e = (Employer)s.createCriteria(Employer.class).uniqueResult();
Query query = s.createQuery("from Person p where p.firstName = :firstName and p.lastName = :lastName and p.occupation.employer.organizationName = :employer");
query.setParameter("firstName", "fn");
query.setParameter("lastName", "ln");
query.setParameter("employer", "on");
List results = query.list();
System.out.println("size="+results.size());
s.close();
}
private Long createPersonInDatabase() {
Session s = HibernateUtil.getSession();
s.beginTransaction();
Employer e = new Employer();
e.setOrganizationName("on");
s.save(e);
Occupation o = new Occupation();
o.setEmployer(e);
s.save(o);
Person p = new Person();
p.setFirstName("fn");
p.setLastName("ln");
p.setOccupation(o);
Long id = (Long)s.save(p);
s.getTransaction().commit();
s.close();
return id;
}
}
ConsoleCode:
Hibernate: select max(id) from jdcyuen_employer
Hibernate: select max(id) from jdcyuen_occupation
Hibernate: select max(id) from jdcyuen_person
Hibernate: insert into jdcyuen_employer (organizationName, id) values (?, ?)
Hibernate: insert into jdcyuen_occupation (employer, id) values (?, ?)
Hibernate: insert into jdcyuen_person (firstName, lastName, occupation, id) values (?, ?, ?, ?)
Hibernate: select this_.id as id2_0_, this_.organizationName as organiza2_2_0_ from jdcyuen_employer this_
Hibernate: select person0_.id as id0_, person0_.firstName as firstName0_, person0_.lastName as lastName0_, person0_.occupation as occupation0_ from jdcyuen_person person0_, jdcyuen_occupation occupation1_, jdcyuen_employer employer2_ where person0_.occupation=occupation1_.id and occupation1_.employer=employer2_.id and person0_.firstName=? and person0_.lastName=? and employer2_.organizationName=?
size=1
Login
FAQ
Search
