one to many mapping Spring Hibernate

[vivien siu]

hi I need some help on this:
One prod_id in the Product table will have many prod_id in the Infra_services table. But somehow I'm getting only one row of data from Infra_services table everytime.

here's my mapping files:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<hibernate-mapping>
<class name="com.tm.wsbs.batch.model.Infraservices" table="INFRA_SERVICES">
<id name="infra_services_id" column="INFRA_SERVICE_ID">
<generator class="increment"></generator>
</id>
<property name="datcode" column="DATCODE"></property>
<property name="sefcode" column="SEFCODE"></property>
<property name="rev_code" column="REV_CODE"></property>
<property name="acct_code" column="ACCT_CODE"></property>
<property name="prod_charge_type" column="CHARGE_TYPE"></property>
</class>
</hibernate-mapping>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<hibernate-mapping>
<class name="com.tm.wsbs.batch.model.Product" table="PRODUCT">
<id name="prod_id" column="PROD_ID">
<generator class="increment"></generator>
</id>
<property name="prod_name" column="PROD_NAME"></property>
<property name="prod_category" column="PROD_CATEGORY"></property>
<property name="prod_subcategory" column="PROD_SUBCATEGORY"></property>

<set name="infraservices" table="INFRA_SERVICES" >
            <key column="prod_id" />
            <one-to-many class="com.tm.wsbs.batch.model.Infraservices" />
        </set>
</class>
 
</hibernate-mapping>

and the java bean files will be:

 public class Product implements Serializable {
private String prod_id;
private String prod_name;
private String prod_category;
private String prod_subcategory;
private String prod_dat_code;
private String prod_sef_code;
private String prod_price;
private String rev_code;
private String acct_code;
private String prod_charge_type;
private Set infraservices;
 
public String getAcct_code() {
return acct_code;
}
 
public String getProd_category() {
return prod_category;
}
 
public String getProd_charge_type() {
return prod_charge_type;
}
 
public String getProd_dat_code() {
return prod_dat_code;
}
 
public String getProd_id() {
return prod_id;
}
 
public String getProd_name() {
return prod_name;
}
 
public String getProd_price() {
return prod_price;
}
 
public String getProd_sef_code() {
return prod_sef_code;
}
 
public String getProd_subcategory() {
return prod_subcategory;
}
 
public String getRev_code() {
return rev_code;
}
 
public void setAcct_code(String acct_code) {
this.acct_code = acct_code;
}
 
public void setProd_category(String prod_category) {
this.prod_category = prod_category;
}
 
public void setProd_charge_type(String prod_charge_type) {
this.prod_charge_type = prod_charge_type;
}
 
public void setProd_dat_code(String prod_dat_code) {
this.prod_dat_code = prod_dat_code;
}
 
public void setProd_id(String prod_id) {
this.prod_id = prod_id;
}
 
public void setProd_name(String prod_name) {
this.prod_name = prod_name;
}
 
public void setProd_price(String prod_price) {
this.prod_price = prod_price;
}
 
public void setProd_sef_code(String prod_sef_code) {
this.prod_sef_code = prod_sef_code;
}
 
public void setProd_subcategory(String prod_subcategory) {
this.prod_subcategory = prod_subcategory;
}
 
public void setRev_code(String rev_code) {
this.rev_code = rev_code;
}
 
public Set getInfraservices() {
return infraservices;
}
 
public void setInfraservices(Set infraservices) {
this.infraservices = infraservices;
}
 
}
   

Can someone point out how I'm suppose to get multiple rows of data finstead of just one row? Thanks!

[vivien siu]

never mind it's ok already. I solved it
[ August 02, 2006: Message edited by: vivien siu ]

[Gregg Bolinger]

I am so glad you solved the problem. But why not share your solution with everyone else? That way, we can all learn from one another.

Also, it would seem that this question is only about Hibernate, so I am moving this to our ORM forum.

Thanks.

[Ghulam Rashid]

Is this something you have missing entry for <many-to-one> in the mapping file of com.tm.wsbs.batch.model.Infraservices ?