incubator-empire-db-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francis De Brabandere <franci...@gmail.com>
Subject Re: on delete/update cascade
Date Thu, 06 May 2010 10:10:08 GMT
https://issues.apache.org/jira/browse/EMPIREDB-79

On Thu, May 6, 2010 at 11:02 AM, Rainer Döbele <doebele@esteam.de> wrote:
> 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
>
>



-- 
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.

Mime
View raw message