-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Hibernate: cant get the associated List retrieved
PostPosted: Thu Aug 26, 2010 12:39 pm 
Newbie

Joined: Tue Aug 24, 2010 7:24 am
Posts: 9
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.
At present its hibernateTemplate.find("from X").
or What annonations do I use for it?

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

Code:
@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

Code:
@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
Code:
@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


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.