Re: How do you deal with AS400 schemas

From: Frank (farocc..otmail.com)
Date: Wed Feb 28 2007 - 09:05:58 EST

  • Next message: Mike Kienenberger: "Re: expression to find out null relationship"

    Hi Andrus,
    I am running into another problem when I try to query the PK's
    My the look of the map generated, it looks like Cayenne is not removing the
    # for the PK's

    here is a snapshot;

     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#";

    Maybe I am just doing something wrong, but wanted to let you know.

    Frank
    ----- Original Message -----
    From: "Andrus Adamchik" <andru..bjectstyle.org>
    To: <use..ayenne.apache.org>
    Sent: Tuesday, February 13, 2007 6:26 PM
    Subject: Re: How do you deal with AS400 schemas

    > Frank,
    >
    > I put a patched version of Cayenne 1.2 here:
    >
    > http://people.apache.org/~aadamchik/patched/cayenne-1.2-dev-
    > win-02132007.zip
    >
    > Could you please give it a try and report how it worked? If it does, I'll
    > commit the fix, and it will be available officially in the future
    > versions of Cayenne.
    >
    > Thanks
    > Andrus
    >
    >
    >
    > On Feb 13, 2007, at 11:51 AM, Frank wrote:
    >
    >> Hi Andrus,
    >>
    >> I have submitted this as a open a bug report.
    >>
    >> Frank
    >>
    >> ----- Original Message ----- From: "Andrus Adamchik"
    >> <andru..bjectstyle.org>
    >> To: <use..ayenne.apache.org>
    >> Sent: Tuesday, February 13, 2007 11:40 AM
    >> Subject: Re: How do you deal with AS400 schemas
    >>
    >>
    >>> Hmm... I'd say this is a bug in Cayenne class generator. We need to
    >>> replace non-java chars with something more appropriate. Could you
    >>> please open a bug report:
    >>> https://issues.apache.org/cayenne/
    >>> Thanks
    >>> Andrus
    >>> On Feb 13, 2007, at 11:37 AM, Frank wrote:
    >>>> Hello,
    >>>> Cayenne is generating code that has # because our AS400 database
    >>>> tables use these as field names.
    >>>> Severity and Description Path Resource Location Creation Time Id
    >>>> Syntax error on token "Invalid Character", , expected jcdsurvey/ src/
    >>>> stemc/cayenne/as400/auto _Bsypemp.java line 199 1171384311117 13668
    >>>>
    >>>> public static final String EMEMP#_PK_COLUMN = "EMEMP#";
    >>>> public static final String EMHSP#_PK_COLUMN = "EMHSP#";
    >>>>
    >>>> Should I just use a Raw Sql?
    >>>> I had to remove the # from the objEntity as Cayenne complained.
    >>>>
    >>>> Thanks
    >>>>
    >>>> Frank
    >>>>
    >>>
    >>
    >
    >

    This archive was generated by hypermail 2.0.0 : Wed Feb 28 2007 - 09:06:40 EST