Hello.
I made some progress, integrated enum support and will hopefully soon post a
new version.
Please help me with my next problem: I try to generate the ddl with this
alter table statement:
ALTER TABLE MOON ADD CONSTRAINT FK_MOON_PLANET
FOREIGN KEY (PLANET_ID) REFERENCES PLANET (ID) ON DELETE CASCADE
;
If a planet ist deleted, all moons should be deleted too. Actually, the
statement is missing the part "ON DELETE CASCADE". When running the
generated web example, deletion of planets result into a sql exception
because of the foreign key constraint violation. Dropping and creating the
tables with the ALTER TABLE statement listed above works fine.
Changing the property db.custom.onDeleteCascade to true does not help.
Reading the oracle.xpt and dbhelper.ext did not clarify the issue for me.
Here is the snippet from the CustomDDL.xpt:
«DEFINE foreignKeyConstraint FOR Reference-»
ALTER TABLE «from.getDatabaseName()» ADD CONSTRAINT
FK_«truncateLongDatabaseName(from.getDatabaseName() + "_" +
getDatabaseName())»
FOREIGN KEY («getForeignKeyName()») REFERENCES
«to.getRootExtends().getDatabaseName()» (ID)«IF isDbOnDeleteCascade()» ON
DELETE CASCADE«ENDIF»
;
«ENDDEFINE»
I'm grateful for any hints.
Kind Regards,
René
--
View this message in context:
http://www.nabble.com/Starting-Support-for-Apache-Derby-tp14804464s17564p14879789.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
