Hi
hibernate3
parent table sys_users,primary key id
child table bbs_topics,foreign key userid

pojos SysUsers.java,BbsTopics.java

in child mapping file, there is no userid field replaced by a set.
how can I get the userid contents directly without using SysUsers

what?

Hi,

Please post the relevant java code and the hbm files.

If you need one to many mapping, you can define a set and have a one-to-many mapping.

There's a section in Hibernate reference, Chapter 2 - Introductionto Hibernate. (Mapping Associations). Please read this. This would really help.

SysUsers.hbm.xml:
<class name="SysUsers" table="sys_users">
<id name="id" column="Userid" type="java.lang.String">
<generator class="assigned"/>
</id>

<property name="password" column="Password" type="java.lang.String" />
<property name="username" column="Username" type="java.lang.String" />
......
<set name="bbsTopicSet" inverse="true">
<key column="Creator"/>
<one-to-many class="BbsTopic"/>
</set>
......

BbsTopic.hbmlxml:
<class name="BbsTopic" table="bbs_topic">
<id name="id" column="ID" type="java.lang.String">
<generator class="uuid.hex"/>
</id>

<property name="topic" column="topic" type="java.lang.String" />
......
<many-to-one name="sysUsers" column="Creator" class="SysUsers" />

How can I get the column Creator's date in table bbs_topic?

bbsTopicSet.getsysUsers().getCreator()