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

• Previous message: Ayhan Kondoz (JIRA): "[JIRA] Created: (CAY-521) Instantiation of wrong Classes if more the 1 class has the same name (within different packages)"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <andru..bjectstyle.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

• Next message: JIRA: "[JIRA] Created: (CAY-523) Add support for Microsoft Access Adapter so as to support isGenerated"
• Previous message: Ayhan Kondoz (JIRA): "[JIRA] Created: (CAY-521) Instantiation of wrong Classes if more the 1 class has the same name (within different packages)"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Thu Apr 20 2006 - 12:21:48 EDT