Add support for "On Delete" and "On Update" in schema XML for foreign keys
--------------------------------------------------------------------------
Key: DDLUTILS-75
URL: http://issues.apache.org/jira/browse/DDLUTILS-75
Project: DdlUtils
Type: Improvement
Environment: Oracle 10g Express Edition
Windows XP
Java 1.5.0
Ant 1.6.5
Reporter: Guy Davis
Assigned to: Thomas Dudziak
Priority: Critical
Currently, when dumping the schema from a live database to XML, the 'on delete'
and 'on update' rules for foreign keys are ignored. As shown in the DTD for
database.dtd (below), the attributes onDelete and onUpdate should translate
into "on delete cascade" for example in the target SQL.
<!ELEMENT foreign-key (reference+)>
<!ATTLIST foreign-key
foreignTable CDATA #REQUIRED
name CDATA #IMPLIED
onUpdate (cascade|setnull|restrict|none) "none"
onDelete (cascade|setnull|restrict|none) "none"
>
If the dump (DatabaseToDdl) is modified to write these attributes out, then the
schema load (DdlToDatabase) needs to handle them and set the correct behavior
on the foreign key creation.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
