cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frank" <faro...@hotmail.com>
Subject How to query a relationship
Date Wed, 14 Feb 2007 15:59:05 GMT
Hello,

I have as AS400 relationship defined between two tables.
I need to include a column from the second table in my list.

Here is my error:
No matching getter method found for property Pcldds on class 
stemc.cayenne.as400.Bsypemp

Thanks
Frank

Here is my query:
Expression e = ExpressionFactory.matchDbExp

(Bsypemp.EMHSPPOUND_PK_COLUMN, new Integer(1));

e = e.andExp(ExpressionFactory.likeExp(Bsypemp.EMYLNM_PROPERTY, lname

+"%"));


SelectQuery query = new SelectQuery(Bsypemp.class,e);

List records = context.performQuery(query);

Here is my first table:
package stemc.cayenne.as400.auto;


/** Class _Bsypemp was generated by Cayenne.

* It is probably a good idea to avoid changing this class manually,

* since it may be overwritten next time code is regenerated.

* If you need to make any customizations, please use subclass.

*/

public class _Bsypemp extends org.objectstyle.cayenne.CayenneDataObject {


public static final String E_MEMPPOUND_PROPERTY = "eMEMPpound";

public static final String E_MHSPPOUND_PROPERTY = "eMHSPpound";

public static final String E_MWPHPOUND_PROPERTY = "eMWPHpound";

public static final String EMDEP4_PROPERTY = "emdep4";

public static final String EMYFNM_PROPERTY = "emyfnm";

public static final String EMYLNM_PROPERTY = "emylnm";


public static final String EMEMPPOUND_PK_COLUMN = "EMEMP#";

public static final String EMHSPPOUND_PK_COLUMN = "EMHSP#";


public void setEMEMPpound(java.math.BigDecimal eMEMPpound) {

writeProperty("eMEMPpound", eMEMPpound);

}

public java.math.BigDecimal getEMEMPpound() {

return (java.math.BigDecimal)readProperty("eMEMPpound");

}



public void setEMHSPpound(java.math.BigDecimal eMHSPpound) {

writeProperty("eMHSPpound", eMHSPpound);

}

public java.math.BigDecimal getEMHSPpound() {

return (java.math.BigDecimal)readProperty("eMHSPpound");

}



public void setEMWPHpound(java.math.BigDecimal eMWPHpound) {

writeProperty("eMWPHpound", eMWPHpound);

}

public java.math.BigDecimal getEMWPHpound() {

return (java.math.BigDecimal)readProperty("eMWPHpound");

}



public void setEmdep4(java.math.BigDecimal emdep4) {

writeProperty("emdep4", emdep4);

}

public java.math.BigDecimal getEmdep4() {

return (java.math.BigDecimal)readProperty("emdep4");

}



public void setEmyfnm(String emyfnm) {

writeProperty("emyfnm", emyfnm);

}

public String getEmyfnm() {

return (String)readProperty("emyfnm");

}



public void setEmylnm(String emylnm) {

writeProperty("emylnm", emylnm);

}

public String getEmylnm() {

return (String)readProperty("emylnm");

}



}

Here is my second table

package stemc.cayenne.as400.auto;


/** Class _Bprppcp was generated by Cayenne.

* It is probably a good idea to avoid changing this class manually,

* since it may be overwritten next time code is regenerated.

* If you need to make any customizations, please use subclass.

*/

public class _Bprppcp extends org.objectstyle.cayenne.CayenneDataObject {


public static final String P_CHSPPOUND_PROPERTY = "pCHSPpound";

public static final String PCDEP4_PROPERTY = "pcdep4";

public static final String PCLDDS_PROPERTY = "pcldds";


public static final String PCDEP4_PK_COLUMN = "PCDEP4";

public static final String PCHSPPOUND_PK_COLUMN = "PCHSP#";


public void setPCHSPpound(java.math.BigDecimal pCHSPpound) {

writeProperty("pCHSPpound", pCHSPpound);

}

public java.math.BigDecimal getPCHSPpound() {

return (java.math.BigDecimal)readProperty("pCHSPpound");

}



public void setPcdep4(java.math.BigDecimal pcdep4) {

writeProperty("pcdep4", pcdep4);

}

public java.math.BigDecimal getPcdep4() {

return (java.math.BigDecimal)readProperty("pcdep4");

}



public void setPcldds(String pcldds) {

writeProperty("pcldds", pcldds);

}

public String getPcldds() {

return (String)readProperty("pcldds");

}



}


Mime
View raw message