INSERT INTO VPE_RFP_LI_HDR (JPA_ID, AVC, CONTR_DOC, COURT_CURR_CDE, CRE_BY, CRE_DT, CUST_BRNCH_CDE, CUST_REG_CDE, CUST_SGMNT, CUST_TYPE, DEF_CU_CDE, GCHID, MASTER_CONTR_ID, NSAPID, OPP_ID, OPP_NME, QTE_DATE, QTE_ID, QTE_LANG_CDE, QTE_NME, QTE_VER, QTE_SYS, QTE_TYPE, REQ_CONTEXT, REQ_TYPE, REV_LOC_CDE, SALES_REP_ENT_LVL, SALES_REP_VZ_ID, SUB_NASPID, TERM, UPDT_BY, UPDT_DT, VZ_PRIM_LEGL_ENT, JPA_VER) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO VPE_RFP (JPA_ID, CRE_BY, CRE_DT, PRICE_SCEN_ID, QTE_ID, REQ_VER, SCEN_VER, TRANS_TYPE, UPDT_BY, UPDT_DT, JPA_VER, TRN_RFP_HDR_JPA_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO VPE_RFP_LI (JPA_ID, CW_FEAT_ID, CW_PROD_ITEM_ID, CRE_BY, CRE_DT, CU_OVRRD, CUST_PB_ID, FEAT_ACT_TYPE, LANG_OVRRD, LI_ID, ORD_TYPE, GCHID, PB_LINE_ID, PROD, PRODUCTACTIVITYTYPE, PROD_FEAT, QTY, SOL, UPDT_BY, UPDT_DT, VZ_LEGL_ENT_OVRRD, JPA_VER, ORIG_SITE_JPA_ID, TERM_SITE_JPA_ID, RFP_LI_ACCESS_COST_JPA_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO VPE_RFP_SEL_PROMO (JPA_ID, CRE_BY, CRE_DT, PROMO_ID, UPDT_BY, UPDT_DT, JPA_VER) VALUES (?, ?, ?, ?, ?, ?, ?)

UPDATE VPE_RFP_LI SET TRN_RFP_LI_JPA_ID = ? WHERE (JPA_ID = ?)

UPDATE VPE_RFP_SEL_PROMO SET RFP_LI_SEL_PROMO_JPA_ID = ? WHERE (JPA_ID = ?)

@Entity
@Table(name="VPE_RFP")
public class RequestForPricing extends AbstractDomainObject
{
   @JoinColumn(name="TRN_RFP_HDR_JPA_ID")
   @OneToOne(cascade = { CascadeType.PERSIST,CascadeType.REFRESH}, fetch = FetchType.LAZY)
   public RequestForPricingHeader getRequestForPricingHeader()
   
   @JoinColumn(name="TRN_RFP_LI_JPA_ID")
   @OneToMany(cascade = { CascadeType.PERSIST,CascadeType.REFRESH}, targetEntity=RequestForPricingLineItem.class, fetch = FetchType.LAZY )
   public List<RequestForPricingLineItem> getRequestForPricingLineItem()

   @JoinColumn(name="RFP_LI_QTE_SEL_PROMO_JPA_ID")
   @OneToMany(cascade = { CascadeType.PERSIST,CascadeType.REFRESH}, targetEntity=RequestForPricingQuoteLevelSelectedPromotion.class, fetch = FetchType.LAZY )
   public List<RequestForPricingQuoteLevelSelectedPromotion> getRequestForPricingQuoteLevelSelectedPromotion()
}

    @PrivateOwned
    @OneToMany(cascade = {CascadeType.ALL}, fetch = FetchType.LAZY)
    @JoinColumn(name = "CITY_ID", referencedColumnName = "CITY_ID", insertable = true, updatable = true, nullable = false)
    @BatchFetch(BatchFetchType.IN)
    private List<CityNameEntity> names;

    @ManyToOne(cascade = {}, fetch = FetchType.LAZY, optional = false)
    @JoinColumn(name = "CITY_ID", nullable = false)
    private CityEntity city;

public class OurMappingCustomizer implements DescriptorCustomizer {
...
protected void customize(ClassDescriptor descriptor, DatabaseMapping mapping) {
    for (DatabaseMapping mapping : descriptor.getMappings()) {
        if (mapping.isOneToManyMapping()) {
            OneToManyMapping oneToManyMapping = (OneToManyMapping) mapping;
            if (oneToManyMapping.isCascadeRemove() && 
                oneToManyMapping.isPrivateOwned()) {
                Vector<DatabaseField> targetForeignKeyFields = oneToManyMapping.getTargetForeignKeyFields();
                if (targetForeignKeyFields.size() == 1 && 
                    !targetForeignKeyFields.get(0).isUpdatable() && !targetForeignKeyFields.get(0).isNullable()) {
                    oneToManyMapping.setCustomAddTargetQuery(EMPTY_UPDATE_QUERY);
                }
        ...
        }
    }
}

  @PrivateOwned
  @OneToMany(cascade = {CascadeType.ALL}, fetch = FetchType.LAZY)
  @JoinColumn(name = "..._ID", referencedColumnName = "..._ID", insertable = true, updatable = false, nullable = false)
    private List<SubEntity> names;