Jira: http://www.fornax-platform.org/tracker/browse/CSC-182
Fixed. Thank you for finding this.
The fault was that 'opposite' should have been used.
Oracle template looks like this now:
«DEFINE foreignKeyConstraint FOR Reference-»
ALTER TABLE «from.getDatabaseName()» ADD CONSTRAINT
FK_«truncateLongDatabaseName(from.getDatabaseName() + "_" +
getDatabaseName())»
FOREIGN KEY («getForeignKeyName()») REFERENCES
«to.getRootExtends().getDatabaseName()» (ID)«
IF (opposite != null) && opposite.isDbOnDeleteCascade()» ON DELETE
CASCADE«ENDIF»
;
«ENDDEFINE»
MySQL:
«DEFINE foreignKey FOR Reference-»
«IF "list" == collectionType-»
«getDatabaseName()»_INDEX INTEGER,
«ENDIF-»
«getForeignKeyName()» «getForeignKeyType()»,
FOREIGN KEY («getForeignKeyName()») REFERENCES
«to.getRootExtends().getDatabaseName()»(ID)«
IF (opposite != null) && opposite.isDbOnDeleteCascade()» ON DELETE
CASCADE«ENDIF»«ENDDEFINE»
/Patrik
--
View this message in context:
http://www.nabble.com/Starting-Support-for-Apache-Derby-tp14804464s17564p14886373.html
Sent from the Fornax-Platform mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Fornax-developer mailing list
Fornax-developer@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fornax-developer
