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.