Iam an absolute beginner when it comes to Hibernate. Iam attempting to create my first one-to-many relationship and am receiving the following output when I attempt to reference the value

[java] Welcome nikki massamanute
[java] This staff member manages a department!
[java] This staff member manages id: 3
[java] Hibernate: select dept0_.dept_id as dept1_2_0_, dept0_.dept_name as dept2_2_0_ from dept dept0_ where dept0_.dept_id=?
[java] This staff member manages:
[java] 24/03/2009 17:42:57 org.hibernate.impl.SessionFactoryImpl close
[java] INFO: closing
[java] 24/03/2009 17:42:57 org.hibernate.connection.DriverManagerConnectionProvider close
[java] INFO: cleaning up connection pool: jdbc:mysql://localhost:3306/timekeeper

So it's basically saying that they do manage a department but that it can't retrieve the dept_name when I throw

System.out.println("This staff member manages: " + thisStaff.getI_manage().getDept_name());

The following is my code:

<class name="com.timekeeper.model.Staff_Member" table="staff_member">
<id name="staff_member_id" column="staff_member_id">
<generator class="native"/>
</id>
<property name="manages_dept" insert="false" update="false" />
<many-to-one name="i_manage" column="manages_dept" class="com.timekeeper.model.Dept" />
<property name="first_name"/>
<property name="last_name"/>
<property name="pass_word"/>
<property name="staff_type_id"/>
<property name="email" />
</class>

i_manage is a Dept object which (as far as I can tell) is correctly mapped.

How are you getting thisStaff?

In ur o/p I see only select for dept. Why select for staff_member is not thr?

thisStaff = (Staff_Member) session.createQuery("from Staff_Member where email='" + UName + "' and pass_word='" + PWord + "'").uniqueResult();

which gives the output:

Hibernate: select staff_memb0_.staff_member_id as staff1_0_, staff_memb0_.manages_dept as manages2_0_, staff_memb0_.first_name as first3_0_, staff_memb0_.last_name as last4_0_, staff_memb0_.pass_word as pass5_0_, staff_memb0_.staff_type_id as staff6_0_, staff_memb0_.email as email0_ from staff_member staff_memb0_ where staff_memb0_.email='flowers@gmail.com' and staff_memb0_.pass_word='flowers'

this is then followed by the call to fetch the dept_name as stated in the original post.

Cheers

Well then... ur code and mapping looks fine... Double check if the data is thr in the DB ;-)

Because Iam new to Hibernate I was sure that the problem must be with my Hibernate script. As it turns out you were right the problem was with my database. Stupidly enough my sql was inserting the dept_name into the dept_id and Iam surprised that mysql didn't report an error due to mismatched data types. In checking my table I saw that the dept_name was blank for each of the entries.

Fixed it and now it works perfectly thanks.

Cheers

[java] Welcome nikki massamanute
[java] This staff member manages a department!
[java] This staff member manages id: 3
[java] Hibernate: select dept0_.dept_id as dept1_2_0_, dept0_.dept_name as dept2_2_0_ from dept dept0_ where dept0_.dept_id=?
[java] This staff member manages: information technology

Rating is welcome... :-)