Hi Fay,

The SQL is the same for 1.1.0 and 1.2.0.
I'm not sure why its not working on 1.3.0-SNAPSHOT.

Here are those missing classes:

public class TblItmtyp extends BaseEntity {

//      Mapped Fields
        @Id
        @Column(name = "ITMTYP_CDE",nullable=false)
        private String itmtypCde;    

        @Version
        @Column(name = "VRS_NBR")
        private Integer vrsNbr;   

        @Basic
        @Column(name = "DPLODR_NBR",nullable=true) 
        private Integer dplodrNbr;

        @Basic
        @Column(name = "DPL_IND",nullable=true) 
        private Integer dplInd;

        @Basic
        @Column(name = "ITMTYP_NME",nullable=true) 
        private String itmtypNme;

        @Transient
        private Boolean checked = false;


//      Mapped Relationships
        @OneToMany(mappedBy="tblItmtyp",fetch = FetchType.LAZY,cascade = {
CascadeType.PERSIST,CascadeType.MERGE })
        private Collection<TblTrkitm> tblTrkitms = new ArrayList<TblTrkitm>();
        @OneToMany(mappedBy="tblItmtyp",fetch = FetchType.LAZY,cascade = {
CascadeType.PERSIST,CascadeType.MERGE })
        private Collection<TblTrklnk> tblTrklnks = new ArrayList<TblTrklnk>();
        public String getItmtypCde() {
                return getString(itmtypCde);
        }
        public void setItmtypCde(String itmtypCde) {
                this.itmtypCde = itmtypCde;
        }
        public Integer getVrsNbr() {
                return getInteger(vrsNbr);
        }
        public void setVrsNbr(Integer vrsNbr) {
                this.vrsNbr = vrsNbr;
        }

        public Integer getDplodrNbr() {
                return getInteger(dplodrNbr);
        }
        public void setDplodrNbr(Integer dplodrNbr) {
                this.dplodrNbr = dplodrNbr;
        }

        public Integer getDplInd() {
                return getInteger(dplInd);
        }
        public void setDplInd(Integer dplInd) {
                this.dplInd = dplInd;
        }

        public String getItmtypNme() {
                return getString(itmtypNme);
        }
        public void setItmtypNme(String itmtypNme) {
                this.itmtypNme = itmtypNme;
        }
        public Collection<TblTrkitm> getTblTrkitms() {
                if (tblTrkitms == null) {
                        tblTrkitms = new ArrayList<TblTrkitm>();
                }
                return tblTrkitms;
        }
        public void setTblTrkitms(Collection<TblTrkitm> tblTrkitms) {
                this.tblTrkitms = tblTrkitms;
        }
        public void addTblTrkitm(TblTrkitm tblTrkitm) {
                tblTrkitm.setTblItmtyp(this);
                getTblTrkitms().add(tblTrkitm);
        }
        public void removeTblTrkitm(TblTrkitm tblTrkitm) {
                tblTrkitm.setTblItmtyp(null);
                getTblTrkitms().remove(tblTrkitm);
        }
        public Collection<TblTrklnk> getTblTrklnks() {
                if (tblTrklnks == null) {
                        tblTrklnks = new ArrayList<TblTrklnk>();
                }
                return tblTrklnks;
        }
        public void setTblTrklnks(Collection<TblTrklnk> tblTrklnks) {
                this.tblTrklnks = tblTrklnks;
        }
        public void addTblTrklnk(TblTrklnk tblTrklnk) {
                tblTrklnk.setTblItmtyp(this);
                getTblTrklnks().add(tblTrklnk);
        }
        public void removeTblTrklnk(TblTrklnk tblTrklnk) {
                tblTrklnk.setTblItmtyp(null);
                getTblTrklnks().remove(tblTrklnk);
        }
        protected void synchParentRelationships(){
                getItmtypCde();

        }
        protected void synchChildRelationships(){
                syncCollection(getTblTrkitms());
                syncCollection(getTblTrklnks());
        }

        public Boolean getChecked() {
                return checked;
        }
        public void setChecked(Boolean checked) {
                this.checked = checked;
        }
}

public class TblTrkdet extends BaseEntity {

//      Mapped Fields

@TableGenerator(name="tblTrkdetGenerator",schema="EBSTATUS",table="TBL_KEYGEN",pkColumnName="PRIMARY_KEY_COLUMN"
        
,valueColumnName="LAST_USED_ID",pkColumnValue="TBL_TRKDET_ID",allocationSize=1)
                @Id
        
@GeneratedValue(strategy=GenerationType.TABLE,generator="tblTrkdetGenerator")
                @Column(name = "TRKDET_ID",nullable=false)
                private Integer trkdetId;    

