I am trying to perform the following query:

query = session.createQuery("from Screen1HPBean screen where screen.termid = 'ABC');

//One object is found
Screen1HPBean screen = (Screen1HPBean)query.list().get(0);

//Now I can get information from ScreenqHPBean with no problem,
//but when I try to get - Set plans; it only returns one object of type //PlanBean when it should have returned 23
Set plans = screen.getPlans();
Iterator iter = plans.iterator();
while(iter.hasNext()){
LogService.log(LogService.DEBUG, "PLAN BEAN: " + ((PlanBean)iter.nex\t()).getMealPlan());
}

session.connection().commit();
session.close();
DbService.releaseConnection(con);

//the database contains 23 entries but only one is being returned.

Here is my database mapping file:

Anyhelp? Suggestions?

-------------------------------

--<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping schema="web001" package="edu.udel.dining">

<class name="edu.udel.dining.beans.Screen1HPBean" table="dining_screenbean">
<id name="id">
<column name="id" unique="true" not-null="true" sql-type="char"
length="32" />
<generator class="uuid.hex"/>
</id>
<property name="termid" type="string">
<column name="termid" length="3" not-null="true" />
</property>
<set name="plans" lazy="true">
<key column="id" />
<one-to-many class="edu.udel.dining.beans.PlanBean" />
</set>
</class>

<class name="edu.udel.dining.beans.PlanBean" table="dining_planbean">
<id name="id" column="id">
<generator class="uuid.hex"/>
</id>
<property name="mealPlan" type="string"/>
<property name="blackBoard" type="string"/>
<property name="numberOfMeals" type="string"/>
<property name="semesterAmount" type="string"/>
<property name="pointsAmount" type="string"/>
<property name="traditionalOption" type="int"/>
<property name="nonTraditionalOption" type="int"/>
<property name="allowCancellations" type="int"/>
</class>

</hibernate-mapping>
-----------------------------

Thanks in advance,
Luis

I guess, you got one-to-many mapping of Screen1HPBean wrong: key column should be the column which is foreign key to dining_planbean.id not the dining_screenbean.id

Hi, thanks for your reply. I am not sure I understand you though. See, this is how my database looks like:

Table dining_screenbean:
ID = 1234
TERMID = 04S

Table dining_planbeann
ID = 1234
MEALPLAN = 1
BLACKBOARD = A
NUMBEROFMEALS = 12

ID = 1234
MEALPLAN = 2
BLACKBOARD = B
NUMBEROFMEALS = 13

ID = 1234
MEALPLAN = 3
BLACKBOARD = 4
NUMBEROFMEALS = 14

and so on. So, for what I see the row ID on dining_planben is foreign _key to row ID on dining_screenbean. What do you say? Perhaps you could be more specific in what you are saying so I can give it a try?

Thanks again,
Luis

you're mapping files are wrong, if you look at data, at unicity, the result is ok.
you have defined the unicity of dining_planbeann on id.
Your example show 3 records but they all have id = 1234, --> so for hibernate, they are all the same, hibernate is going to stop at the first.

As i can see, for dining_planbeann, the unicity is a composite-id with ID AND MEALPLAN, so just map your object correctly and it will work.


Anthony

could you give me an example of how to use the composite-id?

I am getting lots of errors such as, repeating column mealPlan, add insert=false, update=false. When I add the insert and update attributes, I get errors saying that I should register them..... At this point I am very lost. I was trying to follow the example from the docs (Parent and chield, but it does not seen to work....

Any help? Thanks in advance!

Luis

or
if you don't need the association to be bidirectionnal.

Also implements Serializable and define equals/hashcode
http://www.hibernate.org/hib_docs/refer ... lshashcode

Nice..... now it works well.... Thanks a bunch,
Luis