How do I query a joined table in cayenne?

From: Frank (farocc..otmail.com)
Date: Fri Feb 23 2007 - 10:49:32 EST

  • Next message: Dov Rosenberg: "Cayenne vs JPA tools"

    Hello,

    I cannot figure out how to query the pcldds, pcdep4 fields
    What am I doing wrong?

    Thanks

    Frank

    ** Java Code Start
     DataContext context = DataContext.getThreadDataContext();
         Integer[] hspArray = {new Integer(1), new Integer(5)};
         Expression e = ExpressionFactory.inDbExp(Bsypemp.EMHSPPOUND_PK_COLUMN,
    hspArray);
            e =
    e.andExp(ExpressionFactory.likeIgnoreCaseExp(Bsypemp.EMYLNM_PROPERTY, lname
            +"%"));
            e =
    e.andExp(ExpressionFactory.likeIgnoreCaseExp(Bsypemp.EMYFNM_PROPERTY, fname
                    +"%"));
           // I'm lost here e =
    e.andExp(ExpressionFactory.likeIgnoreCaseExp(Bsypemp.class.DEPARTMENTS_PROPERTY,
    pcldds
           // +"%"));

         SelectQuery query = new SelectQuery(Bsypemp.class,e);
         List records = context.performQuery(query);
    ** Java Code End

    Here is my first class
    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_MWPHPOUND_PROPERTY = "eMWPHpound";
        public static final String EMOTSH_PROPERTY = "emotsh";
        public static final String EMSCH_PROPERTY = "emsch";
        public static final String EMYFNM_PROPERTY = "emyfnm";
        public static final String EMYLNM_PROPERTY = "emylnm";
        public static final String DEPARTMENTS_PROPERTY = "departments";

        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 setEMWPHpound(java.math.BigDecimal eMWPHpound) {
            writeProperty("eMWPHpound", eMWPHpound);
        }
        public java.math.BigDecimal getEMWPHpound() {
            return (java.math.BigDecimal)readProperty("eMWPHpound");
        }

        public void setEmotsh(String emotsh) {
            writeProperty("emotsh", emotsh);
        }
        public String getEmotsh() {
            return (String)readProperty("emotsh");
        }

        public void setEmsch(String emsch) {
            writeProperty("emsch", emsch);
        }
        public String getEmsch() {
            return (String)readProperty("emsch");
        }

        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");
        }

        public void setDepartments(stemc.cayenne.as400.Bprppcp departments) {
            setToOneTarget("departments", departments, true);
        }

        public stemc.cayenne.as400.Bprppcp getDepartments() {
            return (stemc.cayenne.as400.Bprppcp)readProperty("departments");
        }

    }

    Here is my second class
    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 PCDEP4_PROPERTY = "pcdep4";
        public static final String PCINA_PROPERTY = "pcina";
        public static final String PCLDDS_PROPERTY = "pcldds";
        public static final String PCSDDS_PROPERTY = "pcsdds";

        public static final String PCDEP4_PK_COLUMN = "PCDEP4";
        public static final String PCHSPPOUND_PK_COLUMN = "PCHSP#";

        public void setPcdep4(java.math.BigDecimal pcdep4) {
            writeProperty("pcdep4", pcdep4);
        }
        public java.math.BigDecimal getPcdep4() {
            return (java.math.BigDecimal)readProperty("pcdep4");
        }

        public void setPcina(String pcina) {
            writeProperty("pcina", pcina);
        }
        public String getPcina() {
            return (String)readProperty("pcina");
        }

        public void setPcldds(String pcldds) {
            writeProperty("pcldds", pcldds);
        }
        public String getPcldds() {
            return (String)readProperty("pcldds");
        }

        public void setPcsdds(String pcsdds) {
            writeProperty("pcsdds", pcsdds);
        }
        public String getPcsdds() {
            return (String)readProperty("pcsdds");
        }

    }

    This archive was generated by hypermail 2.0.0 : Fri Feb 23 2007 - 10:51:18 EST