Hi all ,

this is the code I am using and I am not able to update the BOMDEFN table...please help I am new to Hibernate.


thanks

-----------------------------------------------------------------------------
ContentObject contentObj = (ContentObject)getHibernateTemplate().load(ContentObject.class, contentObjectOid);

BOMDefn bd = (BOMDefn)getHibernateTemplate().load(BOMDefn.class, new Long("0"));

contentObj.getBoms().add(bd);
getHibernateTemplate().save(contentObj);

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

these are the mappings

<class name="ContentObject" table="Content_Object" discriminator-value="contentObject">
<id name="oid" type="java.lang.Long" column="oid">
<generator class="sequence">
<param name="sequence">Content_Object_Seq</param>
</generator>
</id>

<discriminator column="type"/>

<!-- Entity attributes -->
<property name="name" column="name" type="java.lang.String"/>
<property name="description" type="java.lang.String"/>
<property name="keywords" type="java.lang.String"/>
<property name="contentId" type="java.lang.String"/>
<property name="externalId" type="java.lang.String"/>
<property name="documentType" type="java.lang.String"/>
<property name="bizStatus" type="java.lang.String"/>
<property name="user" type="java.lang.String"/>
<property name="createTimestamp" column="createts" type="java.sql.Timestamp"/>
<property name="modifiedTimestamp" column="modifiedts" type="java.sql.Timestamp"/>

<!-- Entity attributes -->

<!-- Relationships -->
<set name="boms" table="BOMDefn_ContentObject_MM" >
<key column="Content_ObjectOid"/>
<many-to-many column="BOMDefnOid" class="vz.esm.edm.pom.BOMDefn"/>
</set>

</class>


<class name="BOMDefn" table="BOMDefn">
<id name="oid" type="java.lang.Long" column="oid">
<generator class="sequence">
<param name="sequence">BOMDefn_Seq</param>
</generator>
</id>

<!-- Entity attributes -->
<property name="name" type="java.lang.String"/>
<property name="displayName" type="java.lang.String"/>
<property name="requestSystem" type="java.lang.String"/>

<!-- Relationships -->


<set name="contentObjects" table="BOMDefn_ContentObject_MM" >
<key column="BOMDefnOid"/>
<many-to-many column="Content_ObjectOid" class="vz.esm.edm.pom.ContentObject"/>
</set>

</class>

Hi Pradeepbill,

1) It looks like you're trying to implement a bidirectional many-to-many association. Therefore, you need to make sure that you:

(a) map one end of the association with 'inverse="true"';

(b) make sure to add() to the the Collections on both ends of the bidirectional association, not just one end (i.e., just like you would do in regular Java if there were no persistence layer); and

2) Looking at this Java code:



What is the call to save() supposed to do there? save() is what you call on a transient object to make it persistent. contentObj in this case is already persisitent — you got it from load().

You might think from the names that save() is the opposite of load(), but it's not. delete() is the opposite of save().

cheers,
—ml—

Hi ml,
thanks for the reply,
what does adding both ends of collection mean? I mean from the code I posted can u give some idea?


thanks in advance

pradeep

Hi Pradeep,

It means something along the lines of
[/quote]

thanks for the instant reply.

pradeep

Hi ml,
can you suggest me a good book , which gives good concepts on the reelationships and other things.?

thanks
Pradeep

The reference documentation for Hibernate is better than most open-source projects.
For further reading, Hibernate In Action is the "bible of Hibernate" (TM). (It's an excellent reference as well). Expect to spend some time soaking in the concepts though - it's not as easy a read as some other books. Some concepts may take a second reading to make clearer sense. Check out: http://www.manning.com/bauer
And if you can afford it or get your employer to pay for it, official training is obviously a great way of getting up to speed as well.
HTH
Satish