Hibernate relationl table with aditional column

[Ahasan Habib]

Dear experts,

I am facing problem in composite-element mapping of hibernate. My expected relation is many to many in document and task. That is a task may have multiple documents and a document may have assigned to multiple task. Relational table will contain both foregin key with additional column. In attachment I have given the tables structures.

My Task hbm file:

  
<class name="com.dmcs.model.tm.TaskInfo" table="TM_TASK">
   		<id name="taskId" column="TASK_ID"> 
       		<generator class="increment" />
    	</id> 
 		<property name="taskUdId" column="TASK_UDID" />  
 		<property name="taskName" column="TASK_NAME" unique="true" />
 		<property name="taskType" column="TASK_TYPE" />
 		<property name="dscp" column="DSCP" />
 		<property name="timeLength" column="TIME_LENGTH" />
 		<property name="rmks" column="RMKS" />
 		<property name="actFg" column="ACT_FG" />
 		<property name="actDt" column="ACT_DT" />
 		<property name="creBy" column="CRE_BY" />
 		<property name="creDt" column="CRE_DT" />  
 		<property name="updBy" column="UPD_BY" />
 		<property name="updDt" column="UPD_DT" />
 		
    	<many-to-one name="orgInfo" class="com.dmcs.model.org.OrgInfo"  
    		column="ORG_ID" not-null="true" unique="true" cascade="save-update,merge"/>    	
    	
    	<set  name="docInfoList"  table="TM_TASKDOCS"  cascade="save-update">
			<key column="taskId" /> 	
						
		<composite-element class="com.dmcs.model.tm.TaskDocsInfo">		
			<many-to-one name="docInfo" column="documentId" class="com.dmcs.model.document.DocumentInfo" />
			<property name="rmks" column="RMKS"/>
		</composite-element>
		 
		</set>
		
    	</class>

  

My document hbm file:

   
<class name="com.dmcs.model.document.DocumentInfo" table="DOCUMENT">
		
		<id name="documentId" column="DOC_ID">
			<generator class="increment" />
		</id>		
		
		<property name="data">
		<column name="DATA" sql-type="MEDIUMBLOB"></column>
		</property>
		<property   name="fileName" column="FILENAME" />		
		<property   name="contentType" column="CONTENTTYPE" />
		<property   name="comments" column="COMMENTS" />
		<property   name="userId" column="USER_ID" type="long"/>		
		<property   name="createDate"  type="timestamp" column="CREATE_DATE">
		</property>
		
		<set name="docRevisionSet" cascade="delete" table="DOC_REVISION">
			<key column="DOC_ID" />
			<one-to-many class="com.dmcs.model.docrevision.DocRevisionInfo" />
		</set>
		
		
		<set  name="taskInfoList"  table="TM_TASKDOCS" cascade="save-update">
			<key column="documentId" />
			<many-to-many  column="taskId" class="com.dmcs.model.tm.TaskInfo" />		
		</set>
			
	</class>
 

I have created all mapping files. My question what will be the java code for inserting in TM_TASK table as well as for TM_TASKDOCS table. And what will be the TaskDocsInfo class exactly. where I have to create the composite class instance and have to assign this instance? I have tried with the following code but fails

   
                taskInfo = new TaskInfo();
		taskInfo.getDocInfoList().add(D1);
		taskInfo.getDocInfoList().add(D2);
		taskInfo.getDocInfoList().add(D3);		
		
		taskInfo.setTaskUdId(taskUdId);
		taskInfo.setTaskName(taskName);
		taskInfo.setTaskType(taskType);
		taskInfo.setDscp(dscp);
		taskInfo.setTimeLength(timeLength);
		taskInfo.setRmks(rmks);
		taskInfo.setActDt(DateTime.getDateTimeObj());		
		taskInfo.setCreBy(userId);
		taskInfo.setCreDt(DateTime.getDateTimeObj());
		taskInfo.setUpdBy(userId);
		taskInfo.setUpdDt(DateTime.getDateTimeObj());		
		orgInfo = new OrgInfo();			
		taskInfo.setOrgInfo(orgInfo);
		taskInfo.setActFg("Y");	
		
		taskService.add(taskInfo);

              //insert into data base 

		Session session = HibernateUtil.getSession();
		Transaction tx = null;
	
		try 
		{
			tx = session.beginTransaction();
			session.merge(taskInfo);
			tx.commit();
		} 
		catch (Exception e) 
		{
			if(tx != null) tx.rollback();
			e.printStackTrace();
			
		} 
		finally 
		{
			session.close();
		}

 

Please help.

Thanks in advance

[Ahasan Habib]

Please reply anyone

[Ahasan Habib]

No one here to help

[Randeep Singh Arora]

send me your code and contact me at skype rsingh008.I may be able to help you out...

[Ahasan Habib]

Hi Mr. Randeep Singh,

I have added you on skype (my id: sumon.dsl) but can not get you online. Please help.

Thanks in advance