        @Version
        @Column(name = "VRS_NBR")
        private Integer vrsNbr;   

        @Basic
        @Column(name = "ADM_CDE",nullable=true) 
        private String admCde;

        @Basic
        @Column(name = "ADM_TXT",nullable=true) 
        private String admTxt;

        @Basic
        @Column(name = "ASTVAL_TXT",nullable=true) 
        private String astvalTxt;

        @Basic
        @Column(name = "BRKCMM_AMT",nullable=true) 
        private BigDecimal brkcmmAmt;

        @Basic
        @Column(name = "COR_CDE",nullable=true) 
        private String corCde;

        @Basic
        @Column(name = "CSE_CDE",nullable=true) 
        private String cseCde;

        @Basic
        @Column(name = "CSL_CDE",nullable=true) 
        private String cslCde;

        @Basic
        @Column(name = "CSL_TXT",nullable=true) 
        private String cslTxt;

        @Basic
        @Column(name = "DPLODR_NBR",nullable=true) 
        private Integer dplodrNbr;

        @Basic
        @Column(name = "EFC_DTE",nullable=true) 
        @Temporal (TemporalType.DATE)
        private Date efcDte;

        @Basic
        @Column(name = "EMPCTB_AMT",nullable=true) 
        private BigDecimal empctbAmt;

        @Basic
        @Column(name = "FND_CDE",nullable=true) 
        private String fndCde;

        @Basic
        @Column(name = "FND_IND",nullable=true) 
        private Integer fndInd;

        @Basic
        @Column(name = "FNL_AMT",nullable=true) 
        private BigDecimal fnlAmt;

        @Basic
        @Column(name = "ITM_CDE",nullable=true) 
        private String itmCde;

        @Basic
        @Column(name = "MEM_CNR",nullable=true) 
        private Integer memCnr;

        @Basic
        @Column(name = "VLU_DTE",nullable=true) 
        @Temporal (TemporalType.DATE)
        private Date vluDte;

        @Basic
        @Column(name = "RLECTCFND_ID",nullable=true) 
        private Integer rlectcfndId;

        @Basic
        @Column(name = "RMGMEM_CNR",nullable=true) 
        private Integer rmgmemCnr;

        @Basic
        @Column(name = "RSKBNF_CDE",nullable=true) 
        private String rskbnfCde;

        @Basic
        @Column(name = "RSKTMN_DTE",nullable=true) 
        @Temporal (TemporalType.DATE)
        private Date rsktmnDte = Mapping.DEFAULT_DATE;

        @Basic
        @Column(name = "RSVACC_VAL",nullable=true) 
        private BigDecimal rsvaccVal;

        @Basic
        @Column(name = "RSV_IND",nullable=true) 
        private Integer rsvInd;

        @Basic
        @Column(name = "SCT27APP_DTE",nullable=true) 
        @Temporal (TemporalType.DATE)
        private Date sct27appDte;

        @Basic
        @Column(name = "SCT27NSA_IND",nullable=true) 
        private Integer sct27nsaInd;

        @Basic
        @Column(name = "SCT27TYP_DTA",nullable=true) 
        private String sct27typDta;

        @Basic
        @Column(name = "FSB_NME",nullable=true) 
        private String fsbNme;

        @Basic
        @Column(name = "FSB_CDE",nullable=true) 
        private String fsbCde;
        
        @Basic
        @Column(name = "XFRTYP_CDE",nullable=true) 
        private String xfrtypCde = "0";

        @Basic
        @Column(name = "TMNTYP_CDE",nullable=true) 
        private String tmntypCde = "0"; //default

        @Basic
        @Column(name = "TMNTYP_TXT",nullable=true) 
        private String tmntypTxt;

        @Basic
        @Column(name = "VLUDTE_IND",nullable=true) 
        private Integer vludteInd;


//      Mapped Relationships
        @OneToMany(mappedBy="tblTrkdet",fetch = FetchType.EAGER,cascade = {
CascadeType.PERSIST,CascadeType.MERGE,CascadeType.REMOVE })
        private Collection<TblTrkitm> tblTrkitms = new ArrayList<TblTrkitm>();
        
        @OneToOne(mappedBy="tblTrkdet",fetch = FetchType.LAZY,cascade = {
CascadeType.PERSIST,CascadeType.MERGE,CascadeType.REMOVE }) 
        private TblTrkdetcng tblTrkdetcng;
        
