Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 41067 invoked from network); 13 Feb 2007 16:42:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Feb 2007 16:42:18 -0000 Received: (qmail 19639 invoked by uid 500); 13 Feb 2007 16:42:26 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 19395 invoked by uid 500); 13 Feb 2007 16:42:25 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 19386 invoked by uid 99); 13 Feb 2007 16:42:25 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Feb 2007 08:42:25 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [207.210.96.236] (HELO byaroza.objectstyle.org) (207.210.96.236) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 13 Feb 2007 08:42:15 -0800 Received: (qmail 1455 invoked from network); 13 Feb 2007 16:40:28 -0000 Received: from unknown (HELO ??2?????IPv6:::1?) (127.0.0.1) by localhost with SMTP; 13 Feb 2007 16:40:28 -0000 In-Reply-To: References: <49D23F7404DC5B4086D7352312597E0FD266F3@FNHH-SVMEXDB002.Freenet-AG.de> <9C0776C5-892F-4A7C-95C6-038D99E9F8DE@objectstyle.org> Mime-Version: 1.0 (Apple Message framework v752.3) X-Priority: 3 Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <4CEEC094-239F-413C-9642-495EBEFA89E2@objectstyle.org> Content-Transfer-Encoding: 7bit From: Andrus Adamchik Subject: Re: How do you deal with AS400 schemas Date: Tue, 13 Feb 2007 11:40:29 -0500 To: user@cayenne.apache.org X-Mailer: Apple Mail (2.752.3) X-Virus-Checked: Checked by ClamAV on apache.org 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 >