Hi Joe, you are right, 'on delete cascade' or 'on update cascade' is currently not provided with the DDL generation of relations. DBTable.setDeleteCascade does an internal cascading and is not the same.
For the moment I can only recommend to derive a class from the database driver class you are using and override the method "createRelation(DBRelation r, DBSQLScript script)". Copy the code from the base class and add the cascade statements you require. I will put this on our TODO list in order to provide a more convenient solution for all databases. Rainer Joe Thurbon wrote: > re: on delete/update cascade > > Is there some way to specify 'on delete cascade' or 'on update cascade' > on foreign key constraints within empire-db? > > I have found the method DBTable.setDeleteCascade(boolean), but that > seems to affect only the Java object, not actually modify the foreign > key constraint in the database. It also seems to affect all of the > foreign key constraints on the table, which is not what I want. > > It seems like the 'correct' place for it would be in the DBReference or > DBRelation class, but I had no joy looking there. > > Cheers, > Joe