        @ManyToOne(fetch = FetchType.LAZY,cascade = {
CascadeType.PERSIST,CascadeType.MERGE })
        @JoinColumns([EMAIL PROTECTED](name =
"RLECTCFND_ID",referencedColumnName="RLECTCFND_ID")})    
        @ForeignKey
        private TblRlectcfnd tblRlectcfnd; 
        
        @ManyToOne(fetch = FetchType.LAZY)
        @JoinColumns([EMAIL PROTECTED](name =
"ITM_CDE",referencedColumnName="ITM_CDE")})    
        @ForeignKey
        private TblItmdes tblItmdes; 
        
        @ManyToOne(fetch = FetchType.LAZY)
        @JoinColumns([EMAIL PROTECTED](name =
"CSL_TXT",referencedColumnName="CDETYP_TXT"),@JoinColumn(name =
"CSL_CDE",referencedColumnName="CDE_VAL")})    
        @ForeignKey
        private TblCdedes tblCdedes;  
        
        @ManyToOne(fetch = FetchType.LAZY)
        @JoinColumns([EMAIL PROTECTED](name =
"ADM_TXT",referencedColumnName="CDETYP_TXT"),@JoinColumn(name =
"ADM_CDE",referencedColumnName="CDE_VAL")})    
        @ForeignKey
        private TblCdedes tblCdedes1; 
        
        @ManyToOne(fetch = FetchType.LAZY)
        @JoinColumns([EMAIL PROTECTED](name =
"FND_CDE",referencedColumnName="FND_CDE")})    
        @ForeignKey
        private TblFndmst tblFndmst;  
        
        @ManyToOne(fetch = FetchType.LAZY)
        @JoinColumns([EMAIL PROTECTED](name =
"TMNTYP_TXT",referencedColumnName="CDETYP_TXT"),@JoinColumn(name =
"TMNTYP_CDE",referencedColumnName="CDE_VAL")})    
        @ForeignKey
        private TblCdedes tblCdedes2;   
        
        public Integer getTrkdetId() {
                return getInteger(trkdetId);
        }
        public void setTrkdetId(Integer trkdetId) {
                this.trkdetId = trkdetId;
        }
        public Integer getVrsNbr() {
                return getInteger(vrsNbr);
        }
        public void setVrsNbr(Integer vrsNbr) {
                this.vrsNbr = vrsNbr;
        }

        public String getAdmCde() {
                return getString(admCde);
        }
        public void setAdmCde(String admCde) {
                this.admCde = admCde;
        }

        public String getAdmTxt() {
                return getString(admTxt);
        }
        public void setAdmTxt(String admTxt) {
                this.admTxt = admTxt;
        }

        public String getAstvalTxt() {
                return getString(astvalTxt);
        }
        public void setAstvalTxt(String astvalTxt) {
                this.astvalTxt = astvalTxt;
        }

        public BigDecimal getBrkcmmAmt() {
                return getBigDecimal(brkcmmAmt);
        }
        public void setBrkcmmAmt(BigDecimal brkcmmAmt) {
                this.brkcmmAmt = brkcmmAmt;
        }

        public String getCorCde() {
                return getString(corCde);
        }
        public void setCorCde(String corCde) {
                this.corCde = corCde;
        }

        public String getCseCde() {
                return getString(cseCde);
        }
        public void setCseCde(String cseCde) {
                this.cseCde = cseCde;
        }

        public String getCslCde() {
                return getString(cslCde);
        }
        public void setCslCde(String cslCde) {
                this.cslCde = cslCde;
        }

        public String getCslTxt() {
                return getString(cslTxt);
        }
        public void setCslTxt(String cslTxt) {
                this.cslTxt = cslTxt;
        }

        public Integer getDplodrNbr() {
                return getInteger(dplodrNbr);
        }
        public void setDplodrNbr(Integer dplodrNbr) {
                this.dplodrNbr = dplodrNbr;
        }

        public Date getEfcDte() {
                return getDate(efcDte);
        }
        public void setEfcDte(Date efcDte) {
                this.efcDte = efcDte;
        }

        public BigDecimal getEmpctbAmt() {
                return getBigDecimal(empctbAmt);
        }
        public void setEmpctbAmt(BigDecimal empctbAmt) {
                this.empctbAmt = empctbAmt;
        }

        public String getFndCde() {
                return fndCde;
        }
        public void setFndCde(String fndCde) {
                this.fndCde = fndCde;
        }

        public Integer getFndInd() {
                return getInteger(fndInd);
        }
        public void setFndInd(Integer fndInd) {
                this.fndInd = fndInd;
        }

        public BigDecimal getFnlAmt() {
                return getBigDecimal(fnlAmt);
        }
        public void setFnlAmt(BigDecimal fnlAmt) {
                this.fnlAmt = fnlAmt;
        }

        public String getItmCde() {
                return getString(itmCde);
        }
        public void setItmCde(String itmCde) {
                this.itmCde = itmCde;
        }

        public Integer getMemCnr() {
                return getInteger(memCnr);
        }
        public void setMemCnr(Integer memCnr) {
                this.memCnr = memCnr;
        }

        public Integer getRlectcfndId() {
                return getInteger(rlectcfndId);
        }
        public void setRlectcfndId(Integer rlectcfndId) {
                this.rlectcfndId = rlectcfndId;
        }

        public Integer getRmgmemCnr() {
                return getInteger(rmgmemCnr);
        }
        public void setRmgmemCnr(Integer rmgmemCnr) {
                this.rmgmemCnr = rmgmemCnr;
        }

        public String getRskbnfCde() {
                return getString(rskbnfCde);
        }
        public void setRskbnfCde(String rskbnfCde) {
                this.rskbnfCde = rskbnfCde;
        }

        public Date getRsktmnDte() {
                return getDate(rsktmnDte);
        }
        public void setRsktmnDte(Date rsktmnDte) {
                this.rsktmnDte = rsktmnDte;
        }

        public BigDecimal getRsvaccVal() {
                return getBigDecimal(rsvaccVal);
        }
        public void setRsvaccVal(BigDecimal rsvaccVal) {
                this.rsvaccVal = rsvaccVal;
        }

        public Integer getRsvInd() {
                return getInteger(rsvInd);
        }
        public void setRsvInd(Integer rsvInd) {
                this.rsvInd = rsvInd;
        }

        public Date getSct27appDte() {
                return getDate(sct27appDte);
        }
        public void setSct27appDte(Date sct27appDte) {
                this.sct27appDte = sct27appDte;
        }

        public Integer getSct27nsaInd() {
                return getInteger(sct27nsaInd);
        }
        public void setSct27nsaInd(Integer sct27nsaInd) {
                this.sct27nsaInd = sct27nsaInd;
        }

        public String getSct27typDta() {
                return getString(sct27typDta);
        }
        public void setSct27typDta(String sct27typDta) {
                this.sct27typDta = sct27typDta;
        }

        public String getTmntypCde() {
                return getString(tmntypCde);
        }
        public void setTmntypCde(String tmntypCde) {
                this.tmntypCde = tmntypCde;
        }

        public String getTmntypTxt() {
                return getString(tmntypTxt);
        }
        public void setTmntypTxt(String tmntypTxt) {
                this.tmntypTxt = tmntypTxt;
        }

        public Integer getVludteInd() {
                return getInteger(vludteInd);
        }
        public void setVludteInd(Integer vludteInd) {
                this.vludteInd = vludteInd;
        }
        public Collection<TblTrkitm> getTblTrkitms() {
                if (tblTrkitms == null) {
                        tblTrkitms = new ArrayList<TblTrkitm>();
                }
                return tblTrkitms;
        }
        public void setTblTrkitms(Collection<TblTrkitm> tblTrkitms) {
                this.tblTrkitms = tblTrkitms;
        }
        public void addTblTrkitm(TblTrkitm tblTrkitm) {
                tblTrkitm.setTblTrkdet(this);
                getTblTrkitms().add(tblTrkitm);
        }
        public void removeTblTrkitm(TblTrkitm tblTrkitm) {
                tblTrkitm.setTblTrkdet(null);
                getTblTrkitms().remove(tblTrkitm);
        }
        public TblTrkdetcng getTblTrkdetcng() {
                return tblTrkdetcng;
        }
        public void setTblTrkdetcng(TblTrkdetcng tblTrkdetcng) {
                this.tblTrkdetcng = tblTrkdetcng;
                if(tblTrkdetcng!=null){
                        tblTrkdetcng.setTblTrkdet(this);
                }       
        }
        public TblRlectcfnd getTblRlectcfnd() {
                return tblRlectcfnd;
        }
        public void setTblRlectcfnd(TblRlectcfnd tblRlectcfnd) {
                this.tblRlectcfnd = tblRlectcfnd;
                if(tblRlectcfnd!=null&&tblRlectcfnd.getRlectcfndId()!=null){
                        setRlectcfndId(tblRlectcfnd.getRlectcfndId());
                }       
        }
        public TblItmdes getTblItmdes() {
                return tblItmdes;
        }
        public void setTblItmdes(TblItmdes tblItmdes) {
                this.tblItmdes = tblItmdes;
                if(tblItmdes!=null&&tblItmdes.getItmCde()!=null){
                        setItmCde(tblItmdes.getItmCde());
                }       
        }
        public TblCdedes getTblCdedes() {
                return tblCdedes;
        }
        public void setTblCdedes(TblCdedes tblCdedes) {
                this.tblCdedes = tblCdedes;
        
if(tblCdedes!=null&&tblCdedes.getCdetypTxt()!=null&&tblCdedes.getCdeVal()!=null){
                        setCslTxt(tblCdedes.getCdetypTxt());
                        setCslCde(tblCdedes.getCdeVal());
                }       
        }
        public TblCdedes getTblCdedes1() {
                return tblCdedes1;
        }
        public void setTblCdedes1(TblCdedes tblCdedes1) {
                this.tblCdedes1 = tblCdedes1;
        
if(tblCdedes1!=null&&tblCdedes1.getCdetypTxt()!=null&&tblCdedes1.getCdeVal()!=null){
                        setAdmTxt(tblCdedes1.getCdetypTxt());
                        setAdmCde(tblCdedes1.getCdeVal());
                }       
        }
        public TblFndmst getTblFndmst() {
                return tblFndmst;
        }
        
        public void setTblFndmst(TblFndmst tblFndmst) {
                this.tblFndmst = tblFndmst;
                if(tblFndmst!=null&&tblFndmst.getFndCde()!=null){
                        setFndCde(tblFndmst.getFndCde());
                }       
        }
        public TblCdedes getTblCdedes2() {
                return tblCdedes2;
        }
        public void setTblCdedes2(TblCdedes tblCdedes2) {
                this.tblCdedes2 = tblCdedes2;
        
if(tblCdedes2!=null&&tblCdedes2.getCdetypTxt()!=null&&tblCdedes2.getCdeVal()!=null){
                        setTmntypTxt(tblCdedes2.getCdetypTxt());
                        setTmntypCde(tblCdedes2.getCdeVal());
                }       
        }
        protected void synchParentRelationships(){
                getTrkdetId();

                if (needsToSynch(getTblRlectcfnd())) {
                        setTblRlectcfnd(getTblRlectcfnd());
                }
                if (needsToSynch(getTblItmdes())) {
                        setTblItmdes(getTblItmdes());
                }
                if (needsToSynch(getTblCdedes())) {
                        setTblCdedes(getTblCdedes());
                }
                if (needsToSynch(getTblCdedes1())) {
                        setTblCdedes1(getTblCdedes1());
                }
                if (needsToSynch(getTblFndmst())) {
                        setTblFndmst(getTblFndmst());
                }
                if (needsToSynch(getTblCdedes2())) {
                        setTblCdedes2(getTblCdedes2());
                }
        }
        protected void synchChildRelationships(){
                syncCollection(getTblTrkitms());
                syncObject(getTblTrkdetcng());
        }
        public Date getVluDte() {
                return vluDte;
        }
        public void setVluDte(Date vluDte) {
                this.vluDte = vluDte;
        }
        public String getFsbNme() {
                return fsbNme;
        }
        public void setFsbNme(String fsbNme) {
                this.fsbNme = fsbNme;
        }
        public String getFsbCde() {
                return fsbCde;
        }
        public void setFsbCde(String fsbCde) {
                this.fsbCde = fsbCde;
        }
        public String getXfrtypCde() {
                return xfrtypCde;
        }
        public void setXfrtypCde(String xfrtypCde) {
                this.xfrtypCde = xfrtypCde;
        }
        
}



Fay Wang wrote:
> 
> Hi Enrico,
>    I made up TblItmtyp and TblTrkdet and ran a test case with the code
> snippet you provided. It worked just fine. You mentioned that the test
> case works fine with 1.2.0. Can you provide the generated sql on 1.2.0? 
> 
> Regards,
> Fay   
> 
> 

-- 
View this message in context: 
http://n2.nabble.com/Exception-in-SQLBuffer.java-on-OpenJPA-1.3.0-SNAPSHOT-tp1141997p1300409.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Reply via email to