You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@cayenne.apache.org by "Mike Kienenberger (JIRA)" <ji...@apache.org> on 2006/04/20 18:20:44 UTC

[JIRA] Created: (CAY-522) Generate schema code creates unsupported cross-Schema constraints for Oracle

Generate schema code creates unsupported cross-Schema constraints for Oracle
----------------------------------------------------------------------------

         Key: CAY-522
         URL: http://issues.apache.org/cayenne/browse/CAY-522
     Project: Cayenne
        Type: Bug

  Components: Cayenne Core Library  
    Versions: 1.2 [BETA]    
    Reporter: Mike Kienenberger
    Priority: Minor
     Fix For: AFTER 1.2


For Oracle, I noticed that the modeler is attempting to create a cross-schema constraint.   The modeler stop generating these kinds of SQL 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

On 4/20/06, Andrus Adamchik <an...@objectstyle.org> wrote:
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/cayenne/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira