Return-Path: Delivered-To: apmail-incubator-cayenne-user-archive@locus.apache.org Received: (qmail 6699 invoked from network); 20 Apr 2006 16:14:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 20 Apr 2006 16:14:36 -0000 Received: (qmail 47855 invoked by uid 500); 20 Apr 2006 16:14:30 -0000 Delivered-To: apmail-incubator-cayenne-user-archive@incubator.apache.org Received: (qmail 47831 invoked by uid 500); 20 Apr 2006 16:14:29 -0000 Mailing-List: contact cayenne-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cayenne-user@incubator.apache.org Delivered-To: mailing list cayenne-user@incubator.apache.org Received: (qmail 47818 invoked by uid 99); 20 Apr 2006 16:14:29 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Apr 2006 09:14:29 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [64.124.179.114] (HELO mensk.objectstyle.org) (64.124.179.114) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 20 Apr 2006 09:14:28 -0700 Received: (qmail 7772 invoked from network); 20 Apr 2006 16:14:07 -0000 Received: from localhost (HELO ??@@IPv6:::1?) (127.0.0.1) by mensk.objectstyle.org with SMTP; 20 Apr 2006 16:14:07 -0000 Mime-Version: 1.0 (Apple Message framework v746.3) In-Reply-To: <8f985b960604200855gfb76f75r12fa08ec3dc84d72@mail.gmail.com> References: <8f985b960604200855gfb76f75r12fa08ec3dc84d72@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Andrus Adamchik Subject: Re: Creating Oracle constraints across schemas Date: Thu, 20 Apr 2006 20:14:04 +0400 To: cayenne-user@incubator.apache.org X-Mailer: Apple Mail (2.746.3) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On Apr 20, 2006, at 7:55 PM, Mike Kienenberger wrote: > I notice that the modeler is unable to create a constraint across a > schema, even when the two schemas are in the same database. Is this > to be expected? Yes. I don't think the RDBMS supports that (as the error below suggests). > If so, should the modeler stop generating these kinds > of statements? > > [SQL: ALTER TABLE ENG_WORK_MGMT.ENG_WORK ADD FOREIGN KEY (ENG_WORK_ID) > REFERENCES CORE_WORK_MGMT.STATUSABLE_WORK (ID)] - ORA-00942: table or > view does not exist Yeah, it should. There is currently a filter somewhere (DbGenerator??) that prevents FKs to be generated across DataNodes. Probably need to extend that to also check for different schemas in the same DataMap. Andrus