db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ronald Rudy <ronchal...@gmail.com>
Subject Re: how to cascade on update? Not possible?
Date Tue, 16 Mar 2010 01:46:25 GMT
I believe you want to look at this: http://db.apache.org/derby/manuals/reference/sqlj32.html

Specifically the referential ON UPDATE in constraints.  The only "ON UPDATE" actions that
are allowed are "NO ACTION" and "RESTRICT"; Derby does not appear to support cascading updates.
 You can log a feature request, I believe there might already be one for it based on this
thread: http://old.nabble.com/ON-UPDATE-CASCADE-in-derby-td1633870.html

Incidentally I do believe that MySQL supports on update cascade with its INNODB engine, and
I do think MS SQL does as well (http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx)

On Mar 15, 2010, at 8:38:12 PM, Rick Genter wrote:

> I'm not aware of any database that does this. I know that MS SQL Server does
> not.
> On 3/15/10 3:35 PM, "Gabriele Kahlout" <gabriele@mysimpatico.com> wrote:
>> I was pretty convinced, that in an update if the referenced column is
>> updated so is the refererring. How can one achieve this behavior
>> automatically?
> -- 
> Rick Genter
> Principal Software Engineer
> Silverlink Communications

View raw message