cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Creating Oracle constraints across schemas
Date Thu, 20 Apr 2006 16:14:04 GMT

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


Mime
View raw message