Hi,

I have a question regarding Hibernate mapping configuration. I have tried on this for some time and thought to take opinions if someone has already come across a similar situation. Actually, I need to generate XML file with elements having sub-elements up to various levels.

I tried to map two different tables and could generate sub-elements in resulting XML successfully.

But, my required scenario is that I have a stored procedure which returns an auto generated id column and other columns data which is actually an outer join of many stored procedures. Here, we have a requirement to add few columns as sub-element of other column from the same result set to the resulting XML. i.e. the result of a stored procedure has to form XML with various columns having relations with each other as parent/child tags.

I am badly stuck with this for a long time. I would appreciate a quick help.

Thanks in advance.

Best Regards
Gaurav Thaker

you need to show some concrete examples...

Max,

Thanks for taking interest. The example mapping that I am trying is something like below:

<hibernate-mapping>
<class entity-name="team_directory_detail" node="team_directory_detail" >

<id name="user_id" column="user_id" type="java.lang.Integer" node="user_id"/>
<property name="fname" column="fname" type="java.lang.String" node ="user-name" insert="false" update="false"/>
<property name="lname" column="lname" type="java.lang.String" node ="org-name" insert="false" update="false"/>
<property name="org_name" column="org_name" type="java.lang.String" node ="session_status" insert="false" update="false"/>
<property name="role_name" column="role_name" type="java.lang.String" node ="role-name" insert="false" update="false"/>
<property name="telephone" column="telephone" type="java.lang.String" node ="telephone" insert="false" update="false"/>
<property name="mobile" column="mobile" type="java.lang.String" node ="mobile" insert="false" update="false"/>
<property name="email" column="email" type="java.lang.String" node ="email" insert="false" update="false"/>
<property name="LastLoginDtTm" column="LastLoginDtTm" type="java.lang.String" node ="LastLoginDtTm" insert="false" update="false"/>

<map name="accounts"
node="myNode"
embed-xml="true">
<key column="fname"
not-null="true"/>
<map-key column="role_name"
node="@role_name"
type="string"/>
<many-to-many entity-name="team_directory_detail1"
embed-xml="false"
node="email"/>
</map>

</class>
<sql-query name="team_dir_detail_SP" callable="true">
<return alias="team_directory_detail" class="team_directory_detail">
<return-property name="user_id" column="user_id"/>
<return-property name="fname" column="fname"/>
<return-property name="lname" column="lname"/>
<return-property name="org_name" column="org_name"/>
<return-property name="role_name" column="role_name"/>
<return-property name="telephone" column="telephone"/>
<return-property name="mobile" column="mobile"/>
<return-property name="email" column="email"/>
<return-property name="LastLoginDtTm" column="LastLoginDtTm"/>
</return>
{ call getTeamDirectory_XML ( :project_id,:role_id,:org_id,:name,:server,:database ) }
</sql-query>
</hibernate-mapping>

Here, I am trying to generate an XML where there will be a tag for user id and then it will have sub element org_name and then org_name will have role_name as sub element like wise. I will appreciate If you can give me any hints or example on how to configure the <map> part of above configuration.

Note: The <map> part above is messed up by me while doing various trials.

Thanks
Gaurav