Re: How do you deal with AS400 schemas

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Feb 13 2007 - 18:26:11 EST

  • Next message: Frank Rocco: "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 : Tue Feb 13 2007 - 18:26:44 EST