Re: How do you deal with AS400 schemas

From: Frank Rocco (farocc..otmail.com)
Date: Tue Feb 13 2007 - 19:46:00 EST

  • Next message: Peter Schröder: "AW: AW: cayenne with jetty6"

    Hi Andrus,

    Ok, I am home now and will try it out tomorrow.
    Thanks for getting right on this.

    Regards,

    Frank Rocco
    farocc..otmail.com

    >From: Andrus Adamchik <andru..bjectstyle.org>
    >Reply-To: use..ayenne.apache.org
    >To: use..ayenne.apache.org
    >Subject: Re: How do you deal with AS400 schemas
    >Date: Tue, 13 Feb 2007 18:26:11 -0500
    >
    >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 : Tue Feb 13 2007 - 19:46:35 EST