Re: How do you deal with AS400 schemas

[Frank]

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" <[EMAIL PROTECTED]>
To: <user@cayenne.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" 
<[EMAIL PROTECTED]>
To: <user@cayenne.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