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 <[EMAIL PROTECTED]> 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
