John, Do you call
broker.abortTransaction() ; when you catch the exception. -chris worley > hmmm. I must be missing something, but I thought if I called > persistanceBroker.beginTransaction(); > persistanceBroker.store(brokerVO); > and if there was an exception and persistanceBroker.commitTransaction(); > never gets called, then the data should not be in the database. > > I am storing a BrokerVO that has N BusinessContact objects, and if one of > the businesContacts fails to insert, I want the whole transaction to > rollback. I am not sure what I am doing wrong here. If any part of the > transaction fails (I am inserting into three tables), I want all of the > data > to rollback. > > > <snip> > <class-descriptor class="com.kraft.esi.msf.common.db.dsna.BrokerVO" > schema="&schema;" table="brkr"> > <field-descriptor id="1" name="brkrNbr" column="BP_NBR" > jdbc-type="DECIMAL" primarykey="true"/> > <field-descriptor id="2" name="vendNbr" column="AP_VNDR_NBR" > jdbc-type="VARCHAR" /> > > <field-descriptor id="3" name="brkrEffStrtDate" > column="EFCT_STRT_DT" jdbc-type="DATE" > > conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFi > eldConversion"/> > <field-descriptor id="4" name="brkrEffEndDate" > column="EFCT_END_DT" jdbc-type="DATE" > > conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFi > eldConversion"/> > <field-descriptor id="5" name="brkrComment" column="CMNT" > jdbc-type="VARCHAR"/> > > <reference-descriptor name="busnPtnrVO" > class-ref="com.kraft.esi.msf.common.db.dsna.BusnPtnrVO" > auto-retrieve="true" > auto-update="true" auto-delete="true"> > <foreignkey field-id-ref="1"/> > </reference-descriptor> > > <reference-descriptor name="apVndrVO" > class-ref="com.kraft.esi.msf.common.db.dsna.ApVndrVO" auto-retrieve="true" > auto-update="false" auto-delete="false"> > <foreignkey field-id-ref="2"/> > </reference-descriptor> > <!-- --> > <collection-descriptor name="businessContacts" > element-class-ref="com.kraft.esi.msf.common.db.dsna.BpCntctVO" > auto-retrieve="true" auto-update="true" > auto-delete="true" orderby="cntctTypeCode" sort="ASC" > proxy="false" > > <inverse-foreignkey field-id-ref="1"/> > </collection-descriptor> > > </class-descriptor> > > <snip> > > I am using WebSphere transaction manager factory, and > ConnectionFactoryManagedImpl. > > any help would be greatly appreciated. > > -John > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
