Hibernate: not getting the associated List retrieved

[Rohit Bhal]

Hi

An entity X has a list of entity Y and the entity Y has an instance of entity Z.

The relation between X to Y is OneToMany and the relation between Y to Z is ManyToOne.

I want to retrieve X and have all the associated entities retrieved with them as well.

What HQL query do I write so that I get the whole chain retrieved all at once.
or What annonations do I use for it? At present its hibernateTemplate.find("from X").

X=ServiceProvider, Y=BusinessLocations.java, Z=State.java

I have the entities annotated below and I am having the whole chain persisted into database but when i try to retrieve the list of Y(BusinessLocation), I get nothing.

What do I do join X with Y and Y with Z?

Below are the entities x, Y and Z.

ServiceProvider.java

@Entity
public class ServiceProvider implements Serializable{
	
	private Long id;	
	private Set<BusinessLocation> businessLocations = new HashSet<BusinessLocation>();

	@Id
	@GeneratedValue
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}

	@OneToMany(mappedBy="serviceProvider", targetEntity=BusinessLocation.class, cascade=CascadeType.ALL, fetch=FetchType.EAGER)
	public Set<BusinessLocation> getBusinessLocations() {
		return businessLocations;
	}

	public void setBusinessLocations(Set<BusinessLocation> businessLocations) {
		this.businessLocations = businessLocations;
	}

	public boolean equals(Object obj) {
		if(!(obj instanceof ServiceProvider)) return false;
		ServiceProvider other = (ServiceProvider) obj;
		return new EqualsBuilder().append(businessLocations, other.businessLocations).isEquals();
	}
}

BusinessLocation.java

@Entity
public class BusinessLocation implements Serializable{
	
	private Long id;
	private String address;
	private String city;
	private State state;
	private String pincode;
	private ServiceProvider serviceProvider;
	
	public BusinessLocation() {		
	}
	
	@Id
	@GeneratedValue
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	public String getCity() {
		return city;
	}
	public void setCity(String city) {
		this.city = city;
	}
	
	@ManyToOne(cascade=CascadeType.ALL)
	@JoinColumn(name="state_id")
	public State getState() {
		return state;
	}
	public void setState(State state) {
		this.state = state;
	}	
	public void setPincode(String pincode) {
		this.pincode = pincode;
	}

	public String getPincode() {
		return pincode;
	}
	
	@ManyToOne
	@JoinColumn(name="serviceProvider_id")
	public ServiceProvider getServiceProvider() {
		return serviceProvider;
	}
	public void setServiceProvider(ServiceProvider serviceProvider) {
		this.serviceProvider = serviceProvider;
	}
	
	public boolean equals(Object obj) {
		if( !(obj instanceof BusinessLocation)) return false;
		BusinessLocation other = (BusinessLocation) obj;		
		return new EqualsBuilder().append(address, other.address).append(city, other.city).append(state, other.state).append(pincode, other.pincode).append(serviceProvider, other.serviceProvider).isEquals();
	}
	
	public int hashCode() {
		return new HashCodeBuilder().append(address).append(city).append(state).append(pincode).append(serviceProvider).toHashCode();
	}
}

State.java

@Entity
public class State implements Serializable {
	
	private Long id;
	private String abbreviatedName;
	private String name;
	private List<BusinessLocation> businessLocations;
	
	@Id
	@GeneratedValue	
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public String getAbbreviatedName() {
		return abbreviatedName;
	}
	public void setAbbreviatedName(String abbreviatedName) {
		this.abbreviatedName = abbreviatedName;
	}
	public void setName(String name) {
		this.name = name;
	}
	
	public String getName() {
		return name;
	}

	
	@OneToMany(mappedBy="state", targetEntity=BusinessLocation.class, cascade=CascadeType.ALL, fetch=FetchType.EAGER)
	public List<BusinessLocation> getBusinessLocations() {
		return businessLocations;
	}
	public void setBusinessLocations(List<BusinessLocation> businessLocations) {
		this.businessLocations = businessLocations;
	}
	
	public boolean equals(Object obj) {
		if(! (obj instanceof State)) return false;
		State other = (State) obj;
		return new EqualsBuilder().append(abbreviatedName, other.abbreviatedName).append(name, other.name).append(businessLocations, other.businessLocations).isEquals();
	}
	
	public int hashCode() {
		return new HashCodeBuilder().append(name).append(abbreviatedName).append(businessLocations).toHashCode();
	}

}

Could someone help me out here?

Thanks